RNSH SERT Institute HAC Report

OFFICIAL: Sensitive – NSW Government

Appendix B: Raw data preparation and cleaning HACs under surgical and non-operative admissions are extracted using the logic outlined in Figure 2.

Admitted Patient Dataset (Filtered for additional diagnoses)

QIDs Dataset Contains all HACs 1 – 14

HAC Master

Filter rows by matching with Casemix extract, and filtering at the consultant level to include only relevant departments.

Filter rows by taking out all surgical admissions and selecting rows where the last

Individual Service Provider is under a DoSA specialty.

HAC Operative admission

HAC Non-operative admission

Figure 2. Flow chart of the extraction process for HACs under operative and non-operative admissions.

48

Made with FlippingBook - professional solution for displaying marketing and sales documents online