Data dictionary for DHS data warehouse
Dear Department of Human Services,
Please provide the data dictionary (or equivalent) for the Department's data warehouse(s) (or equivalent).
The requested documents should list tables, columns, the plain English meaning of each column and the relationships between tables (foreign keys, etc), and include all non-sensitive reference data such as the meanings of codes used in tables.
Yours faithfully,
Patrick Conheady
The FOI team will be closed from 24 December 2015 until 1 January 2016
(inclusive). Applications lodged during that period will be considered
when we re-open on 4 January 2016.
Dear Mr Conheady
Please find attached correspondence in relation to your Freedom of
Information request (LEX 16962).
Regards
Thomas Van Kints
FOI Practitioner
FOI Team
FOI and Litigation Branch | Legal Services Division
Department of Human Services
( Ext: 619655 | * [1][email address]
[2]Description: Description: Description: Description: Description:
Description: Description: Description: Description: Description:
Description: cid:image001.png@01CD1993.20C1C870
This email is intended for the use of the addressee and may contain
information that is confidential, commercially valuable or subject to
Legal Professional Privilege. Privilege is not waived by the mistaken
delivery of this email. If you are not the intended recipient of this
email you are notified that any use of dissemination of this communication
is strictly prohibited. If you have received this communication in error
please notify the sender immediately and permanently delete this email.
**********************************************************************
IMPORTANT: This e-mail is for the use of the intended recipient only and
may contain information that is confidential, commercially valuable and/or
subject to legal or parliamentary privilege. If you are not the intended
recipient you are notified that any review, re-transmission, disclosure,
dissemination or other use of, or taking of any action in reliance upon,
this information is prohibited and may result in severe penalties. If you
have received this e-mail in error please notify the sender immediately
and delete all electronic and hard copies of this transmission together
with any attachments. Please consider the environment before printing this
e-mail
**********************************************************************
References
Visible links
1. mailto:[email address]
Dear FOI.LEGAL.TEAM,
Your request for an extension until 10 February 2016 is granted.
Yours sincerely,
Patrick Conheady
Dear Mr Conheady
Please find attached correspondence in relation to your Freedom of
Information request (LEX 16962).
Regards
FOI Practitioner
FOI Team
FOI and Litigation Branch | Legal Services Division
Department of Human Services
* [1][email address]
[2]Description: Description: Description: Description: Description:
Description: Description: Description: Description: Description:
Description: cid:image001.png@01CD1993.20C1C870
This email is intended for the use of the addressee and may contain
information that is confidential, commercially valuable or subject to
Legal Professional Privilege. Privilege is not waived by the mistaken
delivery of this email. If you are not the intended recipient of this
email you are notified that any use of dissemination of this communication
is strictly prohibited. If you have received this communication in error
please notify the sender immediately and permanently delete this email.
**********************************************************************
IMPORTANT: This e-mail is for the use of the intended recipient only and
may contain information that is confidential, commercially valuable and/or
subject to legal or parliamentary privilege. If you are not the intended
recipient you are notified that any review, re-transmission, disclosure,
dissemination or other use of, or taking of any action in reliance upon,
this information is prohibited and may result in severe penalties. If you
have received this e-mail in error please notify the sender immediately
and delete all electronic and hard copies of this transmission together
with any attachments. Please consider the environment before printing this
e-mail
**********************************************************************
References
Visible links
1. mailto:[email address]
Dear FOI.LEGAL.TEAM,
I apologise for the delay in responding to you.
I am interested in revising the request to obtain documents that are referred to by DHS in developing queries for DHS's data warehouse(s). I would like to know how best to frame the request i.e. what documents exist and what they are known as. I also want to confine the request, as much as possible, to documents which are patently non-sensitive and therefore do not require you to expend time on redaction.
Could you please give me a phone number so that I can discuss this with you?
Yours sincerely,
-Pat.
Dear Mr Conheady,
Thank you for your email dated 17 February 2016 (copy below).
The FOI team is in the process of obtaining some suggestions from the Business Information and Data Services Branch about the kind of documents you may wish to consider requesting. We are hoping to receive a response from this Branch by mid next week. It is hoped that this information will assist you to make a new request under the Freedom of Information Act.
We will be in contact with you once we receive this advice.
If you have any queries in the meantime, please email [email address].
Kind regards
FOI Delegate
FOI and Litigation Branch | Legal Services Division
Department of Human Services
Doris Blackburn Building 18 Canberra Avenue Forrest ACT 2603
This email and any attachments may contain information subject to legal professional privilege or information that is otherwise sensitive or confidential. If you are not the intended recipient of this email, you are prohibited from using or disseminating this communication. If you have received this communication in error please notify the sender immediately and permanently delete this email.
-----Original Message-----
From: Patrick Conheady [mailto:[FOI #1459 email]]
Sent: Wednesday, 17 February 2016 3:04 PM
To: FOI.LEGAL.TEAM <[email address]>
Subject: Re: IMPORTANT - Your Freedom of Information request - Consultation [SEC=UNCLASSIFIED]
Dear FOI.LEGAL.TEAM,
I apologise for the delay in responding to you.
I am interested in revising the request to obtain documents that are referred to by DHS in developing queries for DHS's data warehouse(s). I would like to know how best to frame the request i.e. what documents exist and what they are known as. I also want to confine the request, as much as possible, to documents which are patently non-sensitive and therefore do not require you to expend time on redaction.
Could you please give me a phone number so that I can discuss this with you?
Yours sincerely,
-Pat.
-----Original Message-----
Dear Mr Conheady
Please find attached correspondence in relation to your Freedom of Information request (LEX 16962).
Regards
FOI Practitioner
FOI Team
FOI and Litigation Branch | Legal Services Division
Department of Human Services
* [1][email address]
[2]Description: Description: Description: Description: Description:
Description: Description: Description: Description: Description:
Description: cid:image001.png@01CD1993.20C1C870
This email is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to Legal Professional Privilege. Privilege is not waived by the mistaken delivery of this email. If you are not the intended recipient of this email you are notified that any use of dissemination of this communication is strictly prohibited. If you have received this communication in error please notify the sender immediately and permanently delete this email.
References
Visible links
1. mailto:[email address]
-------------------------------------------------------------------
Please use this email address for all replies to this request:
[FOI #1459 email]
This request has been made by an individual using Right to Know. This message and any reply that you make will be published on the internet. More information on how Right to Know works can be found at:
https://www.righttoknow.org.au/help/offi...
If you find this service useful as an FOI officer, please ask your web manager to link to us from your organisation's FOI page.
-------------------------------------------------------------------
********************************************************************** IMPORTANT: This e-mail is for the use of the intended recipient only and may contain information that is confidential, commercially valuable and/or subject to legal or parliamentary privilege. If you are not the intended recipient you are notified that any review, re-transmission, disclosure, dissemination or other use of, or taking of any action in reliance upon, this information is prohibited and may result in severe penalties. If you have received this e-mail in error please notify the sender immediately and delete all electronic and hard copies of this transmission together with any attachments. Please consider the environment before printing this e-mail **********************************************************************
Dear Mr Conheady,
The Business Information and Data Services Branch has suggested that you may wish to consider making a request with a more targeted scope. You could do this by requesting documents for one specific payment or subject area.
For example, a request could be made for one of the Medicare lines of business such as the Child Dental Benefits Scheme or the Australian Childhood Immunisation Register. Alternatively, you could consider a targeted request relating to the Centrelink or Child Support programmes.
We trust that this will assist you in formulating a new request.
If you have any queries, please email [DHS request email].
Kind regards
FOI Delegate
FOI and Litigation Branch | Legal Services Division
Department of Human Services
Doris Blackburn Building 18 Canberra Avenue Forrest ACT 2603
This email and any attachments may contain information subject to legal professional privilege or information that is otherwise sensitive or confidential. If you are not the intended recipient of this email, you are prohibited from using or disseminating this communication. If you have received this communication in error please notify the sender immediately and permanently delete this email.
-----Original Message-----
From: FOI.LEGAL.TEAM
Sent: Friday, 19 February 2016 12:50 PM
To: 'Patrick Conheady' <[FOI #1459 email]>
Subject: RE: IMPORTANT - Your Freedom of Information request - Consultation [SEC=UNCLASSIFIED]
Dear Mr Conheady,
Thank you for your email dated 17 February 2016 (copy below).
The FOI team is in the process of obtaining some suggestions from the Business Information and Data Services Branch about the kind of documents you may wish to consider requesting. We are hoping to receive a response from this Branch by mid next week. It is hoped that this information will assist you to make a new request under the Freedom of Information Act.
We will be in contact with you once we receive this advice.
If you have any queries in the meantime, please email [email address].
Kind regards
FOI Delegate
FOI and Litigation Branch | Legal Services Division Department of Human Services Doris Blackburn Building 18 Canberra Avenue Forrest ACT 2603
This email and any attachments may contain information subject to legal professional privilege or information that is otherwise sensitive or confidential. If you are not the intended recipient of this email, you are prohibited from using or disseminating this communication. If you have received this communication in error please notify the sender immediately and permanently delete this email.
-----Original Message-----
From: Patrick Conheady [mailto:[FOI #1459 email]]
Sent: Wednesday, 17 February 2016 3:04 PM
To: FOI.LEGAL.TEAM <[email address]>
Subject: Re: IMPORTANT - Your Freedom of Information request - Consultation [SEC=UNCLASSIFIED]
Dear FOI.LEGAL.TEAM,
I apologise for the delay in responding to you.
I am interested in revising the request to obtain documents that are referred to by DHS in developing queries for DHS's data warehouse(s). I would like to know how best to frame the request i.e. what documents exist and what they are known as. I also want to confine the request, as much as possible, to documents which are patently non-sensitive and therefore do not require you to expend time on redaction.
Could you please give me a phone number so that I can discuss this with you?
Yours sincerely,
-Pat.
-----Original Message-----
Dear Mr Conheady
Please find attached correspondence in relation to your Freedom of Information request (LEX 16962).
Regards
FOI Practitioner
FOI Team
FOI and Litigation Branch | Legal Services Division
Department of Human Services
* [1][email address]
[2]Description: Description: Description: Description: Description:
Description: Description: Description: Description: Description:
Description: cid:image001.png@01CD1993.20C1C870
This email is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to Legal Professional Privilege. Privilege is not waived by the mistaken delivery of this email. If you are not the intended recipient of this email you are notified that any use of dissemination of this communication is strictly prohibited. If you have received this communication in error please notify the sender immediately and permanently delete this email.
References
Visible links
1. mailto:[email address]
-------------------------------------------------------------------
Please use this email address for all replies to this request:
[FOI #1459 email]
This request has been made by an individual using Right to Know. This message and any reply that you make will be published on the internet. More information on how Right to Know works can be found at:
https://www.righttoknow.org.au/help/offi...
If you find this service useful as an FOI officer, please ask your web manager to link to us from your organisation's FOI page.
-------------------------------------------------------------------
********************************************************************** IMPORTANT: This e-mail is for the use of the intended recipient only and may contain information that is confidential, commercially valuable and/or subject to legal or parliamentary privilege. If you are not the intended recipient you are notified that any review, re-transmission, disclosure, dissemination or other use of, or taking of any action in reliance upon, this information is prohibited and may result in severe penalties. If you have received this e-mail in error please notify the sender immediately and delete all electronic and hard copies of this transmission together with any attachments. Please consider the environment before printing this e-mail **********************************************************************