Two groupers, in Excel and SAS, have been developed to support the implementation of the hospital-acquired complications (HACs) list. The groupers are tools that can be used by hospitals, health services and system managers to identify and monitor HACs using existing data that is routinely generated from the patient medical record in accordance with the specifications developed by the Commission. The groupers were developed by the Independent Hospital Pricing Authority in consultation with the Commission.

The groupers currently identify HACs using the 7th, 8th, or 9th edition of the ICD-10-AM. A grouper to identify HACs using the 10th edition of the ICD-10-AM is currently under development.

Note ‘Unplanned return to operating theatre’ (METeOR identifier: 578317), is not currently in the National Minimum Data Set and is therefore not used in these groupers.

Hospital-acquired complications specifications

The HACs are identified using a combination of ICD-10-AM codes to identify the diagnosis and the condition onset flag (METeOR identifier: 354816) to indicate that the diagnosis occurred during the episode of admitted patient care. Some HACs also require other codes to define the complication such as procedure and external cause codes.

The Commission recommends that users of the groupers download the specifications for the HACs list to better understand the list.

Download the HACs specifications by completing this short form.

HACs Excel grouper

This Excel spreadsheet allows hospitals to identify HACs using their admitted patient data according to the specifications established by the Commission without specialist statistical software.

Download the HACs groupers by completing this short form.

Detailed instructions for the Excel grouper

Note: the HACs excel grouper includes dummy data to assist in understanding of the required formatting of the data and the functioning of the grouper. These data need to be deleted before using the grouper.

  • Clear all data from the worksheets using the:
    • “Clear All” button on the “RawData” worksheet. This clears all data in the worksheet starting from row 5
    • “Clear Table” button on the “HACs Episodes” worksheet. This clears all data in the worksheet starting from row 5.
  • Enter the admitted patient data into “RawData” worksheet using the format provided in the “Dictionary” worksheet. Note that:
    • ICD-10-AM codes and the corresponding condition onset flag (COF) must be concatenated within the same cell using this format – the COF code followed by the ICD-10-AM code with the ‘.’ removed.
    • ICD-10-AM codes (diagnosis and external cause codes) should be entered before procedure codes
    • The “Clear Blanks” button can be used to get rid of any records in the “RawData” worksheet with empty diagnosis and procedure code arrays in a whole line.
  • Run the grouper by clicking the “Run HACs Grouper” button on the “RawData” worksheet. This button runs the HACs grouping process using the data stored in “RawData” worksheet. The “HACs Episodes” worksheet will be populated with the output. Columns FD to GP shows the HACs that have been identified in each episode of care.

 

HACs SAS grouper

This grouper is a package of SAS programs that allows hospitals to identify HACs using their admitted patient data according to the specifications established by the Commission. This grouper requires specific software and expertise to use.

Download the HACs groupers by completing this short form.

Questions and feedback

Queries about the technical aspects of the groupers should be directed to enquiries.ihpa@ihpa.gov.au.

Queries and feedback about the HACs list should be directed to indicators@safetyandquality.gov.au.