Data dictionary for DHS data warehouse

Patrick Conheady made this Freedom of Information request to Department of Human Services

The request was refused by Department of Human Services.

From: Patrick Conheady

Delivered

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

Link to this

From: FOI.LEGAL.TEAM
Department of Human Services

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.

Link to this

From: FOI.LEGAL.TEAM
Department of Human Services


Attachment image001.png
12K Download

Attachment LEX 16962 Registration Acknowledgment letter.pdf
115K Download View as HTML


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.

 

show quoted sections

References

Visible links
1. mailto:[email address]

Link to this

From: Patrick Conheady

Delivered

Dear FOI.LEGAL.TEAM,

Your request for an extension until 10 February 2016 is granted.

Yours sincerely,

Patrick Conheady

Link to this

From: FOI.LEGAL.TEAM
Department of Human Services


Attachment image001.png
12K Download

Attachment LEX 16692 Section 24AB letter.pdf
304K Download View as HTML


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.

 

show quoted sections

References

Visible links
1. mailto:[email address]

Link to this

From: Patrick Conheady

Delivered

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.

Link to this

From: FOI.LEGAL.TEAM
Department of Human Services

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.

show quoted sections

Link to this

From: FOI.LEGAL.TEAM
Department of Human Services

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.

show quoted sections

Link to this

Things to do with this request

Anyone:
Department of Human Services only: