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