Australian refined diagnosis-related groups (AR-DRG) data cubes

The data cubes can be used to explore a range of clinical data related to hospital separations. 

The Excel data cube workbooks consist of two sheets:

• DRG Counts Data contains separation statistics by DRG by age group by sex by same-day status.
• DRG Counts Summary contains a pivot table showing separation statistics by DRG. 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 (see Figure 1).
  • Variables in the ROWS list can be removed to disaggregate at higher levels.
  • Variables such as age group, sex and/or same-day flag can be dragged to the COLUMNS list to disaggregate by these variables.

Figure 1: DRG counts summary pivot table

Source: DRG data cube, 2021-22, classified using AR-DRG version 10.0.

The cubes contain information on the number of separations and number of patient days. Once the cube has been aggregated/disaggregated to the desired level, average length of stay can be calculated as number of patient days/number of separations.

Tips on using the AR-DRGs data cube

Note that the use of the different AR-DRG versions in the data cubes over time means that data across years may not be exactly comparable.

Within the cubes, users can view the AR-DRG by working down from the Major Diagnostic Category (MDC) level to the Partition of the MDC to the individual DRGs, as outlined below.

• Major diagnostic category
  • Partition (Intervention/Medical for AR-DRG versions 9.0 and later, Surgical/Medical/Other for earlier DRG versions)
    • AR-DRG

For example under AR-DRG 10.0

• MDC 04. Diseases and disorders of the respiratory system
  • Intervention
    • AR-DRG E01A Major Chest Interventions, Major Complexity.

Users of the data cube are likely to require some familiarity with AR-DRGs and have access to the definitions manual. Users will generally need to know what MDC 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.

Major diagnostic categories (MDCs)

The data cube is categorised by the Major Diagnostic Categories (MDCs) into which the patient’s diagnosis and the associated AR-DRG falls. They correspond generally to the major organ systems of the body. Below is a list of each of the MDCs and the range of AR-DRGs that fall into each category under AR-DRG version 10.

Broad categories of service

The data cube is next broken down by the partitions of the AR-DRG. These partitions represent the broad category of service associated with that AR-DRG, as described below:

For AR-DRG versions 8.0 and earlier:

• Surgical: separations for which the AR-DRG belonged to the Surgical partition of the AR-DRG classification (involving at least one operating room procedure).
• Medical: separations for which the AR-DRG belonged to the Medical partition (not involving an operating room procedure or a locally significant non-operating room procedure).
• Other: separations for which the AR-DRG did not belong to the Surgical or Medical partitions (involving no operating room procedures but at least one non-operating room procedure significant to the MDC, such as endoscopy).

For AR-DRG versions 9.0 and later:

• Intervention: separations for which the AR-DRG belonged to the Intervention partition (involving a General Intervention (operating room procedure) or at least one Specific Intervention (non-operating room procedure) significant to the MDC).
• Medical: separations for which the AR-DRG belonged to the Medical partition (not involving an operating room procedure or a locally significant non-operating room procedure).