FILE STRUCTURE
Information from the survey are stored electronically in the form of data items. In some cases, items were formed directly from individual survey questions while in others, items were derived from answers to several questions (e.g. Body Mass Index derived from measured height and weight). Some items were derived with reference to information from other organisations such as the National Health and Medical Research Council (e.g. in relation to guidelines on consumption of alcohol).
Datasets from the National Health Survey are hierarchical in nature. A hierarchical data file is an efficient means of storing and retrieving information which describes one to many, or many to many, relationships e.g. a person may report multiple days on which alcohol was consumed and also multiple types of alcoholic beverages on each of these days.
Data about households and families are contained as individual characteristics on person records. While estimates are also available at the household level, estimates at the family level are not available from this survey. The data items and related output categories currently available for the NHS TableBuilder database, Basic CURF and Expanded CURF are available in Excel spreadsheets from the Downloads page of this product.
The following table shows the levels available in the microdata products and the information contained on those levels:
Level name | Table
Builder | Basic CURF | Expanded CURF | Information contained on level |
|
1. Household | X | X | X | Geographic classifications, household size and structure, dwelling characteristics and household income details |
2. Selected person | X | X | X | Demographic and socio-economic characteristics of survey respondents, and most of the health, health risks and related information they provided
|
3. Alcohol - Day consumed | X | X | X | Alcohol consumption on the three most recent days on which respondents reported consuming alcohol and the order of consumption |
4. Alcohol - Type consumed | X | X | X | Order of consumption, and the broad alcohol types and quantities for each type consumed on those days
|
5. Actions for NHPA Condition Groups | X | X | X | Effects of conditions and the actions taken |
6. Conditions | X | X | X | Information about health conditions reported by respondents |
7. Medications | X | X | X | Information on medications reported by respondents |
 |  |  |  |  |
The following table shows the hierarchical file structure and the relationship between each level: