User guide
The data cubes can be used to explore a range of clinical data related to hospital separations. This document will provide some tips on how to utilise the data cubes generally and how to deal with the different formats in which the cubes are provided.
From the 2015-16 financial year, hospitals data cubes have been made available in Excel format. Prior to 2015-16 hospitals data cubes are available in the SAS cubes software. The guide for extraction of information from these cubes depends on the format in which they are available.
Hospitals data cubes 2015-16 and later
The excel data cube workbooks consist of two sheets:
- Procedure Counts Data contains separation statistics by ACHI procedure by age group by sex by same-day status.
- Procedure Counts Summary contains a pivot table showing procedure counts by ACHI procedure code. This pivot table can be modified to various levels by right clicking on the table, selecting ‘Show Field List’ and then modifying the pivot table as desired.
- Variables in the ROWS list can be removed to disaggregate at higher levels.
- Variable such as age group, sex and/or same-day flag can be dragged to the COLUMNS list to disaggregate by these variables.
Hospital data cubes prior to 2015-16
These data cubes will open in a new window. Data will be displayed at the most aggregated level.
Expanding categories and sub-categories
Clicking on the plus (+) symbols against each row will expand that item into its relevant sub categories, within the current view.
Clicking the arrow symbols beside the plus will expand the category and also limit the view to just that expanded area of interest.
Right clicking on category headings such as Chapter will bring up a menu where you can click ‘Expand All’, which will expand every item in that list. If you also do this with the subchapter and block headings you can expand out the entire data cube and display all of the available information.
Adding breakdowns
In the default view, the cube will just present the number of procedures by year but you can also add other breakdowns such as by Age group and sex.
To add an extra breakdown, right click on one of the numbers in the cube and choose ‘Assign data’.
Then choose which variables to add to rows or columns of the cube.
Exporting data to Excel
The current view of the data cube can easily be exported to Excel by choosing ‘Export…’ from the ‘File’ menu, and then saving the zipped file to your computer. When extracting the zip archive you will need to extract all files in the archive before opening the downloaded Excel document.
Exporting the whole data cube
To do this, first see the notes about Expanding the categories and sub categories first and using Expand All. Then once you have the full view of the cube, export the data as per the step above.
Tips on using the Procedures data cube
Note that the use of the different ACHI editions in the data cubes over time means that data across years may not be exactly comparable.
One or more procedures can be reported for each separation in the National Hospital Morbidity Database, but procedures are not undertaken for all hospital admissions, and so only a proportion of the separation records include procedure data.
Within the cubes, users can view the procedures by working down from the broad chapter level in the ACHI classifications to more specific categories (i.e. procedure code), as illustrated below.
- ACHI Chapter
- ACHI Sub-Chapter
- ACHI Block number
- ACHI Procedure code
- ACHI Block number
- ACHI Sub-Chapter
For example:
- 7. Procedures on Respiratory System (Blocks 520-569)
- Lung and Pleura (Blocks 548-558)
- Block 549 Incision procedures on lung or pleura
- 38415-00 Incision of pleura
- Block 549 Incision procedures on lung or pleura
- Lung and Pleura (Blocks 548-558)
Users of the data cubes are likely to require some familiarity with the Australian Classification of Health Interventions (ACHI) and can also refer to the Australian Hospital Statistics publications. Users will generally need to know what chapter the information they are looking for is in, to work down to more specific levels of detail. More information about the breakdowns and categories used within the data cube are given below.
Australian Classification of Health Interventions
The Australian Classification of Health Interventions (ACHI) is the Australian national standard for procedure and intervention coding in Australian hospitals, based around the Medicare Benefits Schedule (MBS). Guidelines for the use of ACHI are contained in the Australian Coding Standards (ACS).
There are some differences in the coding between editions and these will be reflected in the cube. Readers should refer to the further information section below for information on how to access the full classification and for detailed information on the differences between ACHI editions.
ACHI has been structured with a principal axis of anatomical site. Within each chapter the anatomical site has been structured by a 'head-to-toe' approach. The secondary axis is procedure type, beginning with the least invasive procedure through to the most invasive procedure. Due to the historical development of ACHI, code numbers do not always appear in numerical order within the tabular list. A third level axis, called a block, has been introduced. Blocks are numbered sequentially in the tabular list to assist clinical coders in locating a specific code and have titles that relate specifically to the codes within the block. There are certain chapters that are an exception to the general format: Dental services, Obstetric procedures, Radiation oncology procedures, Non-invasive, cognitive and other interventions, not classified elsewhere and Imaging services.
The following is a list of the ACHI procedure chapters and the code ranges covered by each under Edition 10 of the ACHI:
Chapter |
Procedure classification |
Block range |
---|---|---|
I. |
Procedures on Nervous System |
1-86 |
II. |
Procedures on Endocrine System |
110-129 |
III. |
Procedures on Eye and Adnexa |
160-256 |
IV. |
Procedures on Ear and Mastoid Process |
300-333 |
V. |
Procedures on Nose, Mouth and Pharynx |
370-422 |
VI. |
Dental Services |
450-490 |
VII. |
Procedures on Respiratory System |
520-572 |
VIII. |
Procedures on Cardiovascular System |
600-777 |
IX. |
Procedures on Blood and Blood-Forming Organs |
800-817 |
X. |
Procedure on Digestive System |
850-1011 |
XI. |
Procedures on Urinary System |
1040-1129 |
XII. |
Procedures on Male Genital Organs |
1160-1203 |
XIII. |
Gynaecological Procedures |
1240-1299 |
XIV. |
Obstetric Procedures |
1330-1347 |
XV. |
Procedures on Musculoskeletal System |
1360-1580 |
XVI. |
Dermatological and Plastic Procedures |
1600-1718 |
XVII. |
Procedures on Breast |
1740-1759 |
XVIII |
Radiation Oncology Procedures |
1786-1800 |
XIX. |
Non-invasive, Cognitive and Other Interventions, not elsewhere classified |
1820-1923 |
XX. |
Imaging Services |
1940-2016 |
Block numbers and procedure codes can vary across editions, with the same block numbers representing two different procedure groups. This should be taken into consideration when comparing data using different ACHI editions. Separate cubes exist for each of the ICD-10-AM/ACHI editions as it is difficult to map across editions.