• Print

The mental health data cubes contain detailed information from several mental-health related National Minimum Datasets administered by the AIHW. These are:

  • The Admitted Patient Mental Health Care NMDS which includes data on patients admitted to hospital who receive specialised psychiatric care, i.e. who are in a public psychiatric hospital or a psychiatric unit of an acute care hospital or who had a mental health-related principal diagnosis (for definitions, see AIHW publication Mental health services in Australia 2007-08). The variables included in the Admitted Patient data cubes are year of collection, sex, age group, same day separation flag, mental health legal status, type of separation, hospital type and principal diagnosis. The Admitted Patient data cubes present information on numbers of psychiatric care days, separations and patient days. The first Admitted Patients data cube contains information on all mental health-related hospital separations from 2001-02 to 2006-07. The second Admitted Patients cube contains information on only those hospital separations which involved specialised psychiatric care from 1998-99 to 2006-07. Data for 2007-08 will be added to these cubes shortly.
  • The Community Mental Health Care NMDS which includes data on client contacts with government-operated specialised community mental health care services and hospital-based ambulatory care services, such as outpatient and day clinics. The variables included in the Community Mental Health Care contacts data cube are year of collection, sex, age group, mental health legal status and principal diagnosis. The Community Mental Health Care contacts data cube presents information on numbers of contacts only for the years 2005-06 to 2007-08.
  • The Residential Mental Health Care NMDS which includes data on client episodes in government-operated residential mental health care services. The variables included in the Residential Mental Health Care episodes data cube are year of collection, sex, age group, mental health legal status and principal diagnosis. The Residential Mental Health Care data cube presents information only on numbers of residential care episodes for the years 2005-06 to 2007-08.

What is a data cube?

A data cube is a multidimensional representation of data which provides fast retrieval and drill down facilities. To learn more about the cube, and how to use the software behind the cube -- PowerPlay -- click on the help button Cognos help button inside the cube or visit the Demonstration page.

How do I export data from cubes?

You can export data from a cube to a file for use in other applications such as Microsoft Excel. Once you have the required data visible in the data cube, click the File button Cognos file button at the bottom of the window. For exporting to Microsoft Excel or compatible spreadsheet software, select the Export XLS option from the list. Depending on how your web browser is configured, you may then be prompted to either open the file directly or to save it on your computer. If required, more information is available in Help.

Links to data cubes

 Data source

The source of data for the Admitted Patient data cubes is the AIHW National Hospital Morbidity Database. The source of data for the Community Mental Health Care contacts data cube is the National Community Mental Health Care Database as specified by the Community Mental Health Care NMDS. The source of data for the Residential Mental Health Care episodes data cube is the National Residential Mental Health Care Database as specified by the Residential Mental Health Care NMDS.

Definitions

Definitions that are used in the data presented are from the National Health Data Dictionary .