Home

Patient Flow Portal Reports Module and Reports User Manual

1. Figure 2 Report Module PatientFlowPortal Test environment Reporting Central Coast z Gosford Hospital Select Hospital ERE Schedis po Clinician Defined EDD Compliance by Facility Bi select all Hospital Occupancy Gosford Hospital Long Jetty Healthcare C NSCCAHS Transitional C Woy Woy Hospital Wyong Hospital Prediction Data Extract rs prior to UserAccess List days prior EEE ks 29 User Access Logins weeks priorto 29 lo to months priorto 4 Report Information Definition Provides an average daily snapshot of the following data for a facility Avg and of patients with LOS gt 24hrs amp clinician defined EDD All values exclude patients in wards flagged as Designated ED and Day Only Usage Allows Patient Flow Managers Clinical Managers Nurse Unit Mangers and Hospital Executives to review EDD compliance as a measure of care coordination within the organisation Inter Ward Transfer Times Patient Open Inter Ward Trans Local intranet Protected Mode Off f R10 Reports Manual Page 7 of 185 Health GOVERNMENT The Report Module displays the list of reports available to the user currently logged on These reports are grouped together
2. Field Format Definition Rules Calculations Patient ID Alphanumeric Patient s UID or MRN Which value displays depends onthe LHD preferences Surname Alphanumeric Patient s Surname N A First Name Alphanumeric Patient s First Name N A Facility From Alphanumeric Facility the patient is to be transferred N A from Facility To Alphanumeric tad the patient is to be transferred N A Current Ward Alphanumeric Ward Code the patient is currently N A Code admitted into Current Ward Ward Description the patient is Description Alphanumeric currently admitted into N A Ward Code the patient was admitted Requesting Ward 3 Code Alphanumeric into when the transfer request was N A initiated Ward Description the patient was Requesting Ward Alphanumeric admitted into when the transfer N A Description ae request was initiated Urgency Alphanumeric Urgency Category assigned to the N A Category transfer Specialty Alphanumeric Specialty of the patient s AMO N A Transfer Request DD MM YY Date time the transfer was requested System generated when the user requests the Time hh mm AM transfer Estimated DD MM YY Date time the patient is estimated to N A Transfer Time hh mm be ready for transfer Isolation Req Yesor No Flag to indicate if the patient requires N A isolation Free text information about the bed Information entered in the Bed Type Required Bed Info Alphanumeric i required field Requesting A
3. required Transtar Request DD MM YY Date time the transfer was requested PDF and Excel System generated when the Time hh mm AM user requests the transfer Estimated DD MM YY Date time the patient is estimated to Transfer Time hh mm be ready for transfer POP AGERE N A Isolation Req Yes or No Flag 9 In eater the patient requires PDF and Excel N A isolation Bed Info Alphanumeric Free text information about the bed PDF and Excel Information entered in the Bed Type Required field Transfer note Alphanumeric Free text information about the transfer PDF and Excel Information entered in the Transfer Notes field on the Transfer request window Reports Manual Page 113 of 185 Health GOVERNMENT 8 0 TRANSFERS DWA REPORTS 8 1 Direct Ward Admission Records Table 77 Direct Ward Admission Records Overview eye De O o DO Da O A ele O po Pro 0 o O O eq O Oraq Reports Manual Direct Ward Admission Records Displays all information related to each Direct Ward Admission record that was initiated into a specific facility based on a user defined date range Analyse the data to better understand trends and patterns for a facility s demand PFP All users except Ambulance Users Excel only Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access
4. Health Figure 46 Patient Transfer Times Graph Urgency Category Summary Table Layout Life Threatening lt 4hrs Urgent specialist care lt 24hrs Inpatient specialist care 24 72hrs Retum Transfer of Care Post Specialist Care Transfer Times Summary Shortest Transfer Time Longest Transfer Time Average Transfer Time 0 day s 0 day s 2 hour s 2 hour s 42 min s 42 min s 0 day s 2 day s 0 hour s 4 hour s 0 min s 47 min s 0 day s 7 day s 0 hour s 5 hour s 16 min s 30 min s 0 day s 2 day s 8 hour s 17 hour s 11 min s 42 min s 0 day s 2 hour s 42 min s 0 day s 9 hour s 30 min s 1 day s 12 hour s 45 min s 1 day s 3 hour s 58 min s Table 65 Patient Transfer Times Graph Urgency Category Summary Table Data Elements Format Definition Derivation calculation Transfers OUT and IN Transfer Time Total time taken between either the Transfer request time or the Estimated transfer time depending on the Urgency Category and the time the transfer was completed If Urgency Category equals one of e Life Threatening e Urgent Specialist Care lt 24 hours e Inpatient Specialist Care 24 72 hours e Return Transfer of Care Post Specialist Care Then Completed Time minus Transfer Request Time If Urgency Category equals one of e Future Inpatient Specialist Care 24 72 hours e Future Return Transfer of Care Post Specialist
5. gt 81 Patients who have been admitted to the MAU via the ED within 4 hours Emergency Department admission Unit type 17 or 58 in DAYS EPISODE table Numerator Count of admissions to the MAU via the Emergency Department within 4 hours i e lt 240 minutes Denominator Count of admissions to the MAU via the Emergency Department Data source Tables DAYS EPISODE EPISODE STAY Time period Same facility sum episode length hours lt 240 minutes where unit type 17 or 58 1 ward has unit type 17 or 58 and 2 ward has unit type 87 for both numerator and denominator Reports Manual Page 151 of 185 Health GOVERNMENT 10 2 Facility MAU Re admissions Table 89 Facility MAU Re admissions Overview Facility MAU Re admissions Provides the patient ID MRN or UID depending on the LHD and Stay Number for all separations from a MAU ina month and the subsequent re admission within 28 days Note MAU Separations excludes those with Mode of Separation 4 Transfer to public Epor pe psychiatric hospital 5 Transfer to other hospital 9 Type change separation and 10 Discharge on leave Readmission data is calculated based on 28 days since the patient was discharged from their previous admission where they visited a MAU As such if this report is generated for last 28 days prior to today the readmission data will not be up to date p
6. IHT Records Inter Ward Transfer Times IWT Records LHD MAU Summary LHD MAU Snapshot Summary LHD MAU FY Summary LHD Operational Summary LHD Operational Summary Trend LOS by Specialty and AMO NSW Health MAU Snapshot Summary NSW Health MAU Performance Trend Summary NSW Health MAU Process Trend Summary NSW Health MAU FY Summary Reports Manual Page 10 of 185 Wii NSW Health NSW Health MAU Re admission Summary NSW Health Operational Summary Patients IN OUT Patient Open Transfers by LHD Patient Open Transfers Patient Open Ward Transfers Patient Transfer Cancellation Patient Transfer Times Graph Patient Transfer Times Predicted Admissions via ED Specialty Prediction Data Extract Specialty Activity Specialty Activity Snapshot User Access List User Access Logins WA4W All Reasons WA4W Bed Days WA4W Current Admissions Open Reasons WA4W Reasons Count Ward Activity Ward Activity Snapshot Ward Lists Ward Occupancy Ward Profile Ward Setup Whole of Hospital Snapshot Whole of Hospital Snapshot by Facility Reports Manual Page 11 of 185 AP Wi NSW Health 1 3 Selecting and Generating Reports To generate a report the user must first click on the Report Group header which th
7. Reports Manual Page 6 of 185 UM GOVERNMENT Health 1 0 REPORTS MODULE 1 1 Overview The PFP Report Module provides access to pre defined reports that allow users to report on different functional areas within Patient Flow The Report Module is accessed by clicking on the Reporting Module icon as identified by the red circle in Figure 1 Figure 1 Accessing the Report Module PatientFlowPortal Dev environment swood Bed Board Central Coast Gosford Hospital SelectHospital EE Bed Board a Roy Q Bed Mode Last refreshed 14 10 2013 10 52 Filtered Profile Hospital Profile i z ED accessible bed occupancy ED accessible bed occupancy 106 Patient Profile Gosford Hospital 3 i ads peg 7 amo Fiter F wararner gt i amp Number of patients JA Number of patients 500 Bed days to date JA Bed days to date 4774 Average LOS JA Average LOS 10 36 Filters used None Hide wards with no patients _ Display ward description Clinician defined EDD Clinician defined EDD 88 Clear Expired Today Tomorrow 2 3 days O 4 5 days O gt 5 days Auto Generated BOI EP PPC PIPFIPETCIE B r PIECE EKN E EA 8 Je JCs Ps Pe P 17 2 2 Be LJ TE fe a PIER TT IPIBICIBTIRT PIER
8. AND unit_type is a MAU ward in the DAYS_EPISODE table AND Nil mode_of_separation in Discharged patients Advice To 11 2 3 6 7 8 11 in the EPISODE table Time period patients maintain Admitted to MAU AND BO calculates as below Total hrs Same facility sum 8 discharged home patient discharged home to place of ED hrs discharge lounge hrs MAU hrs 0 episode length hours gt 0 where from the MAU flow this usual residence from MAU unit and mode of separation in 1 2 3 6 7 8 11 unit type 87 needs to be Includes patients that went MAU gt 30 Denominator Count of stays where patient Discharge Lounge Home was ina MAU Data source Tables DAYS EPISODE EPISODE patients discharged home from the MAU within 48hrs 80 90 Guide only Admitted to MAU AND discharged home to place of usual residence from MAU unit within 48 hours Numerator Number of MAU patients who spent less than 48 hrs in MAU discharged directly to home usual residence or discharged MAU Discharge Lounge Home i e mode of sep in 1 2 3 6 7 8 11 and time spent in other wards except ED and discharge lounge 0 Discharged patients Time period Same facility sum episode length hours gt 0 where unit type 87 Includes patients that went MAU Discharge Lounge Home Reports Manual Page 149 of 18
9. DD Date time the transfer was requested PDF and Excel System generated when the Time hh mm AM user requests the transfer Estimated DD MM YY Date time the patient is estimated to Transfer Time hh mm be ready for transfer PDE andExcel N A Isolation Req ee Flag to indicate if the patient requires Excel N A isolation Bed Info Alphanumeric Free text information about the bed PDF and Excel information entered in the required Bed Type Required field Requesting Alphanumeric Name of the Doctor requesting the PDF and Excel N A Doctor transfer Expired transfers will display in red Open Transfer X days Length of time the request has been Excel Current transfers will display in Time Y hours open black Future estimated transfers will display in green Expired transfers will display in red Status Alphanumeric Current status of the transfer request Excel Current transfers will display in black Future estimated transfers will display in green Transfer note Alphanumeric Free text information about the transfer PDF and Excel Information entered in the Transfer Notes field on the Transfer request window Patient s Financial Status which is based on their financial class e g the transfer Financial Status Alphanumeric Public Private DVA Compensable Excel N A etc Financial Alphanumeric Patient s Financial Description Excel N A Description associated with their
10. Jun 13 Jul 13 114 482 1 7 1 8 518 Figure 59 LHD Operational Summary Trend Layout page 3 Inter LHD Transfer Summary Breached Transfers OUT Breached Life Threatening lt Avg Breached Wait Time hrs 4hrs Breached Breached Avg Breached Wait Time hrs Transfers IN Transfers IN Avg Breached Wait Time hrs Breached Transfers OUT Breached Return Transfer of Care Post Specialist Care Avg Breached Wait Time hrs Breached Transfers IN Breached Avg Breached Wait Time hrs Reports Manual May 13 Jun 13 Jul 13 Aug 13 116 366 1 2 122 236 0 8 47 96 0 3 Aug 13 Sep 13 104 29 Oct 13 434 1 5 177 Sep 13 Oct 13 Page 118 of 185 Wis GOVERNMENT Health Table 80 LHD Operational Summary Trend Data Elements Format Definition Rules Calculations NEAT Pts in ED gt 4 hrs Text Displays the title for data about NEAT N A Number of patients presenting to and discharged from an Emergency Department within 4 hours Total number of patients presented to an Emergency Department X 100 The of patients in an Emergency Includes ED Visit Type Godes Department lt 4 hours Oh Emergency Presentaron o All Pts Percentage 03 Unplanned return visit for continuing condition 11 Disaster Excludes ED Separation Mode Code for Data Entry Error If lt Target the cell will be highlighted in red If gt Target
11. Urgent specialist care lt 24hrs Not Specified 16 09 13 09 50 16 09 13 09 51 17 09 13 10 06 Ian 6 days Urgent specialist care lt 24hrs Not Specified 17 09 13 09 50 17 09 13 09 54 23 09 13 10 56 1 hours 2 mins Urgent specialist care lt 24hrs Not Specified 17109113 09 55 17 09 13 10 00 23 09 13 10 57 Knin Urgent specialist care lt 24hrs Not Specified 17 09 13 10 00 17 09 13 10 02 23 09 13 10 57 TE Urgent specialist care lt 24hrs Not Specified 24 09 13 08 55 24 09 13 08 55 24 09 13 10 11 ewe Urgent specialist care lt 24hrs Not Specified 24 09 13 08 55 24 09 13 08 56 24 09 13 10 11 ee Urgent specialist care lt 24hrs Not Specified 24 09 13 08 55 24 09 13 08 57 24 09 13 10 11 J fies Urgent specialist care lt 24hrs Not Specified 24 09 13 08 55 24 09 13 08 59 24 09 13 10 11 oe Urgent specialist care lt 24hrs Not Specified 24 09 13 08 55 24 09 13 08 59 24 09 13 10 11 Thus 1 hours Urgent specialist care lt 24hrs Not Specified 24 09 13 09 00 24 09 13 09 00 24 09 13 10 12 42 ra 1 hours Urgent specialist care lt 24hrs _ Not Specified 24 09 13 09 00 24 09 13 09 01 24 09 13 10 12 11 mins Reports Manual Page 108 of 185 Ws NSW Health Figure 53 Inter Ward Transfer Times Layout Excel Inter Ward Transfer Times For the Period 01 10 2013 to 29 11 2013 Transfer Transfer Request Completed Time Time Estimated Transfer Time Request to
12. IHT Waiting for Bed amp Ac Denotes WFW Reasons that are now inactive Pareto principle also known as the 80 20 rule the law of the vital few and the principle of factor scarcity states that for many events roughly 80 of the effects come from 20 of the causes The purpose of the Pareto Chart Is to assess the most frequently occurring delays in order to focus 80 of your time and energy on the 20 of the delays that are really important Cutoff 80 e Cumulative EE Bed Days Per Reason WE Bed Days Per Others Table 49 Waiting for What Reasons Count Pareto Chart data elements Format Definition Rules Calculations An will display at the side of a Waiting for Alphanumeric Displays the name of the WFW Reason What reason if it has become inactive during the specified reporting period Difference between earliest of WFW X Axis Waiting for What Reasons Y Axis left WFW Count of WFW reasons that were open Gee ar Count of Delays Numeric at some time within the specified Closed date Discharge date ef Date E y P To and latest of WFW Start date and within range reporting range Date From Percentage of the total number of WFW Y Axis right Numeric reasons entered that cumulatively Cumulative makes up 80 of the total number of WFW reasons N A Table 50 Waiting for What Reasons Count Summary Table Data Elements Definition Rules
13. Patient Flow Portal Reports Module and Reports User Manual Wi NSW Health Version 4 1 July 2015 Wi Health Revision ___ Revision History _ 07 09 11 Initial draft Steph Wood V1 0 24 02 12 Updated with ED accessible pad Steph Wood occupancy report and made final V1 1 14 05 12 Updated with Admission risk reports Steph Wood Updated with WFW ts amp U V1 2 19 09 12 ee ER Steph Wood Access list Updated following release of PFP Steph Wood and V2 0 10 05 13 Management Grouping of Wards p Pedram Bidhendi Stream 2 enhancements Updated following release of PFP Release Steph Wood and VAR 108 3 Stream 3 enhancements Pedram Bidhendi V3 0 1 8 1 14 Updated Section 1 2 Pedram Bidhendi V3 0 2 12 3 14 Updated Section 9 5 Damian Miners Updated for the Medical Assessment Unit V4 0 May 2014 renortsand EPIB Audit L g Pedram Bidhendi Updated Executive Reports LOS V4 1 July 2015 calculations and Admission Risk exclusion Pedram Bidhendi criteria Reports Manual Page 2 of 185 MU NSW Health Contents 1 0 Reports PIV CN eae Sosa oes Se ht had Ge aE E EEE EEEE EEEE EEEE 7 DOV OIVIOW nininini a a a a T 7 1 2 Accessing Reports aueia a a a a le 10 1 3 Selecting and Generating Reports uuavsrmvmmvamnenenndeunmtnaimnn 12 1 3 Report PFOMPtS soso sicas onesie coc esiect dowieneneeadncenevouiecan cu e E EEE EEE REEE Er TETERE E
14. 08 10 13 10 10 08 10 13 10 10 14 10 13 09 25 15 10 13 08 55 01 10 13 08 26 01 10 13 08 26 01 10 13 08 27 01 10 13 08 27 02 10 13 08 23 02 10 13 08 24 02 10 13 08 25 02 10 13 08 25 02 10 13 08 26 02 10 13 08 27 02 10 13 08 27 02 10 13 08 28 02 10 13 08 28 03 10 13 08 48 03 10 13 08 49 03 10 13 08 50 03 10 13 08 50 07 10 13 12 13 07 10 13 12 14 08 10 13 10 12 08 10 13 10 13 08 10 13 10 15 14 10 13 09 30 15 10 13 08 56 01 10 13 10 40 01 10 13 10 40 01 10 13 10 40 01 10 13 10 40 02 10 13 09 04 02 10 13 15 07 02 10 13 09 01 02 10 13 09 01 02 10 13 09 01 02 10 13 09 01 02 10 13 09 01 02 10 13 09 01 02 10 13 09 04 03 10 13 09 26 03 10 13 09 26 03 10 13 09 26 03 10 13 09 27 07 10 13 12 40 07 10 13 12 40 08 10 13 10 59 08 10 13 10 59 08 10 13 10 59 14 10 13 11 31 15 10 13 15 01 2 hours 14 mins 2 hours 14 mins 2 hours 13 mins 2 hours 13 mins 38 mins 6 hours 43 mins 36 mins 36 mins 35 mins 34 mins 34 mins 33 mins 33 mins 38 mins 37 mins 36 mins 37 mins 27 mins 26 mins 47 mins 46 mins 44 mins 2 hours 1 mins 6 hours 5 mins 6 hours Wis GOVERNMENT Health Table 74 Inter Ward Transfer Times Data Elements Format Definition Report Rules Calculations Patient ID Alphanumeric Patient s UID or MRN Format PDF and Excel Which value
15. Completed Time Ward From Code Description Ward From Ward To Urgency Patient ID Ward To Code Description Category Surname First Name Specialty Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit Intensive Care Unit J2A Adolescent Ward G1 General Surgery F3 Cardiac Surgery Vascular F3 Cardiac Surgery I Vascular G1 General Surgery G2 Neurosciences G2 Neurosciences F2 Respiratory Immunology G3 Cardiology Gastro J2A Adolescent Ward J2A Adolescent Ward F3 Cardiac Surgery I Vascular F3 Cardiac Surgery I Vascular H3 Surgery Trauma J1 Paediatric Surgery J1 Paediatric Surgery F3 Cardiac Surgery I Vascular F3 Cardiac Surgery Vascular J1 Paediatric Surgery J1 Paediatric Surgery F3 Cardiac Surgery I Vascular G1 General Surgery G2 Neurosciences F1 Orthopaedic Paediatr Reports Manual Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hr
16. EDD Format Numeric Definition Average of patients who s EDD has expired regardless of whether it was Clinician Defined for the defined date range at a specific facility Rules Calculations Daily snapshot Count of patients within a specific facility with an Expired EDD excluding patients in e Wards flagged as Day Only OR Designated ED e Virtual Beds i e Well Babies Boarder and Leave e LOS lt 24 hours Count of patients within a specific facility excluding patients in e Wards flagged as Day Only OR Designated ED e Virtual Beds i e Well Babies Boarder and Leave e LOS lt 24 hours x 100 Calculation for average is Sum of each daily snapshot Number of daily snapshots within the defined date range number i Number of patients discharged during Count of patients whose discharge patients Mumien the defined date range date is within the reporting period discharged p BP Count of patients whose discharge date is from Monday 00 01 to Friday Number of Ain i 23 59 within the reporting period patients 3 Number of patients discharged on a discharged on Mee weekday weekdays i If there are no weekdays within the y defined date range then no value is displayed Count of patients whose discharge date is from Saturday 00 00 to Sunday Number of sped 23 59 within the reporting period patients Number of patients discharged on a discharged on Buene week
17. N A Contact name Alphanumeric Contact name for the requesting Doctor N A Contact phone Alphanumeric Contact number for the contact N A Receiving Doctor Alphanumeric Name of the Doctor accepting the patient N A Receiving Doct en sere Alphanumeric Contact details for the receiving Doctor N A contact Patient s Financial Status which is based on Financial Status Alphanumeric their financial class e g Public Private DVA N A Compensable etc Financial Alphanumeric Patient s Financial Description associated with N A Description their financial class Bed Requested Info Alphanumeric Bed Type Required for the patient Information entered in the Bed Type Required field on the Transfer request window Code of the speciality the patient is being Speciality code Alphanumeric N A Specialty Alphanumeric Description of the speciality the patient is being N A transferred under Transfer note Alphanumeric Transfer notes entered against the transfer N A M RO Yes or No or Flag to indicate if the patient is infected with a N A Unknown Multi Resistant Organism Date Time DD MM YYYY Date time the transfer was requested N A Referral hh mm Estimated DD MM YYYY Date time the patient is estimated to be N A Transfer Time hh mm transferred Date time the Date Time DD MM YYYY e User clicks on the Completed checkbox Patient Date time the patient arrived at t
18. Provides users with the ability to select one or many wards or ward groups in a facility eport De O to obtain a snapshot of the patients in those wards or ward groups and the number of available beds To be used as a contemporary carry around list of patients and available beds for multiple wards within one facility Repo DELER PFP er Acce All Users except Ambulance User Report Forma PDF default and Excel Wards The ward or wards the user wants to run the report for All Wards display i A i within the selected facility the user has access to 1 Sort Alphabetically by Ward Code Repo O Orde 2 Sort Numerically Alphabetically by Bed Number NE N A e Blank lines will display at the end of each ward list with the number of empty lines corresponding to the number of empty available beds in the ward Figure 20 Ward Patient Lists Layout Ward Patient Lists Ward H1 H1 Paediatric Medicine ED Ward Profile Patients Beds Accessible Capacity 14 24 Open 14 24 Available 14 24 Unavailable 0 0 Surge 0 0 Closed 0 0 Admission Financial Date Time Age WLOS HLOS Status 02 H1 JHH Patient ID Patient Name Gender Medical Officer Specialty 04 H1 JHH 07 H1 JHH 08 H1 JHH sum fe femme mem fom e ME 2 Paediatric Paediatric n 20 H1 JHH F ae 30 10 13 18 55 07 12 2013 2mths 20 20 Chargeable Orthopaedics 13 H1 JHH 17 H1 JHH 21 H1 JHH Paediatric Respir
19. Public Public Financial Description Charge Private shared on call Dr Medicare Public O N Hosp Dr DVAON Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr DVA OIN Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr M8 NSW MAA Private single O N HITH Medicare card holder Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Snapshot 29 1 Last Updated Date 25 11 13 12 11 13 26 11 13 26 11 13 08 11 13 06 11 13 07 14 13 22 11 13 22 11 13 19 08 13 04 11 13 07 11 13 08 11 13 08 11 13 08 11 13 19 11 13 22 11 13 22 11 13 22111113 221113 22 11 13 Last Updated By 50000148 r 50000148 750026148 750026148 r 50000965 r 50000809 r 56157275 r 50000965 r 50000965 r 50000352 r 50000098 r 56157275 r 50000965 r 50000965 r 50000965 r 50014550 r 50000965 r 50000965 r 50000965 r 50000965 r 50000965 1 UM GOVERNMENT Health Table 44 Waiting for What Current Admissions Open Reasons Data Elements PDF and Excel Format Definition Report Rules Calculations Patient ID Alphanumeric Patient
20. from a ward Wards identified as Transit Lounge using Ward Type Transit Discharge Lounge 126000 Reports Manual Page 144 of 185 NSW GOVERNMENT Health Field Transit Lounge Discharges via ED Format Numeric Definition Percentage of transit lounge discharges via ED i e first ward is ED and discharge ward is a transit lounge Rules Calculations Count of patients admitted or transferred to First ward Emergency Department defined as a ward flagged as Designated ED and Ward Type lt gt Transit Discharge Lounge 126000 AND Discharged during the reporting period from a ward Wards identified as Transit Lounge using Ward Type Transit Discharge Lounge 126000 Count of patients whose were discharged during the reporting period from a Transit Lounge using Ward Type Transit Discharge Lounge 126000 x 100 Reports Manual Page 145 of 185 GOVERNMENT H ea l t h 9 6 Facility Whole of Hospital Snapshot Table 87 Facility Whole of Hospital Snapshot Overview Repo Facility Whole of Hospital Snapshot Provides a snapshot of the hospitals selected who are undertaking the Whole of Hospital WoH Program by reporting on information about e Admissions to the Emergency Medicine Unit EMU via ED e Total number of admissions to the EMU e Admissions to the Medical Assessment Unit MAU via ED e Total number of admissions t
21. minus In Time XX hour s requesting facility and ROF ancients Progress Time XX min s q 8 y g arriving at the receiving facility Reports Manual Page 94 of 185 Health GOVERNMENT Report Format Rules Calculations Format Definition If Urgency Category equals one of Life Threatening Urgent Specialist Care lt 24 hours Inpatient Specialist Care 24 72 hours Return Transfer of Care Post Specialist Care then Completed Time minus Total time taken between Transfer Request Time either the Transfer request XX d time or the Estimated Req Est to ay s If Urgency Category equals one of XX hour s transfer time depending on PDF and Excel Ran Completed time f Future Inpatient Specialist Care 24 XX min s the Urgency Category and 75 ho ts the time the transfer was Future Return Transfer of Care Post completed Specialist Care then Completed Time minus Estimated Transfer Time If the Req Est to Completed time exceeds the expiration time for the given Urgency Category the value will be displayed in red Reports Manual Page 95 of 185 NSW GOVERNMENT Health 6 7 Patient Transfer Times Graph Table 63 Patient Transfer Times Graph overview po D o po D O ee e je ele omp o O O O Orq Reports Manual Patients Transfer Times Graph Number of completed transfers into and out o
22. s UID or MRN Format PDF and Excel Which value displays depends on the LHD preferences Patient s Surname Patient s Delay Reason Patient Name Alphanumeric First Name PDF N A Surname Alphanumeric Patient s Surname Excel N A First Name Alphanumeric Patient s First Name Excel N A If a WFW reason has become inactive Waiting for What Category during the specified reporting period the Delay R Alph op PDF z en br phanumerie ag Waiting for What reason following displays underneath the reason Inactive since dd mm yy Primary Delay Alphanumeric Waiting for What Category Excel N A Reason If a WFW reason has become inactive Secondary Alphanumeric Waiting for What reason Excel during the specified reporting period the following displays underneath the reason Inactive since dd mm yy Free text notes entered PDF and Excel facility code identifier Optional Text Alphanumeric against the WFW reason N A Admission Date DD MM YY Patient s Admission date Excel N A LOS N meric Patient s Length of Stay PDF and Excel Eye renee between Admission Date and Now Date WFWStart Date DD MM YY Date the WFW reason was PDF and Excel N A started requested WFW Total Total number of days the PDF and Excel Difference between WFW Start Date and Numeric P pe Days WFW reason has been open Now Date EDD DD MM NY Patient
23. sourced from the census wait list table in HIE Bopked Overmight Numeric Total number of overnight admissions Admissions Booked Surgical Expected surgical overnight admissions these patients may be admitted the day before Numeric ht f Overnight surgery not direct admissions but include DOSA Number of patients at 7am in ED accessible beds with an Estimated Date of Discharge EDD Numeric EDD for that day AEN beds Numeric Empty available ED accessible beds at 7am Ideal Buffer Beds Numeric Number of beds that the facility requires to accommodate for daily variances in activity eg Numeric EDO required overnight bed Booked Medical Overnight Booked Surgical Overnight Predicted admissions Namene Number of predicted admissions from ED to an inpatient overnight bed i e excludes AMO via ED specialty ED AE Beds Numeric Number of predicted beds available to meet daily expected demand Predicted Beds Numeric Total number of beds needed to meet expected demand including planned booked direct Required and unplanned Emergency Department admissions and to close surge beds in use Predicted Direct Predicted Admissions from Clinics rooms other hospitals to an inpatient bed and did not Sek Numeric Admissions go through the ED Predicted Discharges Numere Predicted number of discharges excluding Day Only Emergency Department Maternity well babies and renal dialysis Surge Beds Occupied i P Numeric Number of surge beds occupie
24. 0 0 0 0 0 0 0 0 0 0 0 SW4 SW4 surgical 88 5 68 0 45 6 69 9 SW5 SW5 94 4 177 63 3 82 0 TU TU Transit Unit i 0 0 0 0 Reports Manual Page 34 of 185 7 GOVERNMENT Health Table 19 Clinician Defined EDD compliance by Ward Summary table Data Elements Format Definition Rules Calculations Displays differently depending on whether a daily weekly or monthly snapshot is selected e Daily Up to 31 days of daily Date Date Date range for the report snapshots per table e Weekly Up to 12 calendar weeks of daily snapshots per table e Monthly Up to 12 calendar month of daily snapshots per table Ward Code and Code and description of the ward the data HEG Text i 7 x N A Description relates to if the user selected Ward Name of the Ward Group the data relates Ward Group Text to if the user selected Ward Group N A Avg No Pts with LOS gt 24hrs amp Clinician Defined EDD Avg No Pts with LOS gt Avg Pts with USED LOS gt 24hrs amp The Avg of patients for the given facility Percentage with LOS gt 24hrs and a clinician defined Data excludes Clinician Defined EDD EDD e Wards flagged as Day Only OR Designated ED e Patients in virtual Beds i e Well Babies Boarder and Leave Reports Manual Page 35 of 185 Ws GOVERNMENT Health Figure 11 Clinician Defined EDD Compliance by Ward All wards or Ward Groups Avg Complian
25. 01 04 2014 to 30 04 2014 NSW Health Facility Identifier Facility Peer Group ae MAU Separations nen admissions admissions D227 A1 15 151 9 9 A237 Q211 D203 D215 A202 H208 D206 B210 H214 Q206 B214 L216 H272 C214 B206 N207 A1 A1 A1 A1 A1 A1 2 A1 A1 A1 A1 A1 A2 A2 A3 B B B B B B B B B B B B B D2 8 12 Duona o2 SiN 206 129 284 192 39 9 3 9 2 146 15 2 11 3 9 4 10 1 8 6 7 1 9 1 9 3 45 7 9 8 7 1 4 9 8 6 5 45 5 5 7 4 7 1 Note Number of MAU Separations excludes those with Mode of Separation 4 Transfer to public psychiatric hospital 5 Transfer to other hospital 9 Type change separation and 10 Discharge on leave Reports Manual Page 180 of 185 GOVERNMENT Health 11 0 ADMISSION RISK REPORTS 11 1 Admission Risk Records Table 101 Admission Risk Records Overview O De O O O BE O O O Pro 0 o O o Orq Reports Manual Admission Risk Records Displays patients who met one or more admission risks for an open admission within a specified date range Used by Connecting Care users to identify patients who are eligible for enrolment on the Connecting Care Register PFP Patient Flow Manager Patient Flow Administrator Connecting Care User Excel only Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s
26. 03 12 13 29 11 13 1141 43 44 1113 05 11 13 12 10 13 10 10 13 Specialty Ward Code Neurosurgery Geriatrics Orthopaedics Dermatology Urology Medical Service Immunology Orthopaedics Orthopaedics Orthopaedics Orthopaedics Orthopaedics Vascular Geriatrics Rehabilitation Geriatrics Geriatrics DIS Geriatrics STHRPH Rehabilitation RNC1 Respiratory H3S Page 65 of 185 Ward Description Med Officer F3 Cardiac Surgery Vascular South Ward Rankin Park Hospital H3 Surgery Trauma RNC 2 Urology Rheumatology RNC 2 Urology Rheumatology J3 Medical Ward J3 Medical Ward F1 Orthopaedic H3 Surgery Trauma F1 Orthopaedic F1 Orthopaedic F1 Orthopaedic F3 Cardiac Surgery Vascular RNC 1 Orthopaedic Rehabilitation RNC 1 Orthopaedic Rehabilitation RNC 1 Orthopaedic Rehabilitation Transit Discharge Lounge South Ward Rankin Park Hospital RNC 1 Orthopaedic Rehabilitation H3 Surgery Trauma Financial Status Public Public Public Chargeable Chargeable Public Public Public Chargeable Public Public Chargeable Public Public Public Public Public Public Public Chargeable For the P Financial Description Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Charge Private single on call Dr Charge Private single on call Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr M
27. 1 M 224 9 121 6 169 8 213 3 1143 135 6 212 7 Refer to LHD Operational Summary Trend data elements in Table 80 with the addition of the Waiting for What detailed summary section in Table 83 Table 83 LHD Operational Summary Data Elements Waiting for What Detailed Summary fe O De O D Waiting for What Summary Top 3 Title for Waiting for What Summary Text N A Reasons per Top 3 Reasons per Category Category WFW categories in alphabetical order e Consults e Diagnostics Treatment Cat Text N A e Discharge Process e Out of Hospital Referral e Transfer Transport Top 3 reasons for each W4W category Reason Text ordered by number of bed days N A consumed Total number of open W4W reasons Count of number of W4W records per top 3 Records Numeric which are consuming the bed days for reasons that were open at some point between each reason the first and last day of the month Count of bed days consumed for each top 3 reason per category that were open at some Displays the number of bed days point between the first and last day of the consumed for each of the top 3 WFW month reasons per category i Count of bed pays per WFW Consults reason Bed Days Mumerig Top 3 reasons are ordered by number of pre i Number of days from WFW Start Date to either bed days consumed from highest to j h ie of the following dates which occur first lowest i e second sort order for table ee a f
28. 11 13 08 12 26 11 13 00 00 ICUHDU ICU HDU GENMED General Medical Unit Resp Respiratory Unit General Medicine 11 11 13 12 03 11 11 13 00 00 ICU HDU ICU HDU Neuro Neurology Unit Resp Respiratory Unit Neurology 11 11 13 11 55 11 11 13 10 50 Reports Manual Page 112 of 185 Wis GOVERNMENT Health Table 76 Patient Open Ward Transfers Data Elements PDF and Excel Field Format Definition Report Rules Calculations Format Patient ID Alphanumeric Patient s UID or MRN PDF and Excel Whichvalue displays depends on the LHD preferences Surname Alphanumeric Patient s Surname PDF and Excel N A First Name Alphanumeric Patient s First Name PDF and Excel N A Ward From Code Alphanumeric Wardi ode tne patient was PDF and Excel N A transferred from Ward From Alphanumeric Ward Description the patient was Excel N A Description transferred from Ward To Code Alphanumeric Ward Code the patient was PDF and Excel N A transferred to Ward To Alphanumeric Ward Description the patient was Excel N A Description transferred to Current Ward Alphanumeric Ward Code the patient is currently PDF and Excel N A Code admitted into Current Ward Alphanumeric Ward Description the patient is Excel N A Description currently admitted into Urgency Category Alphanumeric Urgency Category assigned to the PDF and Excel N A transfer Specialty Alphanumeric Specialty of the patient s AMO PDF and Excel N A
29. 13 13 14 15 15 15 15 15 13 12 12 13 13 13 14 15 15 16 Available Beds 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 Patients in Available Beds 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 Unavailable Beds Patients in Unavailable Beds 14 11 2013 Surge Beds Thursday Patients in Surge Beds Open Beds Patients in Open Beds Closed Beds Patients in Closed Beds Occupancy 118 2 118 2 118 2 118 2 118 2 118 2 118 2 118 2 127 3 136 4 136 4 136 4 136 4 136 4 118 2 109 1 109 1 118 2 118 2 118 2 127 3 136 4 136 4 145 5 124 6 Patients Over Capacity Total Capacity Beds 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 Total of Patients 17 16 16 16 16 17 17 18 18 19 20 20 20 20 19 18 19 190 19 19 16 16 17 ES Available Beds 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 Patients in Available Beds 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 Unavailable Beds Patients in Unavailable Beds 15 11 2013 Surge Beds 7 7 7 7 47 7 7 7 Friday Patients in Surge Beds 6 5 5 5 6 6 7 7 7 7 7 7 7 7 7 7 7 Open Beds 18 18 18 18 18 18 18 18 18 18 Patients in Open Beds 18 18 18 18 18 18 18 18 18 18 Closed Beds 7 F 7 7 7 F 7 7 T 7 Patients in Closed Beds 1 2 2 2 2 1 1 1 2 1 1 Occupancy 154 5 145 5 145 5 145 5 145 5 154 5 154 5 163 6 163 6 172 7 181 8 181 8 181 8 181 8 172 7 163 6 172 7 172 7 181 8 172 7 172 7 145 5 145 5
30. 154 5 163 6 Patients Over Capacity Reports Manual Page 50 of 185 UM GOVERNMENT Health Table 30 Ward Profile Data Elements Definition Rules Calculations Ward Code and Alphanumeric The Ward code and Description within If the ward is an ED Accessible ward this will display as Ward code Ward description ED Accessible If the ward is Day Only ward this will display as Ward code Ward description Description the selected facility Day Only If the ward is Designated ED ward this will display as Ward code Ward description Designated ED Date DD MM YYYY The date the rows of data apply to N A Snapshot Time hh 00 The hour applicable to the counts and N A occupancy Total Capacit Number of all open unavailable and Sum of Available Unavailable Surge Beds pacity Numeric closed beds in the wards at the given Closed beds in the ward at the snapshot hour time Count of patients in ward at the snapshot time Total of patients Numeric bral y patients in the ward at the 8 Excludes patients in beds flagged as Boarder Lodger or Well Baby F Number of Available beds in the ward at Count of Available beds in ward at the Available Beds Numeric A the given hour snapshot time Patients in Number of occupied Available beds in Count of Available beds in the ward Numeric i Available beds the ward at the given
31. 16 50 31 07 13 09 05 31 07 13 09 10 Transfer Request Time 22 07 13 16 57 23 07 13 10 56 23 07 13 12 50 23 07 13 14 45 29 07 13 14 37 29 07 13 14 43 29 07 13 14 57 30 07 13 11 24 30 07 13 11 25 30 07 13 12 56 30 07 13 12 58 30 07 13 16 54 31 07 13 09 08 31 07 13 09 14 Bed Confirmed Time 06 08 13 18 56 06 08 13 09 25 24 07 13 14 51 01 08 13 11 54 02 08 13 15 16 13 08 13 10 40 01 08 13 13 08 34 07 13 09 21 15 08 13 12 03 01 08 13 09 46 01 08 13 09 05 01 08 13 11 42 Request to Confirmed Time 15 days 1 hours 59 mins 13 days 22 hours 29 mins 1 days 2 hours 1 mins 8 days 21 hours 9 mins 4 days 39 mins 14 days 19 hours 43 mins 2 days 1 hours 44 mins 21 hours 56 mins 15 days 23 hours 5 mins 1 days 16 hours 52 mins 23 hours 57 mins 1 days 2 hours 28 mins Patient Sent Confirmed to 07 08 13 13 26 06 08 13 11 05 01 08 13 17 55 01 08 13 13 05 06 08 13 20 00 02 08 13 18 33 13 08 13 13 05 01 08 13 17 00 01 08 13 10 15 01 08 13 13 06 15 08 13 15 50 01 08 13 12 35 01 08 13 14 30 01 08 13 11 55 For the Period 1 08 13 to 5 12 13 Sent Time 18 hours 30 mins 1 hours 40 mins 8 days 3 hours 4 mins 1 hours 11 mins 4 days 4 hours 44 mins 2 hours 25 mins 3 hours 52 mins 1 days 54 mins Transfer Completed Time 07 08 13 20
32. 46 06 08 13 13 30 01 08 13 19 50 01 08 13 16 21 06 08 13 20 00 02 08 13 22 06 13 08 13 14 08 01 08 13 16 00 01 08 13 16 18 01 08 13 16 22 15 08 13 19 54 01 08 13 12 41 01 08 13 18 35 01 08 13 14 43 Sent to Completed Time 7 hours 20 mins 2 hours 25 mins 1 hours 55 mins 3 hours 16 mins 0 mins 3 hours 33 mins 1 hours 3 mins 0 mins 6 hours 3 mins 3 hours 16 mins 4 hours 4 mins 6 mins 4 hours 5 mins 2 hours 48 mins Reg Est to Completed Time 16 days 3 hours 49 mins 5 days 2 hours 40 mins 9 days 7 hours 9 days 1 hours 36 mins 8 days 5 hours 23 mins 4 days 7 hours 23 mins 14 days 23 hours 11 mins 2 days 4 hours 36 mins 2 days 4 hours 53 mins 2 days 3 hours 26 mins 16 days 6 hours 56 mins 1 days 19 hours 47 mins 1 days 9 hours 27 mins 1 days 5 hours 29 mins Patient Transfer Times For the Period 1 08 13 to 5 12 13 Patient First arent surname rst Facility From o Name Facility To Reports Manual Inpatient specialist care 24 72hrs Inpatient Specialist Care 24 72 hours Future Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs
33. 6 4 Re admission rate of MAU home discharges ONLY t 9 2 9 8 f 9 0 MAU NEAT i 16 7 20 1 36 8 Reports Manual Page 178 of 185 NSW GOVERNMENT Health 10 13 NSW Health MAU Re Admission Summary Table 100 NSW Health Re Admission Summary Overview pO D O ele eye D O ele O po Pro D o O O o O Orq Reports Manual NSW Health Re Admission Summary Provides a summary of the number of MAU separations for a month and the subsequent re admissions within 28 days Note Number of MAU Separations excludes those with Mode of Separation 4 Transfer to public psychiatric hospital 5 Transfer to other hospital 9 Type change separation and 10 Discharge on leave Readmission data is calculated based on 28 days since the patient was discharged from their previous admission where they visited a MAU As such if this report is generated for last 28 days prior to today the readmission data will not be up to date Can be used to obtain an overview of re admission for all facilities across the state with an MAU HIE All users except Ambulance User and Connecting Care User Excel Month defaults to 2 months prior to current month 1 Sort Alphabetically by Peer Group 2 Sort Alphabetically by Facility N A N A Page 179 of 185 Health GOVERNMENT Figure 80 NSW Health Re Admissions Layout NSW Health MAU Re admission Summary For the Period
34. 72 Inter Ward Transfer Records Data Elements Format Definition Rules Calculations Date Time DD MM YYYY Date time the inter ward transfer request was N A Entered hh mm submitted Urgency is one of following N e Life Threatening Urgency Alphanumeric Urgency of the transfer e Urgent Specialist Care lt 24 hours e Inpatient Specialist Care 24 72 hours Requesting Ward Ward Code the patient was admitted into when Code Alphanumeric the transfer request was initiated N A Requesting Ward Alphanumeric Ward Description the patient was admitted into N A Description when the transfer request was initiated C t Ward i st a Alphanumeric Ward Code the patient is currently in Displays for patients currently admitted C t Ward A en ar Alphanumeric Ward Code the patient is currently in Displays for patients currently admitted Description To Ward Code Alphanumeric Ward Code the patient is being transferred to N A To Ward Alphanumeric Ward Description the patient is being N A Description transferred to Surname Alphanumeric Patient s Surname N A First Name Alphanumeric Patient s First Name N A Patient ID Alphanumeric Patient s UID or MRN Depends on the LHD preferences DOB DD MM YYYY Patient s Date of Birth N A Gender Alphanumeric Patient s gender N A R ti y ae ng Alphanumeric Name of the Doctor requesting the transfer
35. Available Beds Total Occupied 11 10 2013 Total Occupancy Friday Total ED Accesible Available Beds Total ED Accesible Beds Occupied ED Accesible Beds Occupancy Surge Beds Occupied Bo Reports Manual Page 24 of 185 7 Health GOVERNMENT Figure 8 Hospital Occupancy Layout Excel Hospital Occupancy For the Period 09 10 2013 to 16 10 2013 Snapshot Time Date Day Indicator 10 00 11 00 12 00 13 00 14 00 15 00 16 00 17 00 18 00 19 00 20 00 21 00 22 00 23 00 Total Capacity 608 608 608 608 608 608 608 608 608 608 608 608 Total Available Beds 551 551 551 534 534 Total Occupied 499 502 472 402 458 454 450 450 456 458 Total Occupancy 90 6 87 7 857 838 85 09 10 2013 Total ED Accesible Available Beds 383 263 383 283 383 263 Wednesday Total ED Accesible Beds Occupied 388 288 388 380 354 ED Accesible Beds Occupancy Surge Beds Occupied 0 0 Total Capacity 608 Total Available Beds 538 Total Occupied 490 Total Occupancy 106 9 106 9 10 10 2013 Total ED Accesible Available Beds 353 Thursday Total ED Accesible Beds Occupied 389 389 ED Accesible Beds Occupancy Surge Beds Occupied 0 0 Total Capacity 608 608 Total Available Beds Total Occupied 458 461 Total Occupancy 104 5 104 5 11 10 2013 Total ED Accesible Available Beds 353 353 Friday Total ED Accesible Beds Occupied 381 384 ED Accesible Beds Occupancy Surge Beds Occupied o 0 102 3 103 1 Re
36. Beds Occupied Total ED Accessible Available Beds 100 Surge Beds Occupied Numeric Number of occupied Surge beds in all wards at the given hour Count of Surge beds as sourced from the Predictive Tool Avg Numeric Average of each data item for each day Sum the data item for each hour number of snapshots in that day Reports Manual Page 26 of 185 Health GOVERNMENT 2 4 Prediction Data Extract Table 12 Prediction Data Extract Overview Repo De O Repo Repo BEE O A ele O pO Pro D o O O o Repo O Orde Reports Manual Prediction Data Extract Excel format extract of all predictive actual and flow indicator data for each date over a specified date range For further analysis of historical actual and predictions to identify demand and capacity trends and patterns over time PFP and HIE All Users except Ambulance User Excel only Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights From Date default Today The start date for the report To Date default Today The end date for the report 1 Sort Actual Prediction Flow Indicator 2 Sort Alphabetically by Indicator value except for the Flow Indicators N A For detailed information about the Data Sources and calculations for each measure please refer to the Predictive T
37. Calculations Displays the name of the Waiting for An will display at the side of a Waiting for Reasons Alphanumeric What Category Waiting for What What reason if it has become inactive Reason during the specified reporting period Total per Reason Humen Count of number of WFW reasons N A entered during the reporting period A cumulative of counts per WFW Cumulative Numeric N A reason Total Numeric Percentage of counts for each WFW WFW count per reason Total number of reason counts 100 Reports Manual Page 74 of 185 GOVERNMENT Health 6 0 TRANSFERS IHT REPORTS 6 1 IHT Hourly Performance Table 51 IHT Hourly Performance overview O De O O BELEE A O O o O Pro D o O Orq Reports Manual IHT Hourly Performance Provides a snapshot taken each hour of the total number of Transfers IN and OUT of a selected facility in a table and graph format Allows Patient Flow Managers and Hospital Executives to monitor IHT transfer performance to better manage the planning of flows in and out of a facility PFP All users excludes Ambulance Users PDF only Produces two sub reports Summary table A table displaying the Transfers IN and Transfers OUT per hour per day Graph A graph displaying the total number of Transfers IN and Transfers OUT per hour for reporting period Facilities The facility or facilities the user wants to run the report for F
38. Care Then Completed Time minus Estimated Transfer Time The time expressed in days hours and Minimum Transfer Time for specified date range Category XX d Shortest Transfer ay s minutes for the quickest transfer out or XX hour s i ea Se Er tices Time XX min s into the facility for the given Urgency If Completed Time minus Estimated Category Transfer Time a negative value this will be excluded from the calculation Maximum Transfer Time for specified date XX day s The time expressed in days hours and range Longest Transfer y minutes for the slowest transfer out or XX hour s sis in Get PO Time XX min s into the facility for the given Urgency If Completed Time minus Estimated Category Transfer Time a negative value this will be excluded from the calculation Mean Transfer Time for all transfers in XX day s The average time expressed in days specified date range Average Transfer Y hours and minutes for all transfers out XX hour s ae er pe Time XX min s or into the facility for the given Urgency If Completed Time minus Estimated Transfer Time a negative value this will be excluded from the calculation Reports Manual Page 98 of 185 Health GOVERNMENT Figure 47 Patient Transfer Times Graph Transfers From To Facility Within Outside Time Graph Layout Patient Transfer Times Graph For the Period 01 09 13 t
39. Count of patient transfers out of the selected LHD with e Urgency Urgent Specialist Care lt 24 hours e Completed Time was between the first and last day of month x100 Urgency Inpatient Specialist Care 24 72 hours Reports Manual Page 125 of 185 Wis GOVERNMENT Health Format Definition Rules Calculations Count of patient transfers out of the selected LHD with e Urgency Inpatient Specialist Care 24 72 hours e Request Transfer Time to Transfer Completed Time gt 72 hours e Completed Time was between the first and last day of month OR e Urgency Future Inpatient Specialist Care 24 72 hours e Estimated Transfer Time to Transfer Completed Time gt 72 hours e Completed Time was between the first and last day of month Count of patient transfers out of the selected LHD with e Urgency Inpatient Specialist Care 24 72 hours e Urgency Future Inpatient Specialist Care 24 72 hours e Completed Time was between the first and last day of month Urgency Return Transfer of Care Post Specialist Care gt 1 business day Count of patient transfers out of the selected LHD with e Urgency Return Transfer of Care Post Specialist Care gt 1 business day e Request Transfer Time to Transfer Completed Time gt 1 business day e Completed Time was between the first and last day of month OR e Urgency Return Transfer of Care Post Specialist Care gt 1 business day e Estimated T
40. Direct Admissions Prediction Predicted Discharges Prediction Surge beds occupied Prediction Unstaffed beds in use Prediction Yesterday s Admissions still in ED Flow Indicator National Emergency Access Target 4 hour Flow Indicator ED accessible bed occupancy Flow Indicator Patients over 9 days Flow Indicator Patients with ACCR waiting placement Flow Indicator Patients waiting ACCR review Flow Indicator Patients accepted for rehab waiting a Bed Flow Indicator Patients waiting rehab consult Flow Indicator Patients with MRO Flow Indicator Inpatients waiting surgery procedure Flow Indicator Patients requiring cardiac monitoring Flow Indicator Patients ready for transfer to another Facility Flow Indicator Patients awaiting transfer into Facility Flow Indicator Patients with Waiting For What Reasons Reports Manual Page 28 of 185 Wis GOVERNMENT Health Table 13 Prediction Data Extract Data Elements Field Format Definition Actuals Actual Admissions to i Actual number of patients admitted to the ED AMO specialty ED includes patients who Numeric y ED were admitted and discharged on the same day Actual Admissions to Actual number of patients admitted to the EMU includes patients admitted and Numeric EMU discharged on the same day Actual Admissions via Actual number of admissions from ED to an inpatient team who required an overnight bed Numeric j ED i e exc
41. Gro Albhanumeric The Ward Group name which has wards As defined in the Bed Management Admin P P assigned to it within the selected facility module of the PFP Ward Type Kunis The Ward Type which have Wards As defined in the Bed Management Admin YP p assigned to it for the selected facility module of the PFP Date range for the report as defined by the user and displayed as DD MM VY if Daily Snapshot selected The period of Activity is repeated on each Activity DD MM YY DD MM YY to DD MM YY if Weekly Ward Ward Group and Ward Type sub snapshot selected reports MMM YYYY if Monthly snapshot selected The number of patients that have been Transfers IN Numeric admitted or transferred into the Ward Count of patients admitted or transferred Ward Type and Ward Group for the into the Ward Ward Group or Ward Type snapshot period me number of patients that have been Count of patients discharged or transferred discharged or transferred out of the Transfers OUT Numeric out of the Ward Ward Group or Ward Ward Ward Type and Ward Group for Type the snapshot period Fe tl rumber sum ofthe number of ane Nan TOTAL Numeric 4 Transfer OUT of the given Ward Ward respective ward ward type and ward Group or Ward Type group for the snapshot period Reports Manual Page 44 of 185 GOVERNMENT H ea It h 3 4 Ward Occupancy Table 25 Ward Occupancy Overview Repo e Ward Occupancy ay gt Provides average
42. Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Urgent specialist care lt 24hrs Inpatient specialist care 24 72hrs inpatient specialist care 24 72hrs Rehabilitatio n Medicine Plastic amp Reconstructiv e Surgery Rehabilitatio n Medicine Rehabilitatio n Medicine General Medicine General Medicine General Medicine General Medicine Rehabilitatio n Medicine Renabilitatio n Medicine Rehabilitatio n Medicine Rehabilitatio n Medicine General Surgery General Medicine Rehabilitatio n Medicine Medical Oncology 22 07 13 16 55 01 08 13 10 50 23 07 13 12 50 23 07 13 14 40 29 07 13 14 35 29 07 13 14 40 29 07 13 14 55 01 08 13 10 00 30 07 13 11 25 30 07 13 12 55 01 08 13 10 30 30 07 13 16 50 31 07 13 09 05 31 07 13 09 10 31 07 13 10 20 3107 13 14 10 22 07 13 16 57 2307 13 10 56 23 07 13 12 50 2307 13 14 45 29 07 13 14 37 29 07 13 14 43 29 07 13 14 57 30 07 13 11 24 30 07 13 11 25 30 07 13 12 56 30 07 13 12 58 30 07 13 16 54 3107 13 09 08 3107 13 09 14 31 07 13 10 24 34 07 13 11 11 06 08 13 18 56 06 08 13 09 25 2407 13 14 51 01 08 13 11 54 02 08 13 15 16 13 08 13 10 40 01 08 13 13 08 3107 13 09 21 15 08 13 12 03 01 08 13 09 45 01 08 13 09 05 01 08 13 11 42 01 08 13 11 53 05 08 13 09 16 15 days 1 hours 59 mins 1
43. Jetty Healthcare C C NSCCAHS Transitional Woy Woy Hospital C Wyong Hospital Prediction Data Extract UserAccess List UserAccess Logins e Q Report Infomation EDD Compliance by Ward Definition Provides an overview of LOS for each Specialty and AMO within a facility at a given date time LOS is displayed as 0 4 days Ward Activity 5 9 days 10 14 days Ward Activity Snapshot 15 19 days 4 Ward Occupancy 2 5 s s Ward Patient Lists ee Usage Allows Patient Flow Managers Clinical Managers Nurse Unit Mangers Medical Officers and Hospital Executives to review current inpatient LOS data Ward Profile Ward Setup Predicted Adm via ED by Spec Specialty Activity Specialty Activity Snapshot Reports Manual Page 13 of 185 Wis GOVERNMENT Health 1 3 1 Report Prompts The report prompts defined in Table 3 are specific to each report The prompts specific to each report are detailed in the overview table for each report Table 3 Report Prompt Prompt Definition The facilities the user is able to run the report for in the selected LHD The list displayed is dependent on the user s access level and will always default to the LHD Facility selected from the drop down list at the top of the window Facilities One many or all facilities can be selected by ticking the associated checkbox es All facilities can be selected at once by ticking the checkbox entitled Select All unticking the c
44. LOS gt 49 days during the given patients with specialty descriptions in calculation 4 Mental Health Pts Reports Manual Page 120 of 185 UM GOVERNMENT Health Format Definition Rules Calculations month excluding mental health patients Avg Pts Utilising Available beds utilised by patients with Count of patients with LOS gt 49 days Percentage Available Beds LOS gt 49 days as a percentage Average available beds per day across the LHD for the given month x 100 LOS gt 99 days Text Title for data about LOS gt 99 days N A Number of patients whose admission Pts Numeric had a LOS gt 99 days during the given Count of patients with LOS gt 99 days between the 1st and last day of the month month Mental Health Number men HERRN panen Count of patients with LOS gt 99 days between the 1st and last day of the month and Specialty Codes Numeric whose admission had a LOS gt 99 days Pts i detailed above during the given month Number of patients whose admission Pts Exc had a LOS gt 99 days during the given Count of patients with LOS gt 99 days between the 1st and last day of the month excluding the Numeric i Mental Health month excluding mental health patients with Specialty Codes detailed above patients Avg Pts Utilising Bardens Available beds utilised by patients with Count of patients with LOS gt 99 days Average ava
45. Life Threatening gt 4 hours a Urgent Specialist Care saka 24 hours Inpatient Specialist Care 24 72 hours 712 hours Return Transfer of Care od gt 1 Busi D Post Specialist Care er Future Inpatient gt 72 hours based on Ciastitias the transfersoutormnto Specialist Care 24 72 Estimated Transfer the facility as being within or hours Date Time outside the expiration period for Future Return Transfer gt 1 Business Day based on each Urgency Category of Care Post Specialist Estimated Transfer Vertical e Life Threatening Care Date Time Urgency Grouped Bar e Urgent specialist care lt 24hrs i Chart e Inpatient specialist care 24 lf Urgency Category equals one of 72hrs e Life Threatening e Urgent Specialist Care lt 24 hours e Inpatient Specialist Care 24 72 hours e Return Transfer of Care Post Specialist Care Then the transfer is included in the count for the given Urgency Category e Return Transfer of Care Post Specialist Care If Urgency Category equals Future Inpatient Specialist Care 24 72 hours then the transfer is included in the count for the Inpatient Specialist Care 24 72 hours Urgency Category If the Urgency Category equals Future Return Transfer of Care Post Specialist Care then the transfer is included in the count for the Return Transfer of Care Post Specialist Care Urgency Category Reports Manual Page 97 of 185 UM GOVERNMENT
46. MAU FY SUMMMANY Vee 159 10 6 LHD AUS iI as ce sncctcacsienansvesepadiecdensganecentiactansateqeanedinedenspioevanetdencteceeatiacdever 161 10 7 LHD MA Snapshot SUMMATY vrede 163 10 8 LHD MAU FY SIT AN aa 166 10 9 NSW Health MAU Snapshot Summary rrrnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnee 168 10 10 NSW Health MAU Performance Trend Summary rrrnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnner 171 10 11 NSW Health MAU Process Trend Summary rrnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnner 174 Reports Manual Page 4 of 185 Wis NSW Health 10 12 NSW Health MAU FY NAs and 177 10 13 NSW Health MAU Re Admission Summary ccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeseeeeeeeeeeeees 179 11 0 Admission RISK Reports Legen tege haddejersgeedade dekade eddeaddongandgaddgdedddengandgaaddeaddeddet 181 TV Admission Risk RT vere 181 11 2 Admission RISK Control Charts vexienaecanacvaawaternuncanidys dine encdiat nade onnnaea tans aeianteans 184 Reports Manual Page 5 of 185 Health GOVERNMENT Commonly Used Terms acronym Deseo O ED Emergency Department EDD Estimated Discharge Date EDO Extended Day Only EDWARD Enterprise Data Warehouse EMU Emergency Medical Unit HIE Health Information Exchange LHD Local Health District LOS Length of Stay NEAT National Emergency Access Target PFP Patient Flow Portal W4W Waiting for What
47. Medical Officer Alphanumeric Patient s AMO N A Specialty patient is currently admitted Specialty Alphanumeric diner N A Admission DD MM YY re or Date Time hemm Patient s admission date time N A Displays in the corresponding colour as on st the Patient Mode in PFP EDD DD MM YYYY Rennes EOD Displays with a bold border if the EDD was auto generated Age Numeric Patient s age N A WLOS Numeric Patient s LOS in the given ward N A HLOS Numeric Patient s total LOS in the facility N A Financial Status Alphanumeric Patient s Financial Status N A Financial Bagi ts ses f Description Alphanumeric Patient s Financial Description Displays on Excel only DOB DD MM YYYY Patient s Date of Birth Displays on Excel only WFW Alphanumeric ope Na f r What Reasoris Displays on Excel only recorded against the patient Admission Reason Alphanumeric Patient s reason for admission Displays on Excel only Admission Risk Alphanumeric Admission Risks the patient has met the criteria for Displays on Excel only Reports Manual Page 48 of 185 GOVERNMENT Health 3 6 Ward Profile Table 29 Ward Profile Overview Repo De O oo DO DF O ele O po Pro 0 o O O o Repo O ejg Reports Manual Ward Profile Provides a view of the following for each hour of the day e Number of available open surge unavailable and
48. Report Group Reports Facility Operational Summary Trend Facility Operational Summary e Facility Whole of Hospital Snapshot Executive Reports LHD Operational Summary Trend LHD Operational Summary NSW Health Operational Summary e Whole of Hospital Snapshot e Facility MAU Summary e Facility MAU Snapshot Summary e Facility MAU FY Summary Facility MAU Re admissions LHD MAU Summary Medical Assessment Unit LHD MAU Snapshot Summary Reports LHD MAU FY Summary NSW Health MAU Snapshot Summary e NSW Health MAU Performance Trend Summary e NSW Health MAU Process Trend Summary NSW Health MAU FY Summary e NSW Health MAU Re Admission Summary dmission RKR e Admission Risk Control Chart pCinlsston Blane pert e Admission Risk Records Reports Manual Page 9 of 185 Wii NSW Health 1 2 Accessing Reports A user s access level determines the reports which they will have access to Table 2 User Access Levels to Generate Reports indicates user level has access Admission Risk Admission Risk Control Chart Direct Ward Admission Records EDD Compliance by Facility EDD Compliance by Ward EPJB Audit Log Facility MAU Re admissions Facility MAU Summary Facility MAU Snapshot Summary Facility MAU FY Summary Facility Operational Summary Facility Operational Summary Trend Hospital Occupancy IHT Hourly Performance
49. Sa Date the user last logged into PFP N A Number of users who have logged onto Count of number of users who logged onto Number of Users Numeric the facility during the specified date the facility excluding System range Administrators Number of Logins Numeric Total number of logins for the facility Count of number of successful logins for a during the specified date range facility excluding System Administrators Reports Manual Page 32 of 185 NSW GOVERNMENT 3 0 WARD REPORTS Health 3 1 Clinician Defined EDD Compliance by Ward Table 18 Clinician Defined EDD Compliance by Ward Overview Reports Manual EDD Compliance by Ward Provides an average daily snapshot of the percentage of patients with LOS gt 24hrs and clinician defined EDD for specific wards or ward groups within a facility Allows Patient Flow Managers Clinical Managers Nurse Unit Mangers and Hospital Executives to review EDD compliance as a measure of care coordination within the organisation PFP All Users except Ambulance User PDF only Produces three sub reports Summary table A summary table detailing the EDD compliance per day week or month as selected for each ward or Ward Group All wards or Ward Groups Ave Compliance comparison graph A graph comparing the EDD compliance of all wards of Ward Groups selected Individual ward gt 95 Compliance graph A graph displaying the EDD compli
50. Time gt 24 hours e Completed Time was between the first and last day of month Urgency Inpatient Specialist Care 24 72 hours Sum of minutes for patient transfers out of the selected LHD with e Urgency Inpatient Specialist Care 24 72 hours e Request Transfer Time to Transfer Completed Time gt 72 hours e Completed Time was between the first and last day of month OR e Urgency Future Inpatient Specialist Care 24 72 hours e Estimated Transfer Time to Transfer Completed Time gt 72 hours e Completed Time was between the first and last day of month Count of patient transfers out of the selected LHD with e Urgency Inpatient Specialist Care 24 72 hours AND Request Transfer Time to Transfer Reports Manual Page 128 of 185 Wis GOVERNMENT Health Format Definition Rules Calculations Completed Time gt 72 hours e Urgency Future Inpatient Specialist Care 24 72 hours AND Estimated Transfer Time to Transfer Completed Time gt 72 hours e Completed Time was between the first and last day of month Urgency Return Transfer of Care Post Specialist Care gt 1 business day Sum of minutes for patient transfers out of the selected LHD with e Urgency Return Transfer of Care Post Specialist Care gt 1 business day e Request Transfer Time to Transfer Completed Time gt 1 business day e Completed Time was between the first and last day of month OR e Urgency Return Transfer of
51. Ward Code First Patient ID Name Surname Facility From Facility To Long Jetty Healthcare Centre Gosford Hospital Gosford Hospital Gosford Hospital NSCCAHS Transitional Care Beds Central Coast Gosford Hospital Gosford Hospital Gosford Hospital Gosford Hospital Long Jetty Healthcare Centre Long Jetty Healthcare Centre Long Jetty Healthcare Centre Long Jetty Healthcare Centre NSCCAHS Transitional Care Beds Central Coast Reports Manual Requesting Ward Code Requesting Ward Description Urgency Category Inpatient specialist care 24 72hrs Specialty Not Specified Urgent specialist Not care lt 24hrs Specified Urgent specialist Not care lt 24hrs Specified Inpatient specialist care 24 72hrs Not Specified Inpatient specialist care 24 72hrs General Medicine Urgent specialist Addiction care lt 24hrs Medicine Inpatient Acute specialistcare Geriatric 24 72hrs Medicine Urgent specialist Not care lt 24hrs Specified Urgent specialist Not care lt 24hrs Specified Inpatient specialist care 24 72hrs General Medicine Inpatient specialist care 24 72hrs General Medicine Urgent specialist Not care lt 24hrs Specified Life threatening ett d Return Transfer ofCare Post Not SpecialistCare Specified Transfer Request Time 20 06 11 11 33 04 11 13 15 44 09 10 13 15 26 04 11 13 15 46 08 08 13 14
52. a specific facility Analyse the data to better understand trends and patterns for a facility s demand PFP All users except Ambulance Users Excel only Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights From Date default Today The start date for the report based on the Transfer Request date time of the transfer To Date default Today The end date for the report based on the Transfer Request date time of the transfer Chronologically by Transfer Request date time N A A transfer must have a status of Requested or Completed to appear on the report Page 104 of 185 W NSW Health Figure 51 Inter Ward Transfer Records Layout Inter Ward Transfer Records Count of Records 161 Requesting Requesting Ward Current Ward Current Ward Requesting To Ward Code To Ward Description Surname First Name Patient ID Contact Name Contact Phone RecaWing Horang EEANN Ward Code Description Code Description Date Time Entered Urgency Doctor Doctor Doctor Contact Status 7 vg P MOREE Intensive Care Unit H1 E 28 04 2012 male Neralee 55310 Public care lt 24hrs Medicine r Urgent specialist Intensive Care Unit H1 arne 28 04 2012 male Neralee 55310 Public care lt 24hrs Medicine a r ion beror Intensive Care Unit G3 Cardiology Gastro CCU Coronary Care Un
53. displays depends on the LHD preferences Patient Name Alphanumeric Patient s Name PDF Displays as Surname First name Surname Alphanumeric Patient s Surname Excel N A First Name Alphanumeric Patient s First Name Excel N A Ward From Alphanumeric Ward Code the patient was PDF and Excel N A Code transferred from Warg From Alphanumeric Ward Description thepatient was PDF and Excel N A Description transferred from Ward To Code Alphanumeric Ward Code theipatient is being PDF and Excel N A transferred to Ward To Alphanumeric Ward Description the patient is being PDF and Excel N A Description transferred to Urgency is one of following e Life Threatening Urgency Alphanumeric Urgency of the transfer PDF and Excel e Urgent Specialist Cares 24 Category hours e Inpatient Specialist Care 24 72 hours Specialty Alphanumeric Specialty of the patient s AMO PDF and Excel N A Estimated DD MM YY Date time the patient is estimated to Transfer Time hh mm be transferred POP and Excel N A Transfer DD MM YY Date time the transfer was System generated time based on PDF and Excel Request Time hh mm requested when the transfer was requested Transfer i Completed DD MM YY Date time the patient arrived at the PDF and Excel N A hh mm receiving ward Time XX day s Time taken between the Transfer If the Request ea Completed ae Request to i exceeds the expiration time for t
54. met the criteria N A Count of Records Numen Number of admission risk records in the N A specified date range Reports Manual Page 183 of 185 Health GOVERNMENT 11 2 Admission Risk Control Charts Table 103 Admission Risk Control Charts Overview Business rules Reports Manual Admission Risk Control Charts Control Chart that displays 24 months of counts of historical admission risk data for a specific facility Used by Connecting Care users to view a rolling record of historical admission risk data PFP Patient Flow Manager Patient Flow Administrator Connecting Care User Control Chart Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights Admission Risk default Multiple Admissions Drop down list of Admissions risks to display on the Control Chart Month default Last month The last month the user wants to view the Control Charts for The Control Chart will display data from July 2012 up to the last month Chronologically by month If any of the months have met a Nelson Rule they will be highlighted with a red circle around the point and the rule that has been met will be displayed under the Control Chart e A patient will appear in the count for an Admission Risk for the month in which their admission date falls e g if a patient was adm
55. occupancy for wards or ward groups based on a daily weekly or p monthly snapshot as defined by the user a s Reporting on occupancy for specific wards or ward groups e g Occupancy for medical 15 wards or surgical wards Repo DELE 2 PFP er Acce All Users except Ambulance User Report Forma PDF default and Excel Wards The ward or wards the user wants to run the report for All Wards display EG within the selected facility the user has access to Ward Groups The Ward Group or Ward Groups the user wants to run the report for 3 Snapshot time Daily Weekly Monthly 1 Sort Chronologically by Date Repo O O gel 2 Sort Alphabetically by Ward Code or Ward Group The report will highlight in red the day week or month with the highest occupancy in the reporting period Alerts Business Rules N A Figure 19 Ward Occupancy Layout Ward Occupancy Daily Snapshot for the Perio Average Occupancy by Wards Ward Code and Description 23HR 23hr Peri op ED Accessible Ward 94 7 AGEP5 AACE Unit ED Accessible Ward 1000 AGEP6 Aged Care P6 ED Accessible Ward 79 0 AREH Aged Care Rehab 92 9 Cardiac_MAU Cardiology MAU ED Accessible Ward 78 2 CARDIO Cardiology 3N ED Accessible Ward CARDIOTHOR Cardiothoracic 3S ED Accessible Ward CCU CCU ED Accessible Ward CORRECTIONS Corrections 9E CTICU CTICU Geriatrics_MAU Aged Care MAU ED Accessible Ward HAEM Haematology P10W
56. of completed inter Hospital transfers of patients by Speciality and Urgency de g Category into and out of a facility between a specified date range am Provides a summary of main transfer specialities and urgency category Can assist in demand and capacity planning for incoming and outgoing specialities Repo BELE kje e PFP er Acce All users except Ambulance Users epo O 3 PDF only Produces two sub reports Specialty Urgency Category Summary table A summary table detailing the counts of b repo urgency category per speciality into and out of the given facility Top 5 Specialty graph A graph detailing the top 5 specialities of patients transferred into and out of the given facility Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights From Date default Today The start date for the report based on the Completed date time of the transfer To Date default Today The end date for the report based on the Completed date time of the transfer Specialty Urgency Category Summary table 1 Sort Alphabetically by specialty ort Orde 2 Sort Urgency Category Top 5 Specialty graph 1 Sort Alphabetically by specialty Ale N A e e A transfer must have a status of Completed to be included on the report Figure 49 Patients IN OUT Specialty Urgency Category Summary Table Layout P
57. patients Total Patient i OFA PAMENS Numeric transferred out of or into the N A Figure 50 Patients IN OUT Top 5 Speciality Graph Layout Patients IN OUT ig i Number of Patients IN Number of Patients OUT Reports Manual fu For the Period 01 11 13 to 29 11 13 Excludes incomplete transfers Specialty ME Orthopaedic Surgery Ml Neurosurgery Urology Cardiology Procedural Cardiology Medical Gastroenterology Specialty ll General Medicine ME Rehabilitation Medicine NN Cardiology Medical ME Urology Cardiology Procedural Psychiatry General Surgery Page 102 of 185 Health GOVERNMENT Table 70 Patients IN OUT Top 5 Speciality Graph Data Elements Field Format Definition Rules Calculations Description of the top 5 Specialty Legend specialties as detailed on the N A graphs Total number of transfers for Number of meron Numeric each of the top 5 specialties into N A Patients IN zs is the specific facility Total number of transfers for by cai Numeric ach of the top 5 specialties out N A Patients OUT E ee le ee of the specific facility Reports Manual Page 103 of 185 Health GOVERNMENT 7 0 TRANSFERS IWT REPORTS 7 1 Inter Ward Transfer Records Table 71 Inter Ward Transfer Records Overview Reports Manual Inter Ward Transfer Records Excel file of Inter Ward Transfers records within a user defined date range for
58. r r r Reports Manual Page 153 of 185 NSW GOVERNMENT Health 10 3 Facility MAU Summary Table 90 Facility MAU Summary Overview Reports Manual Facility MAU Summary Provides the following information about Medical Assessment Units based on a date period defined by the user for 1 or more facilities a user has approved access to e Average Total Hours in ED for all MAU Patients e Average LOS in MAU Hours e Average LOS of MAU Patients Transferred to a Ward Days e Readmission Rates within 28 days of MAU Home or MAU ward home discharges e Separations from MAU e Average LOS in MAU for patient aged 65 Hours e patients transferred from MAU within 48 hours e patients discharged home from MAU e patients discharged home from MAU within 48 hours e MAU patients transferred to ward e Admissions direct to MAU e Re admission rate of MAU home discharges ONLY e MAU NEAT The data is presented in tabular format with 4 tables e Table 1 Displays data for the defined date period e Table 2 Displays data for the defined date period based on admissions or discharges from MAU between the hours of 08 00 01 16 00 e Table 3 Displays data for the defined date period based on admissions or discharges from MAU between the hours of 16 00 01 00 00 e Table 4 Displays data for the defined date period based on admissions or discharges from MAU between the hours of 00 00 01 08 00 Note Readmissi
59. rate of MAU from MAU from MAU to i home from a direct to home or MAU aged 65 ward within 48 MAU MAU within MAU discharges ward home hrs hrs 48 hrs ONI discharges Avg LOS of Avg totail MAU hours in ED Avg LOS in patients for all MAU MAU hrs transferred patients to a ward days Facility 4 3 53 7 10 2 54 17 4 243 For the period 01 02 2014 to 28 02 2014 16 00 00 00 Re Re oa rv Patients messer Patients el Aass admission Separations transferred 5 discharged MAU home patients transferred from MAU discharged koano ROM Admissions rate of MAU from MAU from MAU to home from direct to home or MAU aged 65 ard within 48 MAU MAU within MAU dischar ward home hrs hrs 48 hrs Care discharges Avg LOS of Avg totai MAU hours in ED Avg LOS in patients for all MAU MAU hrs transferred patients to a ward days Facility Patient Flow Portal Medical Assessment Unit Report M Page 1 of 3 NSW Health Reports Manual Page 155 of 185 GOVERNMENT Health 10 4 Facility MAU Snapshot Summary Table 91 Facility MAU Snapshot Summary Overview Facility MAU Snapshot Summary Provides information about Medical Assessment Units based on a daily weekly or monthly snapshot for 1 or more facilities a user has approved access to Average Total Hours in ED for all MAU Patients Average LOS in MAU Hours Average LOS of MAU Patients Transferred to a Ward Days Readmission Rate
60. rights From Date default Today The start date for the report based on the Admission Request date time of the admission To Date default Today The end date for the report based on the Admission Request date time of the admission Chronologically by Admission Request date time N A An admission must have a status of Requested or Completed to appear on the report Page 114 of 185 z NSW Health Figure 56 Direct Ward Admission Records Layout Direct Ward Admission Records For the Pe Count of Records 25 Date Time Accepting A Specialty Estimated Isolation Date Tit Date Time Er Surname First Name Patient ID ntact From Location To Ward Code To Ward Description Ca Specialty Length of Bed Type Clinical Note Req Rel Admitted g No 26 11 13 11 04 02 10 1937 male Muse BSURG Surgical B 00000 Not Specified Okana ot BADON at TJERN 26 14 13 11 05 22 11 13 11 26 08 04 1959 female Home BSURG Surgical B 03000 General Surgery admit OIN for IVA admit day prior to surgery for IVI i Unknown 22 11 13 11 27 25 11 13 07 29 Heparin Hernia repair Monday 21 11 13 20 16 23 06 1961 male Home Periop Periop Unit 03000 General Surgery 1 amp D scrotal abscess Unknown 21 11 13 20 17 22 11 13 08 39 missed miscarriage requires cervagem 19 11 13 19 26 14 02 1974 female Home Periop Periop Unit 04000 Gynaecology D amp C No 19 11 13 19 27 20 11 13 12 25 20 11 13 11 27 13 05 1984 femal
61. selection depends on the user s access rights From Date default Today The start date for the report based on the Transfer Request date time of the transfer To Date default Today The end date for the report based on the Transfer Request date time of the transfer Chronologically by Transfer Request date time Reports Manual N A A transfer must have a status of Requested Confirmed In Progress or Completed to appear on the report Page 78 of 185 Z NSW Health Figure 36 Inter Hospital Transfer Records Layout Inter Hospital Transfer Records From Requesting Requesting Ward Current Ward Current Ward Requesting Receiving Receiving Financial Date Time Entered Urgency Facility ID From Facility Ward Code Description Code Description Surname First Name Patient ID Dotar Contact Name Contact Phone Doclor erar n Status 26 11 13 14 24 eee 201 halser REHAB J201 Rehabilitation NO285577 12 04 1935 male Flynn 49855300 49855300 Public p p r gjeng a209 heri ED Emergency Department 0441232 14 03 1925 female Brown 49855300 49855300 r r r er 0216 per one MWW SMS Millicent White Wing 0561439 29 0911983 female Tan 49855300 49855300 7 7 r r r A J305 oe general general 0665196 20 02 1923 male Dobell Brown 49855300 49855300 Inpatient specialist 0211 Calvary Mater care 24 72hrs Newcastle Urgent specialist Moree District r b b care lt 24hrs 121 Hospital
62. some period during the date range entered in the report prompts o WFW Start date is before the Date From and has a status of Open o WFW Start date is before the Date From and has a Close date or Discharge date after the Date To o WFW Start date is before the Date From and has a Close date or a Discharge date between the Date From and the Date To o WFW Start date is between the Date From and the Date To and has a status of Open e The Pareto Chart and Summary table displays the count of WFW reasons within the reporting period which contribute to the 80 cumulative total The remaining WFW reasons are then grouped into the Others column Page 73 of 185 Health GOVERNMENT Figure 33 Waiting for What Reasons Count Pareto Chart and summary table Layout Waiting for What Reasons Count For the Period 01 11 13 to 20 11 13 Waiting for What Reasons Summary Total R Romans per ee Toa Reason 5 Out of Hospital Referral Rehabilitation Bed or Service 24 24 100 Discharge Process Other 44 20 Diagnostics Treatment Other 56 Transfer Transport IHT Waiting for Bed Accepting Facility Consults Rehabilitation 76 Consults Vascular 80 Diagnostics Treatment Operating Theatre 84 Others 100 68 agenwng Rehabilitation Vascular Operating Theatre Rehabilitation Bed or Ser
63. the transfer was System generated time based on PDF and Excel Time hh mm requested when the transfer was requested Bed Confirmed DD MM YY Date time the ped was Time the receiving hospital ticks the confirmed by the receiving PDF and Excel aay Time hh mm ms Confirm checkbox facility Time taken between the XX day s if a sige Request to Request Transfer Time and Bed Confirmed Time minus XX hour s PDF and Excel le 2 Confirmed Time the time the bed was Transfer Request Time XX min s confirmed Earliest of Date time the patient was Time the sending hospital clicks on DD MM YY i gt Patient Sent Time hhmm sent from the requesting PDF and Excel the In Progress checkbox or facility Time patient is discharged from the sending hospital on the PAS Time taken between the Confirmed to Sent XX day s ume thg ped was In Progress Time minus Bed XX hour s confirmed and the time the PDF and Excel aa Time i Confirmed Time XX min s patient was discharged from the requesting facility Earliest of Date time the patient Time the receiving hospital clicks on Transter Completed DD MM YY arrived at the receiving PDF and Excel the Completed checkbox or Time hh mm i i facility Time patient is admitted into the receiving hospital on the PAS Time taken between the XX day s time the patient was a Sent to Completed discharged from the Completed Time
64. under specific groups defined in the table below Each report also has different report prompts that can be customised by the user before the report is generated as detailed in Section 1 3 1 Table 1 Report Groups Report Group Reports e Clinician Defined EDD Compliance by Facility EPJB Audit Log n Hospital Occupancy PERE REPONS Prediction Data Extract User Access List User Access Logins Clinician Defined EDD Compliance by Ward e Ward Activity e Ward Activity Snapshot e Ward List e Ward Occupancy e Ward Patient Lists e Ward Profile e Ward Setup LOS by Specialty and AMO e Predicted Admissions via ED by Specialty Ward Reports Specialty Hearts e Specialty Activity e Specialty Activity Snapshot e Waiting for What All Reasons e Waiting for What Current Admissions Open Reasons e Waiting for What Bed Days e Waiting for What Reasons Count Waiting for What Reports Inter Hospital Transfers Hourly Performance Inter Hospital Transfer Records e Patient Open Transfers e Patients IN OUT Tangiers HE Hepar e Patient Open Transfers by LHD e Patient Transfer Cancellations e Patient Transfer Times Graph e Patient Transfer Times Inter Ward Transfer Records Transfers IWT Reports Inter Ward Transfer Times e Patient Open Inter Ward Transfers Transfers DWA Reports Direct Ward Admission Records Reports Manual Page 8 of 185 GOVERNMENT H ea l t h
65. ward The Emergency Department admission Unit type 17 or 58 in DAYS EPISODE table MAU discharged to place of usual residence trans_type DIS AND unit_type is a MAU ward in the DAYS_EPISODE table or if the last ward is a transit lounge the previous ward is used AND Inpatient mode_of_separation in 1 2 3 6 7 8 11 in the EPISODE table Time period Same facility sum episode_length_hours gt 0 where unit_type 87 Re admissions are identified based on 109 i j MAU Discharged ae ne patient was discharged from Numerator cal aly Pig i the admission date of the 2 denominator that had an admission via the ee Home the MAU an inpatient ward or ae admission emergency department within 28 days of i i the discharge lounge If the discharge Exclude patients with Planned patient went to a discharge Admissions within 28 days following st Fs saan rd Denominator Total number of patients the 1 admission 8 8 discharged from MAU or MAU ward to usual in any calculations and the A place of residence i e last ward can be MAU prior ward is deemed to be the i or Inpatient Ward last ward Data sources DAYS_EPISODE EPISODE STAY Process Indicators Discharged patients Separations from P Patients admitted aid Count of stays where patient was in a MAU un Al MAU discharged f MAU META er Data Source Tables DAYS EPISODE EPISODE epi
66. whichever occurs first e Discharge Date for the patient s admission e WAW reason Closed Date e No date as WFW reason is still open Total Sum of all bed days consumed for all W4W reasons Count of bed days consumed for W4W reasons with Category category timeframe between the first and last day of the month Percentage Consults Capacity equivalent percentage in Diagnoses Wini Discharge Process Capacity terms of the number of bed days Out of Hospital Referral Equivalent consumed by W4W delay reasons by Transfer Transport Category Sum of daily average of number of available beds across the LHD Daily average is calculated as sum of hourly snapshots divided by 24 x 100 Avg Pts with Percentage of patients who had an i Waiu Reason Percentage on WAW reason benene ft Cutt ater ta pe MM rense beteen he frst ad at ay of the month per category and last day of the month p P Inter LHD G Title for data about Inter LHD Patient Patient Text N A Transfers Transfers Urgency Life Threatening Count of completed inter LHD patient transfers out of the selected LHD with e Urgency Life Threatening e Request Transfer Time to Transfer Completed Time gt 4 hours Number of completed patient e Completed Time was between the first and last day of month Breached transfers out of the given LHD that Transfers OUT Numeric breached the recommended urgency Urgency Urgent Specialist Care lt 24 ho
67. 0 03 00 04 00 05 00 06 00 07 00 08 00 09 00 10 00 11 00 12 00 13 00 14 00 15 00 16 00 17 00 18 00 19 00 20 00 21 00 22 00 23 00 Snapshot Time MN Total OUT MN Total IN Reports Manual Page 76 of 185 Health GOVERNMENT Table 52 IHT Hourly Performance Summary table Data Elements Field Format Definition Rules Calculations DD MM YYYY Date Day Day of the Date and Day of the week N A week For today s date the report will only display up to the last hour Shap ho titi For example if the report was generated at Snapshot Time hh mm p 10 15AM on the 14th January 2013 the report will display data for the 14th January 2013 from 00 00 to 10 00 and NULL completed transfers from 11 00 to 23 00 N Count of the number of Transfers IN Number of completed patient transfers or i within the given hour i e where Transfers IN Numeric during the given hour into the selected p er ac Completed date time is within the given facility hour Displays the number of completed count of thie number or Tanien Out within the given hour i e where In Transfers OUT Numeric patient transfers out of the selected i E a O i p Progress date time is within the given facility hour REG ee oa OFTEN Sum of ALL Transfers IN for the given date Total Daily Numeric g Sum of ALL Transfers OUT for the given Displays Total number of Transfers OUT dat for the given date f Displays Total num
68. 0 days IRNC3 22 11 13 08 54 25 11 13 13 30 Medical 4hours In Progress 10 days 22 11 13 15 06 25 11 13 15 05 Medical 2 hours In Progress 9 days Urgent specialist V eurosurgery 26 14 1307 41 26 11 13 07 40 Surgical Qhours In Progress care lt 24hrs Inpatient Medical 9 days EMERGENCY EMERGENCY specialist care On 26 11 13 08 38 26 11 13 08 35 Medical 9 hours Confirmed cology 24 72hrs Inpatient General 9 days specialist care 26 26 11 13 08 54 26 11 13 08 50 Med 8 hours In Progress Medicine 24 72hrs 9 days 26 11 13 10 58 26 11 13 10 55 Medical 6 hours Confirmed Urgent specialist Cardiology care lt 24hrs Procedural EMERGENCY EMERGENCY Inpatient Rehabilitatio 9 days specialist care 26 11 13 11 18 26 11 13 11 15 Medical 6 hours In Progress n Medicine 24 72hrs Inpatient dad 9 days specialist care Rehabilitatio 36444443 11 36 26 11 13 11 35 Medical 6 hours In Progress 24 72hrs n Medicine Inpatient Rehapilitatio 9 days specialist care a 26 11 13 12 08 26 11 13 12 05 Med 5 hours In Progress n Medicine 24 72hrs 9 days Urgent specialist Rehabiliatio 26141113 12 47 26 11 13 12 45 Med 4hours in Progress care lt 24hrs n Medicine Inpatient Diiia ED Staff 9 days specialist care p 26 11 13 13 54 26 11 13 13 50 Unknown Med Specialist 3 hours In Progress Medicine 24 72hrs Consultant Inpatient General ED Staff 9 days F1 Orthopaedic F1 Orthopaedic specialist care E 26 11 13 14 01 26 11 13 14 00 Specialist 3 ho
69. 08 13 19 54 3 hours 16 mins 4 hours 4 mins 2 days 3 hours 26 mins 16 days 6 hours 56 mins 01 08 13 12 41 4 hours 5 01 08 13 18 35 6 mins mins 1 days 19 hours 47 mins 1 days 9 hours 27 mins 2 hours 48 mins 01 08 13 14 43 01 08 13 16 20 1 hours 6 05 08 13 15 37 1 mins mins 7 days 5 hours 29 mins 1 days 5 hours 56 mins 5 days 4 mours 26 mins Page 93 of 185 Ws GOVERNMENT Health Table 62 Patient Transfer Times Data Elements PDF and Excel Field Patient ID Format Alphanumeric Definition Patient s UID or MRN Report Format PDF and Excel Rules Calculations Which value displays depends on the LHD preferences Patient s Surname Patient Name Alphanumeric Patients First N me PDF N A Surname Alphanumeric Patient s Surname Excel N A First Name Alphanumeric Patient s First Name Excel N A Facility From Alphanumeric Facility the patient was PDF and Excel N A transferred from Facility To Alphanumeric Facility the patient was PDF and Excel N A transferred to Urgency category allocated Urgency Category Alphanumeric t thetransfer PDF and Excel N A Specialty Alphanumeric Specialtyof the patient s PDF and Excel N A AMO Date time the patient is Estimated Transfer DD MM YY estimated to be PDF and Excel N A Time hh mm transferred Transfer Request DD MM YY Date time
70. 13 08 11 13 08 11 13 08 11 13 14 1113 22 11 13 22 11 13 22 11 13 22 11 13 22 11 13 WFW Total Days 4 11 12713 08 12 13 06 12 13 12142113 02 12 13 29 11 13 10 12 13 26 11 13 03 12 13 24 07 13 16 12 13 30 11 13 29 11 13 16 1113 10 12 13 15 11 13 10 12 13 08 12 13 10 12 13 04 12 13 06 12 13 EDD Specialty Orthopaedics Neurosurgery Vascular Vascular Geriatrics Vascular Orthopaedics Orthopaedics Orthopaedics Rehabilitation Orthopaedics Orthopaedics Orthopaedics Immunology Orthopaedics Orthopaedics Orthopaedics Orthopaedics Orthopaedics Orthopaedics Ward Code Ward Description Med Officer RNC 1 Orthopaedic Rehabilitation RNC 1 Orthopaedic Rehabilitation F3 Cardiac Surgery Vascular F3 Cardiac Surgery Vascular RNC 1 Orthopaedic Rehabilitation F3 Cardiac Surgery Vascular F41 Orthopaedic F41 Orthopaedic F1 Orthopaedic North Ward Rankin Park Hospital RNC 3 Orthopaedics H3 Surgery Trauma H3 Surgery Trauma Out amp About Hospital in the Home F1 Orthopaedic South Ward Rankin Park Hospital F41 Orthopaedic F1 Orthopaedic F41 Orthopaedic F41 Orthopaedic F1 Orthopaedic Page 69 of 185 Financial Status Chargeable Public DVA Public Public Public Public Public Public DVA Public Public Compensable Public Public Public Public Public Public
71. 13 MEG Ke celts Total Transfers Transfers IN OUT Medical ward 5071 5074 10145 Obstetric ward 1635 1638 3273 Paediatric ward 1012 1018 2030 Surgical Wards 1999 2002 4001 Reports Manual Page 40 of 185 UM GOVERNMENT Health Figure 15 Ward Activity Ward Type Layout Ward Activity Ward Type Activity Aged Care Emergency Hospital In The Home Medical Mental Health Neurosciences Obstetrics Paediatrics Rehabilitation Surgery For the Period 01 08 2013 to 31 10 2013 KE 01 08 2013 31 10 2013 Ward Type Transfers 272 8859 246 Transfers Total OUT 270 542 8872 246 6288 357 290 1638 1018 334 2710 Table 22 Ward Activity Data Elements The Ward code and Description within respective ward ward type and ward group for the defined date range Ward Alphanumeric the selected facility N A The Ward Group name which has wards As defined in the Bed Management Admin Ward Group Alphanumeric ae a assigned to it within the selected facility module of PFP Ward Type Albha urneric The Ward Type which have Wards As defined in the Bed Management Admin YP 4 assigned to it for the selected facility module of PFP Date range for the report as defined by The period of Activity is repeated on each Activity DD MM YYYY the user and displayed as Ward Ward Group and Ward Type sub DD MM YYYY DD MM YYYY reports The number of patients that have
72. 13 10 30 01 08 13 15 04 Request for transfer not Surgery appropriate John Hunter Calvary Mater Inpatient specialist Radiation Patient transferred to another Hospital Newcastle care 24 72hrs Oncology 26 07 13 16 23 26 07113 16 20 01 08 13 08 11 la Guy John Hunter Newcastle Private Inpatient specialist Rehabilitatio 45 Request for transfer not Hospital Hospital care 24 72hrs nMedicine 26 07 13 21 31 26 07 13 21 30 22 08 13 09 15 appropriate John Hunter Newcastle Private Inpatient specialist Rehabilitatio Patient transferred to another Hospital Hospital care 2472hrs nMedicine 20 07 13 13 02 30 07 13 12 55 07 08 13 11 00 Gy John Hunter Coffs Harbour Inpatient specialist General Treatment provided completed at Hospital Base Hospital care 24 72hrs Medicine SARTRE aana BARNES SEE Tsesre Jon er Maitland Hospital Patient specialist Orthopaedic 31 07 43 14 11 34 07 13 14 10 01 08 13 09 57 Patient discharged Hospital care 24 72hrs Surgery John Hunter Hunter Valley Inpatient specialist Rehabilitatio Hospital Private Hospital care 24 72hrs n Medicine J3 unable to advise if patient is 92 08 13 12 16 02 08 13 12 15 03 08 13 16 32 Cancelled by receiving hospital aiting transfer John Hunter Newcastle Private Inpatient specialist Rehabilitatio Request for transfer not Hospital Hospital care 2472hrs nMedicine 02 08 13 17 27 02 08 13 17 25 21 08 13 07 29 appropriate John Hunter Hunter Valley Inpatient specialist
73. 16 00 e Table 3 Displays data for the defined date period based on admissions or discharges from MAU between the hours of 16 00 01 00 00 e Table 4 Displays data for the defined date period based on admissions or discharges from MAU between the hours of 00 00 01 08 00 Note Readmission data is calculated based on 28 days since the patient was discharged from their previous admission where they visited a MAU As such if this report is generated for last 28 days prior to today the readmission data will not be up to date Can be used to obtain an overview of the operations and performance of Medical Assessment Units in a LHD HIE All users except Ambulance User and Connecting Care User PDF in portrait display default Excel tables only LHD s user has approved access to Date From Date To LHD name in alphabetical order N A N A Page 161 of 185 NG NSW Health Figure 69 LHD MAU Summary Layout LHD MAU Summary For the period 01 02 2014 to 28 02 2014 Re Avg LOS of i i Re Avg total MAU on pt eden Patients bs Zoe nase Patients kadai admission hours in ED Avg LOS in patients Separations transferred discharged g Admissions rate of MAU for all MAU MAU hrs transferrea MAU nome frommau Patients liom MAU to TOMMAU home from home from directto home patients to a ward or MAU aged 65 within 48 MAU within MAU discharges ward home hrs hrs 48 h
74. 2 2014 17 02 2014 to 23 02 2014 10 02 2014 to 16 02 2014 24 02 2014 to 02 03 2014 Patient Flow Portal Medical Assessment Unit Report Page 3 of 7 03 03 2014 to 09 03 2014 Weekly Snapshot for the Period 03 02 2014 to 27 04 2014 Average total hours in ED for all MAU Patients 17 03 2014 to 23 03 2014 31 03 2014 to 06 04 2014 14 04 2014 to 20 04 2014 10 03 2014 to 16 03 2014 24 03 2014 to 30 03 2014 07 04 2014 to 13 04 2014 21 04 2014 to 27 04 2014 Indicator Target Reports Manual Page 165 of 185 GOVERNMENT Health 10 8 LHD MAU FY Summary Table 95 LHD MAU FY Summary Overview Reports Manual LHD MAU FY Summary Provides information about Medical Assessment Units based on financial years commencing from FY08 09 for 1 or more LHD s a user has approved access to Average Total Hours in ED for all MAU Patients Average LOS in MAU Hours Average LOS of MAU Patients Transferred to a Ward Days Readmission Rates within 28 days of MAU Home or MAU ward home discharges Separations from MAU Average LOS in MAU for patient aged 65 Hours patients transferred from MAU within 48 hours patients discharged home from MAU patients discharged home from MAU within 48 hours MAU patients transferred to ward Admissions direct to MAU Re admission rate of MAU home discharges ONLY MAU NEAT The data is presented in both tabular and graphical format Trend line graphs are display
75. 24 hours Reports Manual Page 129 of 185 7 Health GOVERNMENT Format Definition Rules Calculations e Completed Time was between the first and last day of month Count of patient transfers into the selected LHD with e Urgency Urgent Specialist Care lt 24 hours e Request Transfer Time to Transfer Completed Time gt 24 hours e Completed Time was between the first and last day of month Urgency Inpatient Specialist Care 24 72 hours Sum of minutes for patient transfers into the selected LHD with e Urgency Inpatient Specialist Care 24 72 hours e Request Transfer Time to Transfer Completed Time gt 72 hours e Completed Time was between the first and last day of month OR e Urgency Future Inpatient Specialist Care 24 72 hours e Estimated Transfer Time to Transfer Completed Time gt 72 hours e Completed Time was between the first and last day of month Count of patient transfers into the selected LHD with e Urgency Inpatient Specialist Care 24 72 hours AND Request Transfer Time to Transfer Completed Time gt 72 hours e Urgency Future Inpatient Specialist Care 24 72 hours AND Estimated Transfer Time to Transfer Completed Time gt 72 hours e Completed Time was between the first and last day of month Urgency Return Transfer of Care Post Specialist Care gt 1 business day Sum of minutes for patient transfers into the selected LHD with e Urgency Retur
76. 3 04 2014 Discharge Lounge 0000984753 4149937 03 04 2014 MAU 0000060708 4150277 04 04 2014 MAU 0000111050 4150248 04 04 2014 MAU 0000237690 4150086 04 04 2014 MAU 0000293058 4147027 04 04 2014 Inpatient Ward 0000435336 4151542 04 04 2014 Inpatient Ward 0000628435 4144220 04 04 2014 Inpatient Ward 0000715621 4144893 04 04 2014 inpatient Ward 0000825402 4151959 04 04 2014 inpatient Ward 0000163185 4152737 06 04 2014 MAU 0000030690 4154352 07 04 2014 Inpatient Ward 0000130665 4155294 07 04 2014 MAU 0000324769 4149723 07 04 2014 Inpatient Ward 0000453610 4150035 07 04 2014 Inpatient Ward 0000851559 4151275 07 04 2014 Inpatient Ward 0000911452 4153481 07 04 2014 Inpatient Ward 0000927811 4150169 07 04 2014 Inpatient Ward 0000972168 4146573 07 04 2014 inpatient Ward 0000491834 4154492 08 04 2014 Inpatient Ward 0000635211 4152590 08 04 2014 Inpatient Ward 0000740232 4154690 08 04 2014 inpatient Ward 0000207504 4154554 09 04 2014 Inpatient Ward 0000305405 4152401 09 04 2014 inpatient Ward 0000490322 4157415 09 04 2014 inpatient Ward 0000553497 4155145 09 04 2014 MAU 0000717310 4159290 09 04 2014 MAU 0000740178 4158173 09 04 2014 MAU 0000757516 4152327 09 04 2014 Inpatient Ward 0000824415 4157453 09 04 2014 MAU 0000433453 4157971 10 04 2014 Inpatient Ward 0000478867 4157536 10 04 2014 Inpatient Ward r r r rv r d d d r r d r d r r r r r r r r d d r r r r d d r
77. 3 days 22 hours 29 mins 1 days 2 hours 1 mins 8 days 21 hours 9 mins 4 days 39 mins 14 days 19 hours 43 mins 2 days 1 hours 44 mins 21 hours 56 mins 15 days 23 hours 5 mins 1 days 16 hours 52 mins 23 hours 57 mins 1 days 2 hours 28 mins 1 days 1 hours 29 mins 4 days 22 hours 5 07 08 13 13 26 06 08 13 11 05 01 08 13 17 55 01 08 13 13 05 06 08 13 20 00 02 08 13 18 33 13 08 13 13 05 01 08 13 17 00 01 08 13 10 15 01 08 13 13 06 15 08 13 15 50 01 08 13 12 35 01 08 13 14 30 01 08 13 11 55 01 08 13 16 19 05 08 13 14 31 18 hours 30 mins 1 hours 40 mins 8 days 3 hours 4 mins 1hours 11 mins days 4 hours 44 mins 2 hours 25 mins 3 hours 52 mins 1 days 54 mins 3 hours 47 mins 2 hours 49 mins 5hours 25 mins 13 mins 4 hours 26 mins 5 hours 15 mins 7 hours 20 07 08 13 20 46 16 days 3 hours 49 mins mins 5 days 2 2 hours 25 mins 06 08 13 13 30 1 hours 55 01 08 13 19 50 mours 40 mins 9 days 7 mins hours 3 hours 16 01 08 13 16 21 9 days 1 hours 36 mins 06 08 13 20 00 3 hours 33 02 08 13 22 06 0 mins mins 8 days 5 hours 23 mins 4 days 7 hours 23 mins mins 14 days 23 1 hours 3 mins 13 08 13 14 08 01 08 13 16 00 01 08 13 16 18 0 mins 6 hours 3 mours 11 mins 2 days 4 hours 36 mins 2 days 4 hours 53 mins 01 08 13 16 22 15
78. 4 297 Page 175 of 185 Wis Health Figure 78 NSW Health MAU Process Trend Summary Graph Layout Patient Flow Portal Medical Assessment Unit Report Page 10 of 37 Reports Manual oh tr oe o A1 Principal referral Separations from MAU Oct 13 oh Ev A NSW Health Page 176 of 185 GOVERNMENT Health 10 12 NSW Health MAU FY Summary Table 99 NSW Health MAU FY Summary Overview Reports Manual NSW Health MAU FY Summary Provides information about Medical Assessment Units based on financial years commencing from FY08 09 for NSW Health Average Total Hours in ED for all MAU Patients Average LOS in MAU Hours Average LOS of MAU Patients Transferred to a Ward Days Readmission Rates within 28 days of MAU Home or MAU ward home discharges Separations from MAU Average LOS in MAU for patient aged 65 Hours patients transferred from MAU within 48 hours patients discharged home from MAU patients discharged home from MAU within 48 hours MAU patients transferred to ward Admissions direct to MAU Re admission rate of MAU home discharges ONLY MAU NEAT The data is presented in both tabular and graphical format Trend line graphs are displayed for the 4 performance indicators Note Readmission data is calculated based on 28 days since the patient was discharged from their previous admission where they visited a MAU As such if this rep
79. 4 10 2013 11 57 05 0211953 YAGOONA 2199 0297933875 Respiratory Other gal BANKSTOWN 2200 0297098629 Gynaecology Other or BANKSTOWN 2200 0297098629 Gynaecology Other Same specialty CHESTER HILL 2162 0296455269 Obstetrics Other 28 day re admit CHESTER HILL 2162 0296455269 Obstetrics Other Same specialty PICNIC POINT 2213 0297722099 Upper Git Other Multiple admissions GREENACRE 2190 0297858517 Ent Other 28 day re admit GREENACRE 2190 0297858517 Ent Other Same specialty BUSBY 2168 0296084051 Upper Git Other Same specialty BUSBY 2168 0296084051 Upper Git Other 28 day re admit BANKSTOWN 2200 0297902947 Cardiology Other Same specialty BANKSTOWN 2200 0297902947 Cardiology Other pl aay GREENACRE 2190 0297599425 Orthopaedics Other 28 day re admit GREENACRE 2190 0297599425 Orthopaedics Other Same specialty r r 5 z GREENACRE 2190 0296428981 Geriatrie Other ee ae ad Medicine ED SWSLHN 01 10 2013 10 40 03 10 2013 15 06 18 03 1935 GREENACRE 2190 0296428981 horned Other Same specialty Emergency Medicine Other Same specialty SWSLHN 01 10 2013 11 44 42 10 2013 10 58 03 08 1949 REVESBY 2212 0297712196 EN Other ee Medicine admissions SWSLHN 01 10 2013 12 07 01 10 2013 13 26 24 07 1986 BIRRONG d 2143 0412227715 Psychiatry Other Same specialty r SWSLHN 01 10 2013 12 07 01 10 2013 13 26 24 07 1986 BIRRONG 2143 0412227715 Psychiatry Other pose 28 day re admit ED Multiple admissions SWSLHN 01 10 2013 04 28 04 10 2013 19 43 01 03 1978 S
80. 455 44 7 49 4 52 2 Patients discharged home from MAU 45 1 58 1 54 9 55 2 55 1 Patients discharged home from MAU within 48 hrs 61 4 51 1 65 2 69 2 Admissions direct to MAU 0 7 1 7 i i 1 9 Re admission rate of MAU home discharges ONLY 8 3 MAU NEAT Reports Manual Page 167 of 185 NSW GOVERNMENT Health 10 9 NSW Health MAU Snapshot Summary Table 96 NSW Health MAU Snapshot Summary Overview Reports Manual NSW Health MAU Snapshot Summary Provides information about Medical Assessment Units based on the aggregation of data for 1 12 months 1 calendar year or 1 financial year as defined by the user e Average Total Hours in ED for all MAU Patients e Average LOS in MAU Hours e Average LOS of MAU Patients Transferred to a Ward Days e Readmission Rates within 28 days of MAU Home or MAU ward home discharges e Separations from MAU e Average LOS in MAU for patient aged 65 Hours e patients transferred from MAU within 48 hours e patients discharged home from MAU e patients discharged home from MAU within 48 hours e MAU patients transferred to ward e Admissions direct to MAU e Re admission rate of MAU home discharges ONLY e MAU NEAT The data is presented in both tabular and graphical format and summarised at state level as well comparing facilities based on peer groups The number of graphs printed will be determined by the number of different peer groups the facilities are assign
81. 49 09 10 13 15 15 04 11 13 15 43 04 11 13 16 54 04 11 13 15 45 09 09 13 13 44 04 10 13 13 22 15 11 13 10 46 29 11 13 09 23 29 11 13 15 13 Estimated Transfer Time 20 06 11 11 33 04 11 13 15 40 09 10 13 15 25 04 11 13 15 45 08 08 13 14 45 09 10 13 15 15 04 11 13 15 40 04 11 13 16 50 04 11 13 15 45 09 09 13 13 40 04 10 13 13 20 15 11 13 10 45 29 11 13 09 20 30 11 13 10 10 Isolation Req Bed Info Unknown General General General Page 87 of 185 Receiving Doctor TBA ED Staff Specialist Consultant ED Staff Specialist Consultant Naidu Damendran Nicol Stephen Crookes Michael Open Transfer Time 895 days 22 hours 27 days 18 hours 53 days 18 hours 27 days 18 hours 115 days 19 hours 53 days 18 hours 27 days 18 hours 27 days 17 hours 27 days 18 hours 83 days 20 hours 58 days 20 hours 16 days 23 hours 3 days 1 days 23 hours In Progress Requested Confirmed Requested Requested Confirmed Requested Requested Requested In Progress In Progress In Progress In Progress In Progress Transfer Note PATU R interior pubic rami dm PATU R ankle dm 04 10 no bed today at LJH KC fhjdkahfjkdhsaff PATU CRF bilateral pleural effusion IDDM dm UM GOVERNMENT Health Table 58 Patient Open Transfers by LHD Data Elements
82. 5 Wi GOVERNMENT Health Indicator Criteria Calculation amp Data Source Tables Denominator Number of patients discharged from MAU or MAU Discharge Lounge Home Data source Tables DAYS EPISODE EPISODE Limitations or Comments DAYS EPISODE table contains a record with Unit type 87 and Total hours spent Nil excluding ED Hours MAU Hours and ice i i Disch d patient patients Advice To Patients admitted ta MAU and Discharge Lounge Hours is greater than zero 86 arge patients maintain Numerator Count of stays where patient was Time period transferred to an i subsequently transferred to i of 10 patient in a MAU and inpatient ward Same facility sum inpatient ward from inpatient ward i flow this episode_length_hours gt O where the MAU A needs to be Denominator Count of stays where patient unit_type 87 lt 70 was ina MAU Data source Tables DAYS EPISODE EPISODE Numerator Number of patients stayed in Percentage of patients MAU who spent no time in ED Discharged patients patient admitted l admitted directly to MAU ward l Time period 11 directly to the MAU Nil without coming through anED Denominator Count of stays where patient Same facility sum Y to the total number of MAU was in a MAU episode_length_hours gt 0 where Patients unit_type 87 Data source Tables DAYS EPISODE EPISODE Te Emergency Department admission Patient t
83. 60 of 185 Ws GOVERNMENT Health Figure 26 Specialty Activity Snapshot Summary Layout Specialty Activity Snapshot Weekly Snapshot for the Period 30 09 2013 to 17 11 2013 Specialty ANA Anaesthesiology ASU Acute Surgery CAR Cardiology CDS Cardiac Surgery CTP Clinical Toxicology Pharmacology CTS Thoracic Surgery DEN Oral Surgery DIA Diabetes DMT Dermatology END Endocrinology ENS Endoscopy ENT Ear Nose and Throat EYE Ophthalmology GE Gastroenterology GER Geriatrics GES General Surgery GONC Gynaecology Oncology GYN Gynaecology IMM Immunology MED Medical Service NEP Nephrology NEU Neurology NIC Neonatal Intensive Care 30 09 13 to 06 10 13 INTO OUT Activity 21 10 13 to 27 10 13 INTO OUT 07 10 13 to 14 10 13 to 13 10 13 20 10 13 INTO OUT INTO OUT INTO OUT Specialty Specialty Specialty Specialty Specialty Specialty Specialty Specialty Specialty Specialty 28 10 13 to 03 11 13 04 11 13 to 11 11 13 to 10 11 13 17 11 13 INTO OUT INTO OUT Specialty Specialty Specialty Specialty 1 1 1 2 2 72 66 69 75 62 58 69 57 7 8 Table 40 Specialty Activity Snapshot Summary Data Elements Format Definition Rules Calculations Specialty Alphanumeric Specialty Description Displays the Specialty Description unless not available then the Specialty Code displays Date range for the report as def
84. 7 e Same facility Average Length of sum episode length hours gt 0 where 2 gt lt 48 hrs Patients admitted to a MAU Denominator Count of stays where patient unit_type 87 stay hours in MAU was in a MAU Comments This indicator does not Data source Tables DAYS EPISODE EPISODE differentiate between patients that were admit to MAU via ED and those admitted directly to MAU Average Length of Patients admitted to MAU and Numerator Sum episode length hours e Discharged patients 3 Stay of MAU 7 days subsequently transferred to excluding unit type in 17 58 where e Time period patients transferred inpatient ward patient was in a MAU and inpatient ward e Same facility sum to a ward days DAYS_EPISODE table contains a episode_length_hours gt 0 where Reports Manual Page 147 of 185 Wi GOVERNMENT Health Indicator Criteria Calculation amp Data Source Tables Limitations or Comments record with Unit type 87 and trans type TRA Denominator Count of stays where patient was in a MAU and inpatient ward Data source Tables DAYS EPISODE EPISODE unit type 87 Readmission Rate within 28 days of Patients with a readmission via the Emergency Department to the same hospital within 28 days of discharge from hospital to place of usual residence The initial inpatient stay contains some time in the MAU and may also contain some time in another inpatient
85. 8 61 6 Patients transferred from MAU within 48 hrs 43 7 44 0 478 49 8 50 3 Patients discharged home from MAU 24 9 29 8 34 0 37 3 Patients discharged home from MAU within 48 hrs 74 2 81 7 3 91 7 Admissions direct to MAU 0 3 2 0 27 Re admission rate of MAU home discharges ONLY 48 MAU NEAT Reports Manual Page 160 of 185 NSW GOVERNMENT Health 10 6 LHD MAU Summary Table 93 LHD MAU Summary Overview Reports Manual LHD MAU Summary Provides the following information about Medical Assessment Units based on a date period defined by the user for 1 or more LHD s a user has approved access to e Average Total Hours in ED for all MAU Patients e Average LOS in MAU Hours e Average LOS of MAU Patients Transferred to a Ward Days e Readmission Rates within 28 days of MAU Home or MAU ward home discharges e Separations from MAU e Average LOS in MAU for patient aged 65 Hours e patients transferred from MAU within 48 hours e patients discharged home from MAU e patients discharged home from MAU within 48 hours e MAU patients transferred to ward e Admissions direct to MAU e Re admission rate of MAU home discharges ONLY e MAU NEAT The data is presented in tabular format with 4 tables e Table 1 Displays data for the defined date period e Table 2 Displays data for the defined date period based on admissions or discharges from MAU between the hours of 08 00 01
86. Care Palliative Care Physiotherapist Physiotherapist Physiotherapist Physiotherapist Physiotherapist Physiotherapist Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Rehabilitation Respiratory Optional Text Awaiting another review by Palliative Care regarding anxiety and Home oxygen Await measuring and ordering of a specific hip splint Needs education for hip brace plus community support Seen by Rehab Reg needs consultant review acceptance for RNC 1 Awaiting rehab review Airborne precautions Admission Date 15 10 13 23 09 13 02 10 13 06 09 13 10 10 13 12 10 13 04 10 13 20 10 13 26 09 13 12 10 13 23 09 13 13 10 13 10 07 13 09 10 13 19 09 13 26 09 13 09 10 13 26 07 13 06 09 13 01 10 13 WFW Discharge WFW start Closed Date Date 16 10 13 16 10 13 18 10 13 04 10 13 21 10 13 10 10 13 04 10 13 10 10 13 24 10 13 14 10 13 25 10 13 25 10 13 21 11 13 16 10 13 271013 074013 22 10 13 04 10 13 23 10 13 22 10 13 16 10 13 16 10 13 16 10 13 16 10 13 04 11 13 06 08 13 171013 04 11 13 24 10 13 011013 101013 05 11 13 011013 041013 08 11 13 154043 17 10 13 081013 091013 08 10 13 011013 011013 09 10 13 04 10 13 174013 121013 04 10 13 22 10 13 23 10 13 25 10 13 22 11 13 30 10 13 08 10 13 26 10 13 20 10 13 20 10 13 16 08 13
87. Care Post Specialist Care gt 1 business day e Estimated Transfer Time to Transfer Completed Time gt 1 business day e Completed Time was between the first and last day of month Count of patient transfers out of the selected LHD with e Urgency Return Transfer of Care Post Specialist Care gt 1 business day AND Request Transfer Time to Transfer Completed Time gt 1 business day e Urgency Future Return Transfer of Care Post Specialist Care gt 1 business day AND Estimated Transfer Time to Transfer Completed Time gt 1 business day e Completed Time was between the first and last day of month Urgency Life Threatening Sum of minutes for patient transfers into the selected LHD with e Urgency Life Threatening e Request Transfer Time to Transfer Completed Time gt 4 hours e Completed Time was between the first and last day of month Count of patient transfers into the selected LHD with Avg Breached Average waiting time for patients who es e Urgency Life Threatening Wait Time hrs Hours have breached the transfer urgency f e Request Transfer Time to Transfer Completed Time gt 4 hours Transfers OUT time for Transfers IN i e Completed Time was between the first and last day of month Urgency Urgent Specialist Care lt 24 hours Sum of minutes for patient transfers into the selected LHD with e Urgency Urgent Specialist Care lt 24 hours e Request Transfer Time to Transfer Completed Time gt
88. Consults Aged Discharge date 05 08 11 Close date or Start date Discharge date 20 08 11 22 07 2011 Discharge Process AMO Discharge review Start date Close date 02 07 2011 Consults Nursing still open Close date or Start date discharge date 02 07 2011 i 12 08 2011 Diagnostics Treatment CT Close date or Start date discharge date 07 y 18 08 2011 05 07 2011 Out of Hospital Referral Respite Reports Manual Page 62 of 185 GOVERNMENT Health 5 1 Waiting for What All Reasons Table 41 Waiting for What All Reasons Overview Business Rules Reports Manual O De O O DE O O Waiting for What All Reasons Displays all Waiting for What records created for patients admitted to a specific facility Provides in depth data for further analysis of what patients are waiting for to be discharged at a specific facility Provides the capability to disaggregate data by speciality LOS AMO etc PFP All Users except Ambulance Users PDF and Excel default Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights From Date default Today To Date default Today 1st Sort Alphabetically by Primary Delay Reason 2nd Sort Alphabetically by Secondary Delay Reason 3rd Sort WFW Status Open then Closed 4th Sort WFW Total Days highes
89. Consults Rehabilitation Seen by Rehab Reg needs consultant review acceptance for RNC 1 Consults Rehabilitation 16 10 13 18 10 13 04 10 13 21 10 13 24 10 13 25 10 13 21 11 13 27 10 13 07 10 13 23 10 13 16 10 13 16 10 13 04 11 13 24 10 13 05 11 13 08 11 13 WFW LOS start Date 16 10 13 10 10 13 04 10 13 10 10 13 14 10 13 25 10 13 16 10 13 22 10 13 04 10 13 22 10 13 16 10 13 16 10 13 06 08 13 17 10 13 01 10 13 01 10 13 15 10 13 04 11 13 10 10 13 04 10 13 17 10 13 For the Period 01 10 13 to 31 10 13 Specialty Med Officer Neurosurgery F3C Geriatrics STHRPH Orthopaedics H3S Dermatology RNC2 Urology RNC2 Medical Service J3M Immunology Orthopaedics Orthopaedics Orthopaedics Orthopaedics Orthopaedics Vascular Geriatrics Rehabilitation Geriatrics Geriatrics Page 64 of 185 z GOVERNMENT Health Figure 29 Waiting for What All Reasons Layout Excel Waiting for What All Reasons Primary Delay Patient ID Reason Surname First Name Consults Consults Consults Consults Consults Consults Consults Consults Consults Consults Consults Consults Consults Consults Consults Consults Consults Consults Consults Consults Reports Manual Secondary Delay Reason Cardiology Gastroenterology Endoscopy Neurology Palliative Care Palliative
90. D or MRN Report Format PDF and Excel Rules Calculations Which value displays depends on the LHD preferences Patient Name Alphanumeric Patient s name PDF Displayed as Surname First Name Surname Alphanumeric Patient s Surname Excel N A First Name Alphanumeric Patient s First Name Excel N A Facility From Alphanumeric Facility the patient is to be transferred from PDF and Excel N A Facility To Alphanumeric Facility the patient is to be transferred to PDF and Excel N A Urgency Category Alphanumeric Urgency Category assigned to the transfer PDF and Excel If Urgency Category equals one of Life Threatening Urgent Specialist Care lt 24 hours Inpatient Specialist Care 24 72 hours Return Transfer of Care Post Specialist Care Then the given Urgency Category is displayed If Urgency Category equals Future Inpatient Specialist Care 24 72 hours then the Urgency Category displays as Inpatient Specialist Care 24 72 hours If the Urgency Category equals Future Return Transfer of Care Post Specialist Care then the Urgency Category displays as Return Transfer of Care Post Specialist Care Specialty Alphanumeric Specialty of the patient s AMO PDF and Excel Transfer Request DD MM YY Date time the transfer was System generated when the user PDF and Excel Time hh mm AM requ
91. ED Accessible Ward HITH HITH ICU ICU HDU ED Accessible Ward MHICU MHICU Reports Manual Page 45 of 185 GOVERNMENT Health Table 26 Ward Occupancy Data Elements Field Ward Code and Format Alphanumeric Definition The Ward code and Description within Rules Calculations If the ward is an ED Accessible ward this will display as Ward code Ward description ED Accessible assigned to it within the selected facility Description the selected facility Excludes wards flagged as Day Only and Designated ED Ward Group Alphanumeric The Ward Group name which has wards As defined in the Bed Management Admin module of PFP Date range for the report as defined by the user and displayed as DD MM VY if Daily Snapshot selected period Snapshot Date DD MM YY N A DD MM YY to DD MM YY if Weekly snapshot selected MMM YY if Monthly snapshot selected Count of patients in the given time period Average Average occupancy for the given time Occupancy Percentage period Count of available beds in the given time period x 100 Average occupancy per ward based on Avg By Ward Numeric the snapshots for the given reporting sum of average occupancy for snapshot Number of snapshots Reports Manual Page 46 of 185 GOVERNMENT H ea It h 3 5 Ward Patient Lists Table 27 Ward Patient Lists Overview epo e Ward Patients Lists
92. EES 14 132 RO OE D J de r re a e R a tees a raa EE A REESE EEEE EEEE 15 2 0 Facility REPOS eee 17 2 1 Clinician Defined EDD Compliance by Facility rarrrrnnnrnnrnnrnnnnnnnnnnnnrrnrnsnsnrnsnrnsnssssssssene 17 2 2 EPER 21 2 3 FA TAN ed 23 2 4 Prediction Data Extract ssip anairen ia een aes 27 2 5 USer ACCESS LIST va 31 2 0 User Access LOSING swsciccesescescsucntvescunsavexcannsden setae eqcaunevexsendedpecenteueasenseyeesecncavecvagenuecenatae y 32 3 0 Ward RPO GOE aid ania OTOR 33 3 1 Clinician Defined EDD Compliance by Ward cccccccccccccccccccececeeceeeeccecceeeceeeeeeeeeeeeeees 33 3 2 Ward ACtiVitY EEE 39 3 3 Ward Activity Snapshot iiccceaccccadscnecsadcatiaceadutcensadtan ncaa taentadiaecsadedmentadtancivaastalectadsacessaduns 42 3 4 Ward OCCUPANCY cccccccccccssessseceeeeeceeeaeeeseeeeeeeeeesauseeaeseeeeeeeeeseeeuseseeeeeeeessueaaaseeeeeeeeaaaa 45 PL 47 3 6 VANE POMC EE SEE ER 49 3 7 Ward SOU EEE EE 52 20 Specialty FT vr aja 54 4 1 LOS by Specialty and AMO Lamsepestnee teten da daa ndsekbndssande 54 4 2 Predicted Admissions via ED by Specialty rrrrrrrrrrrvrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrsrssnnnn 56 AS Specialty ACUIVINY scasssteccuncasnacdsnade a OOO 58 A A Spe cialty Activity SAPSNO Lune ai E EEEO EE 60 5 0 Waiting for What Reports iacsiciaininithanictina t1 tnnt E EErEE EEEEEEEEEEEEEEEEnnnEn EEE EEa 62 5 1 Waiting for What All Reasons ccicacccacicdeacacdasactacandentacdedentdedtenticedutinncedebebbesd
93. Ea Emergency Department 2807614 20 1211949 male Finlay PFU 49855300 49855300 26 11 13 14 20 26 11 13 12 49 26 11 13 11 40 r r r 26 11 13 09 57 5CCU Q211 Coronary Care 0369070 29 01 1947 male Adera PFU 49855300 49855300 25 11 13 20 56 r r y Inpatient specialist 755 e iia L4 Medical 2174789 06 02986 female Simons PFU 49855300 49855300 25 11 13 17 01 te 2A Tha Hospital Urgent specialist r r r care lt 24hrs Q214 Belmont Hospital ED Emergency 0441799 11 10 1940 male Pelichowski PFU 49855300 49855300 r r r Q214 Belmont Hospital ED Emergency 0162430 15 07 1926 female Wynne PFU 49855300 49855300 25 11 13 15 32 25 14 13 15 01 Urgent specialist care lt 24hrs r r HDU MBH HDU L0152071 05 06 1930 female Braude PFU 49855300 49855300 Public r r r Q214 Belmont Hospital GFNB General Medical 0034712 24 08 1949 female Thursby PFU 49855300 49855300 Chargeable Urgent specialist J225 Manning Base care lt 24hrs Hospital Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs 25 11 13 14 28 25 11 13 14 16 r r r Q214 Belmont Hospital ED Emergency 0929126 09 01 2002 male Green PFU 49855300 49855300 7 Dr Dhillon Urgent specialist Coffs Harbour Base Cathy ree ormer H208 Hospital 403611 27111963 male pes ER Naomi Laing 02 6656 7087 bee Surg 25 11 13 11 13 24 11 13 16 38 p ue vg lt 3208 oo ED J208 Emergency Department NO107524 09 08 1935 male Fone Helen McGilvray 0267219540 r r r Urgent
94. GOVERNMENT Health Field Admissions to Inpatient Ward via ED and EDSSU Format Numeric Definition Displays the number of patients admitted or transferred to an inpatient ward via the Emergency Department and then EDSSU during the defined date range at a specific facility Note If patient is admitted or transferred to EDSSU multiple times in 1 admission this is only counted once Rules Calculations Number of patients admitted based on admission date within the Emergency Department with following journey 1 Ward Emergency Department defined as a ward flagged as e Designated ED OR e Ward Type Sub Ward Type lt gt Emergency EMU EDSSU 108003 OR e Paediatrics EMU EDSSU 119007 2 Ward EDSSU designed as a ward flagged as Ward Type Sub Ward Type e Emergency EMU EDSSU 108003 e Paediatrics EMU EDSSU 119007 3 Ward Inpatient Ward defined as a ward lt gt e Designated ED OR e Ward Type Sub Ward Type lt gt Emergency EMU EDSSU 108003 OR e Paediatrics EMU EDSSU 119007 Admissions to Inpatient Ward via ED and EDSSU Percentage Displays the of patients admitted to the Inpatient Ward via ED and EDSSU as a proportion of all admissions into EDSSU Numerator Calculation from item 6 Denominator Calculation from item 5 Discharges from EDSSU via ED Number Displays the number of patients discharged
95. Jul 13 Aug 13 Sep 13 Oct 13 All Pts Target 71 Admitted Pts Non Admitted Pts NEAT Pts in ED lt 4 hours Pts Mental Health Pts Pts Excluding Mental Health Avg Pts Utilising Available Beds Pts Mental Health Pts Pts Exc Mental Health Avg Pts Utilising Available Beds 122 20 102 47 47 6 41 0 8 90 1 101 0 119 17 102 46 44 5 39 0 9 92 3 103 5 109 20 89 4 1 42 7 35 12 907 101 2 102 19 83 42 31 7 24 09 87 0 108 17 91 49 23 5 18 1 0 83 7 Estimated Date of Discharge Avg Expired EDD 92 102 107 11 4 11 1 11 6 Clinician Defined EDD demonstrates compliance with NSW MoH PD2011 015 Care Coordination Planning from Admission to Transfer of Care in NSW Public Hospitals Reports Manual Page 117 of 185 NE SW GOVERNMENT Health Figure 58 LHD Operational Summary Trend Layout page 2 Waiting for What Summary Records Waiting for What Consults Bed Days Capacity Equivalent Records Bed Days Capacity Equivalent Waiting for What Diagnostics Treatment Records Waiting for What Out of Hospital Referral Bed Days Capacity Equivalent Records Waiting for What Transfer Transport Bed Days Capacity Equivalent i Categories Capacity Equivalent Avg Pts with W4W Reason Waiting for What capture recommended to be 15 20 of all inpatients May 13 105 96
96. Rehabilitatio Hospital Private Hospital care 24 72hrs n Medicine 05 08 13 11 20 05 08 13 11 15 07 08 13 15 48 Patient discharged John Hunter Newcastle Private Inpatient specialist Rehabilitatio Hospital Hospital are 24 72hrs Medicine 06 08 13 14 43 06 08 13 14 40 07 08 13 14 10 Patient discharged John Hunter Maitland Private _ Inpatient specialist Rehabilitatio i Hospital Hospital care 24 72hrs n Medicine 06 08 13 15 00 06 08 13 14 55 09 08 13 12 17 Others Other Facility John Hunter Hunter Valley Inpatient specialist Rehabilitatio i 44 Request for transfer not Hospital Private Hospital care 24 72hrs n Medicine 00 08 13 15 30 06 08 13 15 25 07 08 13 12 11 gt ppropriate MI Overnight Cancelled John Hunter Warners Bay Inpatient specialist Rehabilitatio Patient transferred to another Hospital Private Hospital care 24 72hrs nMedicine 97 08 13 14 02 07 08 13 14 00 20 08 13 15 37 city John Hunter Inpatient specialist General Hospital Maitland Hospital preges Nona 07 08 13 15 30 07 08 13 15 25 13 08 13 12 59 Patient discharged Return Transfer of John Hunter Nelson Bay and General Hospital District Polyclinic Bisa Laat Madicina 08 08 13 13 10 09 08 13 10 00 12 08 13 13 07 Patient discharged Reports Manual Page 90 of 185 Wis GOVERNMENT Health Table 60 Patient Transfer Cancellations Data Elements PDF and Excel Field Patient ID Format Alphanumeric Definition Patient s UI
97. Repo e User Access Logins Provides a list of the number of times a user has logged into PFP during a defined date range for a specific facility Allows Hospital and LHD Executives to view the number of times users have accessed PFP Repo DEF e PFP Acce Patient Flow Manager Patient Flow Administrator LHD User Excel only Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights From Date default Today The start date for the report To Date default Today The end date for the report 1 Sort Alphabetically by Surname 2 Sort Alphabetically by First Name Ale N A Business Rule N A Table 17 User Access Logon Data Elements Definition Rules Calculations Surname of the user who logged onto Surname Alphanumeric the given facility at least once during the Excludes System Administrators specified date range First Name of the user who logged onto First Name Alphanumeric the given facility at least once during the N A specified date range Logon ID of the user who logged onto the Login Alphanumeric given facility at least once during the N A specified date range Access Level Alphanumeric PFP Access Level of the given user N A Number of times the user has logged Logins Numeric onto the facility during the specified date N A range Date of Last Login
98. WSLHN 01 10 2013 04 28 04 10 2013 19 43 01 03 1978 SWSLHN 01 10 2013 06 20 04 10 2013 19 30 06 09 1979 SWSLHN 01 10 2013 06 20 04 10 2013 19 30 06 09 1979 SWSLHN 01 10 2013 06 37 02 10 2013 17 40 10 12 1939 SWSLHN 01 10 2013 06 58 02 10 2013 10 30 30 10 1962 SWSLHN 01 10 2013 06 58 02 10 2013 10 30 30 10 1962 SWSLHN 01 10 2013 07 09 08 10 2013 13 24 29 12 1947 SWSLHN 01 10 2013 07 09 08 10 2013 13 24 29 12 1947 SWSLHN 01 10 2013 09 07 07 10 2013 18 25 12 08 1920 SWSLHN 01 10 2013 09 07 07 10 2013 18 25 12 08 1920 SWSLHN 01 10 2013 09 30 01 10 2013 10 30 04 08 1936 SWSLHN 01 10 2013 09 30 01 10 2013 10 30 04 08 1936 SWSLHN 01 10 2013 10 40 03 10 2013 15 06 18 03 1935 F F F F F M M M M M M M M F SWSLHN 01 10 2013 11 44 12 10 2013 10 58 03 08 1949 REVESBY 2212 0297712196 SWSLHN 01 10 2013 12 07 01 10 2013 13 26 24 07 1986 BIRRONG 2143 0412227715 Psychiatry Other SWSLHN 01 10 2013 13 52 02 10 2013 18 30 10 05 1940 GREENACRE 2190 0297932789 Cardiology Other SWSLHN 01 10 2013 14 47 24 10 2013 10 09 1710411925 PADSTOW 2211 0297743084 ae Other 28 day re admit SWSLHN 01 10 2013 14 47 24 10 2013 10 09 17104 1925 PADSTOW 0297743084 Geriatrie Other Medicine admissions SWSLHN 01 10 2013 14 47 24 10 2013 10 09 47 04 1925 PADSTOW 0297743084 re Other Same specialty SWSLHN 01 10 2013 15 10 07 10 2013 13 00 10 06 1936 PUNCHBOWL Cardiology Other Same specialty SWSLHN 01 10 2013 15 10 07 10 2013 13 00 10 06 1936 PUNCHBOWL Cardiolog
99. access rights From Date default Today The start date for the report based on the Admission Request date time of the patient To Date default Today The end date for the report based on the Admission Request date time of the patient Chronologically by Admission Request date time N A e A patient record is included if their admission date falls within the date range entered e Ifa patient met more than one admission risk criteria then each admission risk will display as a separate record e Patients in a ward assigned to one of the following ward type sub ward types do not display in this report Medical Dialysis OR Paediatric Dialysis OR Ambulatory Care No Subtype Page 181 of 185 7 Wis NSW Health Figure 81 Admission Risk Records Layout Admission Risk Records For the Period 01 10 2013 to 29 11 2013 Count of records 2691 Telephone Financial LHD Facility ID AUID MRN Admission Date Time Discharge Date Time Surname First Name DOB Sex Address Line 1 Address Line 2 City Postcode AMO Specialty Status Financial Description Admission Risk Number SWSLHN 01 10 2013 00 09 09 10 2013 14 00 24 0511945 YAGOONA 2199 0297968404 egen Other Same specialty SWSLHN 01 10 2013 00 09 09 10 2013 14 00 24 05 1945 YAGOONA 2199 0297968404 Geriatric Other ri Medicine admissions SWSLHN 01 10 2013 00 09 09 10 2013 14 00 24 05 1945 YAGOONA 2199 0297968404 ans Other rg aaa SWSLHN 01 10 201303 30 0
100. acilities available for selection depends on the user s access rights From Date default Today The start date for the report based on the In Progress date time for transfers OUT and Completed date time for Transfers IN To Date default Today for the report based on the In Progress date time for transfers OUT and Completed date time for Transfers IN Chronologically by date N A N A Page 75 of 185 Ws NSW Health Figure 34 IHT Hourly Performance Summary table Layout Inter Hospital Transfers Hourly Performance For the Period 03 05 2013 to 15 09 2013 Snapshot Ti Date ry Indicator 05 09 2013 Transfers IN Thursday Transfers OUT 06 09 2013 Transfers IN Friday Transfers OUT 07 09 2013 Transfers IN Saturday Transfers OUT 08 09 2013 Transfers IN Sunday Transfers OUT 09 09 2013 Transfers IN Monday Transfers OUT 10 09 2013 Transfers IN Tuesday Transfers OUT 11 09 2013 Transfers IN Wednesday Transfers OUT 12 09 2013 Transfers IN Thursday Transfers OUT 13 09 2013 Transfers IN Friday Transfers OUT 14 09 2013 Transfers IN Saturday Transfers OUT 15 09 2013 Transfers IN Sunday Transfers OUT Total IN Total OUT Figure 35 IHT Hourly Performance Graph Layout Inter Hospital Transfers Hourly Performance For the Period 03 05 2013 to 15 09 2013 Total Number of Completed Transfers IN and OUT by Snapshot Time 00 00 01 00 02 0
101. against the gt 95 target Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights Run snapshot for Day displays up to 31 days of daily data Week displays up to 12 weeks of aggregated weekly data Month displays up to 12 months of aggregated monthly data 1 Sort Alphabetically by facility 2 Sort Chronologically by Date The report will highlight per facility all days weeks of months where the value in the Avg Pts with LOS gt 24hrs amp Clinician Defined EDD cell is gt 95 compliance in the selected reporting period Excludes patients in virtual beds i e beds flagged as Well Baby On Leave or Boarder Page 17 of 185 7 Health GOVERNMENT Figure 4 Clinician Defined EDD compliance by Facility Summary table Layout Clinician Defined EDD Compliance by Facility Daily Snapshot for the Period 04 09 2013 to 19 09 2013 Facility Indicator Avg No Pts with LOS gt 24hrs 77 83 78 85 86 79 77 Avg No Pts with LOS gt 24hrs amp Clinician Defined EDD 75 78 69 63 66 66 65 Avg Pts with LOS gt 24hrs amp Clinician Defined EDD DP 94 0 885 84 4 Avg No Pts with LOS gt 24hrs 284 268 Avg No Pts with LOS gt 24hrs amp Clinician Defined EDD 221 Avg Pts with LOS gt 24hrs amp Clinician Defined EDD Avg No Pts with LOS gt 24hrs Avg No Pts with LOS gt 24hr
102. ait review Med Team and Gynae team awaiting CABG no date as yet for OT awaiting cranioplasty Awaits further surgery Stage 2 revision ongoing wound management Acute Acute Await Rheumatology review Acute awaiting improvement services can not assist untill independent with nocte care 7 84 28 38 47 32 23 8 8 199 67 39 23 29 26 46 25 11 13 12 11 13 26 11 13 26 11 13 08 11 13 06 11 13 07 11 13 22 11 13 22 11 13 24 07 13 01 10 13 07 11 13 08 11 13 08 11 13 08 11 13 14 11 13 4 7 3 3 21 23 22 7 T 128 59 22 21 21 Snapshot 29 11 13 WFW Start WEW Patient ID Patient Name Med Officer Delay Reason Optional Text LOS Dae Total EDD Specialty Days 11 12 13 08 12 13 06 12 13 12 12 13 02 12 13 29 11 13 10 12 13 26 11 13 03 12 13 24 07 13 16 12 13 30 11 13 29 11 13 16 11 13 10 12 13 15 11 13 Orthopaedics Neurosurgery Vascular Vascular Geriatrics Vascular Orthopaedics Orthopaedics Orthopaedics Rehabilitation Orthopaedics Orthopaedics Orthopaedics Immunology Orthopaedics Geriatrics Page 68 of 185 NG SW GOVERNMENT Health Figure 31 Waiting for What Current Admissions Open Reasons Layout Excel aiting for What Current Admissions Open Reasons Patient ID Surname Reports Manual First Name Reason C
103. al 4 Numeric each WFW reason of Bed Days 100 Reports Manual Page 72 of 185 GOVERNMENT Health 5 4 Waiting for What Reasons Count Table 48 Waiting for What Reasons Count Overview Reports Manual Waiting for What Reasons Count Pareto Chart of Waiting for What reasons by most frequent waits ait a specific facility To be used in conjunction with the Bed Days consumed report to identify priority areas for process redesign reduce patient delays and improve patient flow Can be used to escalate issues that cannot be fixed locally PFP All Users except Ambulance Users PDF Produces two sub reports Waiting for What reasons Count Pareto Chart A Pareto chart detailing the count of Waiting for What reasons during the specified date range including the cumulative percentage and 80 cut off Waiting for What reasons Count summary table A summary table detailing the count of Waiting for What reasons during the specified date range including the cumulative percentage and total percentage per reason Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights From Date default Today To Date default Today By count of delay reasons for each Waiting for What reason from highest to lowest until the 80 cumulative total is reached N A e WFW reason must have been open at
104. alty Description Displays the Specialty Description unless not available then the Specialty Code displays 21 Day Indicator Numeric Prediction based on the last 21 days of data for the given specialty Count of number of patients admitted to an inpatient ward via a ward flagged as Designated ED for each specialty for the last 21 days 21 Excludes where Specialty ED 5 Year Numeric Prediction based on the last 5 years of data Count of number of patients admitted to an inpatient ward via a ward flagged as Designated ED for each specialty for the last 5 years on the same number day of the week in a year 5 Excludes where Specialty ED Example of same number day of the week is 4th Thursday of the year or the 22nd Friday of the year 3 Month Numeric Prediction based on the last 3 months of data Count of number of patients admitted to an inpatient ward flagged via a ward flagged as Designated ED for each specialty for the last 3 months on a given day of the week 12 Excludes where Specialty ED Total for 3 Month Numeric Total number of predictions for the given day based on the 3 month prediction Sum value in three month indicator cell for all specialties for the given date Note Value for Total for 3 month per day may differ slightly to the value in the Predictive Tool for 3mth Indicator as the report uses an average calculation by specialty wherea
105. alue e g for Urgency Categories that use the Estimated Transfer Date this will be displayed as zero minutes Page 92 of 185 A SW GOVERNMENT Health Figure 43 Patient Transfer Times Layout PDF Patient Transfer Times From Patient se ER bnd l l Urgency Category Inpatient specialist care 24 72hrs Inpatient Specialist Care 24 72 hours Future Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Urgent specialist care lt 24hrs Specialty Rehabilitation Medicine Plastic amp Reconstructive Surgery Rehabilitation Medicine Rehabilitation Medicine General Medicine General Medicine General Medicine General Medicine Rehabilitation Medicine Rehabilitation Medicine Rehabilitation Medicine Rehabilitation Medicine General Surgery General Medicine Estimated Transfer Time 22 07 13 16 55 01 08 13 10 50 23 07 13 12 50 23 07 13 14 40 29 07 13 14 35 29 07 13 14 40 29 07 13 14 55 01 08 13 10 00 30 07 13 11 25 30 07 13 12 55 01 08 13 10 30 30 07 13
106. ame a Patient Surname must also be entered Patient Surname free text field that searches patient s first name a Patient Surname must also be entered Ward checkbox of active EPJB wards in facility Event date time in reverse chronological order None None Figure 6 EPJB Audit Log Example EPJB Audit Log Manly District Hospital Northern Sydney LHD For the Periond 28 04 14 00 00 28 04 14 23 59 Audit for lt User First Name like gt Ward Code sws A PC IP P P EE User ID User Surname User First Name IE Patient ID pie pi Event Event Date Time Description Adress Surname Name 10 192 73 202 139169 Patient View 28 04 14 10 23 10 192 73 202 451513 Patient View 28 04 14 10 23 Reports Manual Page 21 of 185 UM GOVERNMENT Health Table 9 EPJB Audit Log Data Elements Definition Displays the title of the report as EPJB Rules Calculations Title Text N A Audit Log Displays the period for which the report has data calculated for as For For the Period Date 5 N A the period dd mm yyyy hh mm dd mm yyyy hh mm Facility Name Text Displays the Facility name N A Ward Code Text Displays the PAS Ward Code N A Ward m Text Displays the PFP Ward Description N A Description User ID Text Displays the users id N A User Surname Text Displays the users surname N A User First Name Text Displays the users first na
107. ance for each ward or Ward Group against the gt 95 compliance Wards The ward s the user wants to run the report for All Wards display within the selected facility the user has access to Ward Groups The Ward Group s the user wants to run the report for Snapshot time Daily Weekly Monthly 1 Sort Alphabetically by Ward Code 2 Sort Chronologically by Date The report will highlight per Ward or Ward Group all days weeks of months where the Avg Pts with LOS gt 24hrs amp Clinician Defined EDD cell is gt 95 compliance in the selected reporting period Excludes wards flagged as Designated ED and Day Only also excludes them from the Ward Group calculations Excludes patients in virtual beds i e beds flagged as Well Baby On Leave or Boarder Page 33 of 185 UN GOVERNMENT Health Figure 10 Clinician Defined EDD Compliance by Ward Summary table Layout Clinician Defined EDD Compliance by Ward Daily Snapshot for the Period 22 11 2013 to 28 11 2013 Avg Pts with LOS gt 24hrs amp Clinician Defined EDD by Wards 22 11 13 23 11 13 24 11 13 25 11 13 26 11 13 27 11 13 28 11 13 Ward Code and Description ASU ASU Acute stroke a 69 2 82 0 87 3 ETW ETW East Wing MH 89 2 85 0 843 85 0 89 9 88 9 arven ICU ICU 137 163 192 18 0 232 247 30 8 MAT MAT 0 0 0 0 0 0 0 0 00 0 0 0 0 NUR NUR 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ORT moans ss 32 83 mem SCN SC Nursery 0
108. anual Page 121 of 185 UM GOVERNMENT Health Format Definition Rules Calculations If lt 95 cell is highlighted in red If gt 95 cell is highlighted in green Average of patients whose EDD has Count of patients within an LHD with an Expired EDD excludes patients in wards flagged as Day Only Avg Expired Percentage expired regardless of whether it was OR Designated ED and beds flagged as Boarder leave or Well Baby and LOS lt 24hrs Count of EDD g Clinician Defined for a specific LHD patients within a LHD excludes patients in wards flagged as Day Only OR Designated ED and beds flagged as Boarder leave or Well Baby and LOS lt 24hrs x 100 Waiting for Title for data about W4W Delay What Summary Text Reasons N A Total number of open W4W reasons Count of total number of W4W reasons open at some time between the first and last day of the Records Numeric i during the given month month Count of beds days consumed for all W4W reasons that were open at some time between the first and last day of the month Displays the number of bed days Count of bed days for all W4W reasons Number of days from W4W Start Date to one of the Bed Days Numeric consumed for all open W4W delay following dates whichever occurs first reasons for all categories e Discharge Date for the patient s admission e WAW reason Closed Date e No date as WFW reason is still open Percentage eee e
109. ased on financial year as selected by user e Upto 12 months of aggregated data based on calendar year as selected by user Allows MoH and LHD Executives to monitor the operations of their LHD s and potentially identify areas of improvement PFP and EDWARD for NEAT LHD User and MoH User PDF only LHD The LHD s the user wants to run the report for LHDs available for selection depends on the user s access rights Snapshot Month Calendar Year Financial Year Alphabetically by LHD W4W 1 Sort Alphabetically by W4W Category 2 Sort By W4W reason bed days highest to lowest N A N A Page 133 of 185 7 Wi NSW Health Figure 60 LHD Operational Summary Layout page 1 LHD Operational Summary For Period 01 10 2013 to 31 10 2013 NEAT Estimated Date of Pts in ED lt 4 hours Discharge Pts Excluding Mental Health Mental Health Pts Pts Excluding Mental Health D 110 4 48 25 Clinician Defined EDD demonstrates compliance with NSW MoH PD2011 015 Care Coordination Planning from Admission to Transfer of Care in NSW Public Hospitals 4 1 0 86 1 Waiting for What Summary Consults Diagnostics Treatment 133 334 Discharge Process 45 46 02 Out of Hospital Referral 153 766 26 Transfer Transport 1312 rorat Se EEE EEE Waiting for What capture recommended to be 15 20 of all inpatients Inter LHD Transfer Summary 2 gt gt sn T
110. atients IN OUT For the Period 01 11 13 to 29 11 13 Excludes incomplete transfers Transfer In Transfer Out Specialty Urgency Category Specialty Urgency Category Patients OUT 5 Retum Transfer of Care Post Specialist 1 Urgent specialist care lt 24hrs Care Cardiology Medical Urgent specialist care lt 24hrs 11 Cardiology Medical 3 Urgent specialist care lt 24hrs Inpatient specialist care 24 72hrs 3 Cardi Prinsdal Burns Inpatient specialist care 24 72hrs Urgent specialist care lt 24hrs 10 Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Cardiothoracic Surgery Urgent specialist care lt 24hrs Ear Nose amp Throat Surgery Inpatient specialist care 24 72hrs Facio maxillary Surgery Gastroenterology Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Cardiology Procedural Urgent specialist care lt 24hrs Inpatient specialist care 24 72hrs Cardiothoracic Surgery Inpatient specialist care 24 72hrs Dermatology Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Ear Nose amp Throat Surgery Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs General Medicine Return Transfer of Care Post Specialist Emergency Urgent specialist care lt 24hrs Gas Facio maxillary Surgery Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs General Surgery Urgent specialist care lt 24hrs Inpatient specialist care 24 72hrs Gastroe
111. atory 10 11 13 15 13 21 11 20 rws 9 9 Pwi Paediatric 12 11 13 17 10 B yrs 7 7 Chargeable Immunology 22 H1 JHH 24 H1 JHH Reports Manual Page 47 of 185 UM GOVERNMENT Health Table 28 Ward Patient Lists Data Elements Definition Rules Calculations Ward Profile Table Displays a summary of the ward profile Capacity X Y Open X Y Available X Y Unavailable X Y Surge X Y Closed X Y Where X Number of patients occupying beds of the given status Y Number of beds of the given status Ward Code and Description Alphanumeric The Ward code and Description within the selected facility Only displays as a column on the report if Ward Group has been selected ED Accessible Alphanumeric Indicates whether the ward is ED Accessible or not Only displays when Ward Groups is selected and displays a Y if the ward is ED Accessible or an N if the ward is not ED Accessible Bed Alphanumeric Number of the bed the patient is in N A Patient ID Alphanumeric Patient s UID or MRN depending on the LHD N A Patient Name Alphanumeric Patient s name Displays as Surname First Name Displays on PDF only Surname Alphanumeric Patients Surname Displays on Excel only First Name Alphanumeric Patient s First Name Displays on Excel only Gender Alphanumeric Patient s Gender Displays as M Male F Female
112. available for selection depends on the user s access rights From Date default Today The start date for the report based on the Completed date time of the transfer To Date default Today The end date for the report based on the Completed date time of the transfer Urgency Category within outside time graph Urgency Category Urgency Category summary table Urgency Category Transfers from to facility within outside time graph Alphabetically by facility Transfers from to facility within outside time summary table Alphabetically by facility N A A transfer must have a status of Completed to be included on the report Page 96 of 185 Health GOVERNMENT Figure 45 Patient Transfer Times Graph Urgency Category Within Outside Time Graph Layout Patient Transfer Times Graph For the Period 01 09 13 to 31 10 13 Excludes incomplete transfers Transfers EE Within time E Outside time Total OUT Urgent specialist care lt 24hrs Return Transfer of Care Post Specialist Care Life Threatening lt 4hrs Inpatient specialist care 24 72hrs Urgency Table 64 Patient Transfer Times Graph Urgency Category Within Outside Time Graph Data Elements Format Definition Transfers OUT and IN Count of completed transfers out or into the facility that are within and outside their expiration period for each urgency category Urgency Category Duration to Expire
113. ay of month Breached Transfers IN Number Number of completed patient transfers into the given LHD that breached the recommended urgency category timeframe between the first and last day of the month Urgency Life Threatening Count of completed inter LHD patient transfers into the selected LHD with e Urgency Life Threatening e Request Transfer Time to Transfer Completed Time gt 4 hours e Completed Time was between the first and last day of month Urgency Urgent Specialist Care lt 24 hours Count of completed inter LHD patient transfers into the selected LHD with e Urgency Urgent Specialist Care lt 24 hours e Request Transfer Time to Transfer Completed Time gt 24 hours e Completed Time was between the first and last day of month Urgency Inpatient Specialist Care 24 72 hours Count of completed inter LHD patient transfers into the selected LHD with e Urgency Inpatient Specialist Care 24 72 hours e Request Transfer Time to Transfer Completed Time gt 72 hours Reports Manual Page 124 of 185 7 Health GOVERNMENT Format Definition Rules Calculations e Completed Time was between the first and last day of month OR e Urgency Future Inpatient Specialist Care 24 72 hours e Estimated Transfer Time to Transfer Completed Time gt 72 hours e Completed Time was between the first and last day of month Urgency Return Transfer of Care Post Speciali
114. ays Bed Days Used Pareto Chart Data Elements Definition Rules Calculations os sgh An will display at the side of a WFW X Axis Waiting f r Alphanumeric Displays the name of the WFW reasons reason if it has become inactive during the Me specified reporting period Difference between earliest of WFW mete enean aed VANNENE asd date Discharge de or Date y P P B TangER To and latest of WFW Start date and range reason Date From Percentage of the total number of bed Y Axis right Numeric days delayed that cumulatively makes Cumulative up 80 of the total number of bed days delayed N A Table 47 Waiting for What Bed Days Bed Days Used Summary Table Data Elements Definition Rules Calculations Displays the name of the Waiting for An will display at the side of a WFW Reasons Alphanumeric What Category Waiting for What reason if it has become inactive during the Reason specified reporting period Difference between earliest of WFW Closed date Discharge date or Date To and latest of WFW Start date and Date From Number of beds days during the Numeric specified date range lost due to the WFW reason WFW Bed Days within range A cumulative of bed days delayed per LG Cumulative Numeric WFW reason N A i Percentage of bed days delayed for WFW Bed Days per reason Total number 9 Tot
115. been Transfers IN Numeric admitted or transferred into the Ward Count of patients admitted or transferred Ward Type and Ward Group for the into the Ward Ward Group or Ward Type defined date range ne number af patientsthat naye been Count of patients discharged or transferred discharged or transferred out of the Transfers OUT Numeric out of the Ward Ward Group or Ward Ward Ward Type and Ward Group for Type the defined date range ype fT Danin sum ofthe number of Transfer Nan TOTAL Numeric Transfer OUT of the given Ward Ward Group or Ward Type Reports Manual Page 41 of 185 NSW GOVERNMENT Health 3 3 Ward Activity Snapshot Table 23 Ward Activity Snapshot Overview pO D O ele ote DF O A ele O D repo o omp o O O o o O Orq Reports Manual Ward Activity Snapshot Provides summarised count of patient activity for each ward ward type and ward group within a facility based on a daily weekly or monthly snapshot Allows Patient Flow Managers Clinical Managers Nurse Unit Mangers and Hospital Executives to monitor activity at a ward level to better understand and plan for future activity PFP All Users except Ambulance User PDF only Produces three sub reports Ward Activity A breakdown of patient activity by each ward displays for ALL wards at the selected facility or facilities Ward Group Activity A breakdown of patient activity by each Ward Group displays f
116. ber of TranistersIN Sum of ALL Transfers IN for the given hour Total IN Numeric for the given hour for the report date for date range entered range Displays Total number of Transfers OUT Total OUT Numeric for the given hour for the report date SURO Oo AR sep range for date range entered Table 53 IHT Hourly Performance Graph Data Elements Field Format Definition Rules Calculations The number of patients transferred into Fum of al caimpleted transfers IN forthe i Number E reporting period for each snapshot hour Y Axis or out of a facility for the given hour for Integer Sum of all completed transfers OUT for the the report date range P reporting period for each snapshot hour X Axis hh mm The snapshot time N A Plot Area Columns a as a two dimensional column N A Reports Manual Page 77 of 185 Health GOVERNMENT 6 2 Inter Hospital Transfer Records Table 54 Inter Hospital Transfer Records Overview eyo De O o pO D O A ele O po Pro 0 o O O o O Oraq Inter Hospital Transfer Records Excel file of Inter Hospital Transfer records within a user defined date range for a specific facility Analyse the data to better understand trends and patterns for a facility s demand PFP All users excludes Ambulance Users Excel only Facilities The facility or facilities the user wants to run the report for Facilities available for
117. bstetrics No Subtype Birthing Suite Nursery JHH BNURS Obstetrics No Subtype Cardiac Catheter RNCCATH Medical Cardiology Cardiac Intensive Care Unit CICU Intensive Care Cardiothoracic Critical Care AM Bed Meeting 3rd Group General inpatient wards AM Bed Meeting 1st Group Delivery Suite Post natal Coronary Care Unit CCU Medical Cardiology Delivery Suite JHH DSUITE Obstetrics No Subtype Delivery Suite Nursery DNURS Obstetrics No Subtype Dialysis K1CDX Medical Dialysis Emergency Department JHH es Emergency No Subtype Emergency PAEDEMER Emergency Paediatrics G Y Emergency No Subtype Emergency Emergency Short Stay Unit ESSU Y Emergency EMU EDSSU AM Bed Meeting 2nd Group Endoscopy RNCEND Medical No Subtype AM Bed Meeting 3rd Group F1 Orthopaedic F1 Surgery Orthopaedics General inpatient wards Surgery AM Bed Meeting 3rd Group F2 Respiratory Immunology Medical Respiratory General inpatient wards Medicine AM Bed Meeting 3rd Group F3 Cardiac Surgery Vascular Surgery Cadiothoracic General inpatient wards Surgery AM Bed Meeting 3rd Group G1 General Surgery Surgery General General inpatient wards Surgery AM Bed Meeting 3rd Group G2 Neurosciences Medical Neurology General inpatient wards Surgery Reports Manual Page 52 of 185 Health GOVERNMENT Table 32 Ward Setup Data Elements Field Format Definition Rules Calculations Ward description Alphanumeric Ward Des
118. c P created Transfers tab e PFP List Views the transfer was initiated from the Patient List view Created Requested i Request accepted Confirmed Status Alphanumeric Current status of the transfer q P Patient Sent In Progress Patient Arrived Completed Reports Manual Page 81 of 185 Health GOVERNMENT Field Format Definition Rules Calculations F Login name of the user who Entered by A phanumene entered the transfer N A i hol Last updated by Alphanumeric Login name of the user who last N A edited the transfer details Count of Records Numeric Number of inter hospital transfer records in the specified date range Count of records in the reporting period Reports Manual Page 82 of 185 Health GOVERNMENT 6 3 Patient Open Transfers Table 55 Patient Open Transfers Overview Patient Open Transfers Report that provides information on all outgoing and incoming open transfers within a specific facility Can be used as a contemporary carry around list of expected transfers at meetings and for hospital reporting PFP All users except Ambulance Users Current Facility Snapshot PDF and Excel default Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights PDF Chronologically by Transfer Requ
119. ce Comparison Graph Layout Clinician Defined EDD Compliance by Ward Daily Snapshot for the Period 22 11 2013 to 28 11 2013 Avg Pts with LOS gt 24hrs amp Clinician Defined EDD by Wards 0 Fri 22 11 13 Sat 23 11 13 Sun 24 11 13 Mon 25 11 13 Tue 26 11 13 Wed 27 11 13 Thu 28 11 13 ASU ASU Acute stroke e CU ICU NUR NUR OS OS theatres PGU PGU SW4 SW4 surgical TU TU Transit Unit ETW ETW East Wing MH MAT MAT ORT orthopaedics e PECC PECC SCN SC Nursery SW5 SW5 Reports Manual Page 36 of 185 Wi NSW Health Figure 12 Clinician Defined EDD Compliance by Ward Individual ward gt 95 Compliance Graph Layout Clinician Defined EDD Compliance by Ward Daily Snapshot for the Period 22 11 2013 to 28 11 2013 Avg Pts with LOS gt 24hrs amp Clinician Defined EDD by Wards 0 Fri 22 11 13 Sat 23 11 13 Sun 24 11 13 95 Target T Mon 25 1 1 13 Tue 26 11 13 Wed 27 11 13 Thu 28 11 13 ASU ASU Acute stroke Reports Manual Page 37 of 185 7 Health GOVERNMENT Table 20 Clinician Defined EDD Compliance by Ward Graphs Data Elements Rules Calculations Format Definition Dates within the reporting period in Graph displays differently depending on whether a daily weekly or monthly snapshot is selected e Daily Up to 31 days of daily snapshots per graph Displays date NN Date chronological orde
120. closed beds in a ward based on the Ward Profile Schedule setup in PFP e Number of patients occupying available open surge unavailable and closed beds in a ward e Number of patients over capacity in a ward e ED Accessible Bed Occupancy or Total Occupancy depending on whether the ward is ED Accessible Allows Patient Flow Managers Clinical Managers and Hospital Executives to monitor hospital activity to understand the current situation and plan for future activity PFP All Users except Ambulance User PDF default and Excel Wards The ward s the user wants to run the report for All Wards display within the selected facility the user has access to From Date default Today The start date for the report To Date default Today The end date for the report 1 Sort Alphabetically by Ward Code 2 Sort Chronologically by Date N A N A Page 49 of 185 7 4 gt Health GOVERNMENT Figure 21 Ward Profile Layout Ward Profile For the Period 10 11 2013 to 19 11 2013 MATUNIT Maternity Unit ED Accessible Snapshot Time Date Day Indicator Avg 00 00 01 00 02 00 03 00 04 00 05 00 06 00 07 00 08 00 09 00 10 00 11 00 12 00 13 00 14 00 15 00 16 00 17 00 18 00 19 00 20 00 21 00 22 00 23 00 Total Capacity Beds 25 25 25 5 25 25 5 5 25 25 5 25 25 25 25 25 25 25 25 25 25 25 25 25 Total of Patients 13 13 13 13 13 13
121. cription N A Ward code Alphanumeric Ward Code N A Total Beds Numeric Displays the total capacity of the ward aum of Available Undueldale Suge Closed ED Accessible Ward Alphanumeric Identifies whether the ward is flagged as ED Accessible with a Y Sourced from Bed Management Admin in PFP Day Only Ward Alphanumeric Identifies whether the ward is flagged as Day Only with a Y Sourced from Bed Management Admin in PFP Designated ED Alphanumeric Identifies whether the ward is flagged as Designated ED with a Y Sourced from Bed Management Admin in PFP Ward Type Alphanumeric Ward Type and Sub Ward Type assigned to the ward Sourced from Bed Management Admin in PFP Ward Group Alphanumeric Ward Groups assigned to the ward Sourced from Bed Management Admin in PFP Reports Manual Page 53 of 185 NSW GOVERNMENT Health 4 0 SPECIALTY REPORTS 4 1 LOS by Specialty and AMO Table 33 LOS by Specialty and AMO Overview LOS by Specialty and AMO Provides an overview of LOS for each Specialty and AMO within a facility at the Now date time LOS is displayed as e O 4days e 5 9 days e 10 14 days e 15 19 days e 20 49 days e 50 99 days e 99 days Allows Patient Flow Managers Clinical Managers Nurse Unit Mangers Medical Officers and Hospital Executives to review current inpatient LOS data as of the Car
122. d by a patient at 7am in ED accessible wards Unstaffed beds in use Numeric Number of beds open and unstaffed at 7am excluding Day Only units Reports Manual Page 29 of 185 Health GOVERNMENT Field Yesterday s Admissions still in ED Flow Indicators National Emergency Format Numeric Definition Number of yesterdays admitted patients i e AMO specialty lt gt emergency in the ED at 7am National Emergency Access Target of four hours for all patients treated in the Emergency For What Reasons A T t 4 P t cess Target oe Department Manual entry hour ED ibl d i z accessible Percentage Daily Occupancy rate of overnight ED accessible beds occupancy Patients over 9 days Numeric Number of patients with a LOS greater than 9 days Patients with ACCR Numeric Count of patients with an open Waiting for What WFW reason that have an Aged Care waiting placement Client Record ACCR completed and are medically ready waiting for placement Patient iting ACCR 3 d 3 Se MANE Numeric Count of patients with an open WFW reason who are awaiting an ACCR review Patients accepted for Count of patients with an open WFW reason who are admitted patients accepted for a Numeric vitae vA Per rehab waiting a Bed rehabilitation waiting for transfer to a rehabilitation ward hospital Patients waiting Numeric Count of patients with an open WFW reason who are waiting for a r
123. data based on a calendar month The user can select to extract up to 12 calendar months of data prior to a selected month Run snapshot per financial year Only applicable to Executive reports Extracts aggregated retrospective data for a financial year Run snapshot per calendar year Only applicable to Executive reports Extracts aggregated retrospective data for a calendar year Format Generating report either as PDF or Excel with default dependent on the selected report Some reports cannot be downloaded in both formats Reports Manual Page 14 of 185 GOVERNMENT H ea It h 1 3 2 Report Data Each report provides the user with the ability to view data in following manner e Current Snapshot Displays data based on the status of the facility ward or LHD at the time the report is generated e Date Range Displays data based on date from and date to range customised by the user e Historical Snapshot Displays retrospective data based on 1 or more calendar days calendar weeks or calendar months Executive reports can also be viewed based on 1 calendar year or financial year The reports associated with each of the above data categories are defined in Table 4 Table 4 Report Data Categories Report Data Category Reports e Facility MAU FY Summary LHD MAU FY Summary LOS by Specialty and AMO e NSW Health MAU FY Summary e Patient Open Inter Ward Transfers e Patient Open Tran
124. dionlansatartadidtanne 107 7 3 Patient Open Inter Ward Transfers ccccccccccccscccccccccccccccccceccceccecccccceceseeeseeeeeseseeeees 111 8 0 Transfers DAR Pee AER a 114 8 1 Direct Ward Admission RecordS sssssesssseesssssssersrerrssssserrrtrrressssserrrerrensssetrrreeresssseet 114 OO EXECULIVE er oa EE 117 9 1 LHD Operational Summary TrendJ rerrrararnnnnrrrvrnvrrnrnrnnnnnrrrnnnenssrnrrnnnnnnsnnnessssssnnnnnnn 117 9 2 Facility Operational Summary Trend ssadiscisesvessvandoseiancvanvvandvaeuandectensalaelancievantoanie 132 9 3 LHD Operational SUMMary siatiscsaiiceadcasadenecadiinadsntdduaddetacuadeadhiuaesaadinadsaadiuaddaeavnceaeaounans 133 9 4 Facility Operational Summary cccccccccccccccecccccceecceeccececcecececeecccecceeeseceeeceseeeeeeeeeeeess 136 9 5 Whole of Hospital Snapshot rrrrnnnrrnnnrrnnnnnnnnnnrrnnnrrnnnnnnnnnnrnnnnnrnnnnnsnnnnsrnnnnrnnnnnsnnnee 137 9 6 Facility Whole of Hospital Snapshot Lusvaaavamumaasmdsssansiienddnnnuiekkv 146 10 0 Medical Assessment Unit Reports rrrvvvvvvvvvvvrvvvrvrvvvvvvrvrrrrrsssrsrssrsssssersrsssssssssssssssssssnnr 147 10 1 Medical Assessment Unit Indicator Calculations sorrnnnnnnnnnnnnnnnvrrnnnnnnnnnvnnnnnvrrnnnnne 147 10 2 Facility MAU Re admissions uaugsamemmmmum je 152 10 3 Facility MAU SUMMATY aars edeoatenedewitbnedevadiuntevetbeeddontenedivan 154 10 4 Facility MAU Snapshot SUMMary viccrcscceaninceemmoicemeeninnnieentmenemmicemmnmmoleentd 156 10 5 Facility
125. directly from EDSSU via the Emergency Department i e patient s last ward during the admission was EDSSU Number of patients discharged based on discharged date where first ward Emergency Department defined as a ward flagged as Designated ED and Ward Type Sub Ward Type lt gt e Emergency EMU EDSSU 108003 e Paediatrics EMU EDSSU 119007 AND Last ward in admission is EDSSU defined as Ward Type Sub Ward Type e Emergency EMU EDSSU 108003 e Paediatrics EMU EDSSU 119007 Reports Manual Page 140 of 185 UM GOVERNMENT H ea It h Field Format Definition Rules Calculations Percentage of Numerator Discharges from EDSSU Displays the percentage of patients via ED discharges from N i i ore Percentage discharged directly from EDSSU via the e Emergency EMU EDSSU a Emergency Department i e patient s 108003 last ward during the admission was e Paediatrics EMU EDSSU EDSSU 119007 Denominator Discharges from EDSSU Numerator Number of patients with length of stay lt 1440 minutes in EDSSU wards defined as Ward Type Pts with LOS in Displays the of patients who had a SUb Wara TYRA e Emergency EMU EDSSU EDSSU lt 24 Percentage LOS in EDSSU lt 24 hours as a 108003 hours proportion of all admissions to EDSSU Paediatrics EMU EDSSU 119007 Denominator Calculation from item 5 Admissions to EMU Number
126. e Coordination process PFP All Users except Ambulance Users PDF Default and Excel Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights 1 Sort Alphabetically by Specialty 2 Sort Alphabetically by AMO Surname N A N A Reports Manual Page 54 of 185 UM GOVERNMENT Health Figure 23 LOS by Specialty and AMO Layout LOS by Specialty and AMO Snapshot 19 11 13 13 32 No Patients by LOS EE AD EET ET EE atients 10 14 days 15 19 days 20 49 days 50 99 days 1 0 1 0 0 0 o 0 o Acute Surgery Cardiac Surgery Cardiology Dermatology Ear Nose and Throat Emergency Medicine 1 16 20 17 19 20 67 46 92 1 101 0 13 8 9 2 1 34 0 1 4 3 0 22 38 so 00 828o0omM0o amp 4n 00000848 o noS o N N BW www gt no nu oo Table 34 LOS by Specialty and AMO Data Elements Format Definition eolo oob COB ooo Wolo oR oN a Bo me o o o o ee Oo Fee oo oo 1 0 0 oc Oo oo o B o eee CUO o o o o i o B o o o o fi o Mee oc C o oo 0 0 C o i o o o o o Rules Calculations Specialty in the facility that currently has Displays the Specialty Description unless Specialty Alphanumeric ie not available then the Specialty Code patients admitted into it displays Name of the AMO
127. e Neralee 55310 Public r 21 11 13 09 45 18 07 1931 male Neralee 55310 Public 21 11 13 09 43 21 11 13 09 43 Intensive Care Unit H3 Surgery Trauma H3S H3 Surgery Trauma 17112 1980 male Neralee 55310 Public Intensive Care Unit H3 Surgery Trauma H3S H3 Surgery Trauma 23 04 1947 male Neralee 55310 Public 03 08 1946 male Neralee 58310 Public 19 12 1946 female Neralee 55310 Public Intensive Care Unit G1 General Surgery CCU Coronary Care Unit 14 07 1931 female Neralee 55310 Public Intensive Care Unit H3 Surgery Trauma H3S H3 Surgery Trauma 11 05 1931 male Neralee 55310 DVA Intensive Care Unit H3 Surgery Trauma F1 F1 Orthopaedic 11 05 1931 male Neralee 55310 DVA 26 03 1964 male Neralee 55310 Public 23 11 1947 male Neralee 55310 Public 21 11 13 09 42 21 11 13 09 41 21 11 13 09 41 20 11 13 14 49 19 11 13 15 26 19 11 13 12 11 19 11 13 08 50 19 11 13 08 50 19 11 13 08 49 Intensive Care Unit Coronary Care Unit 22 10 1946 male Neralee 55310 Chargeable 19 11 13 08 49 Intensive Care Unit H3 Surgery Trauma 04 11 1956 male Neralee 55310 Public 19 11 13 08 48 Intensive Care Unit G2 Neurosciences 29 11 1943 female Neralee 55310 Chargeable r 18 11 13 15 07 Intensive Care Unit Delivery Suite JHH 27 06 1979 female Neralee 55310 Public r Intensive Care Unit H3 Surgery Trauma 21 12 1981 male Neralee 55310 Public 18 11 13 11 35 18 11 13 11 34 18 11 13 10 17 Reports Manual Page 105 of 185 Wi GOVERNMENT Health Table
128. e OandGfloater Clinic Periop Periop Unit 04000 Gynaecology Unknown 20 11 13 11 28 20 11 13 23 26 19 11 13 12 40 01 01 2010 male Home Paediatric Unit Paediatric Unit 14150 Paediatrics MRI Brain under GA Autism 19 11 13 12 41 22 11 13 13 05 19 11 13 11 11 01 01 1999 female Home Periop Periop Unit 04000 Gynaecology for D C Day only 19 11 13 14 12 20 11 13 12 25 19 11 13 10 31 01 01 1999 female Home Periop Periop Unit 04000 Gynaecology for D C day only 19 11 13 10 32 19 11 13 11 10 Admit for cardicac echo ftoe and Gastrointestinal work up prior to R hemicolectomy on Surgery Thurs 21 11 13 19 11 13 bed available 2pm Ward B Decreased weight gain for investigation Respiratory Review and Oxygen saturation monitoring missed miscarriage requires cervagem Jehovah Witness no blood transfusion 18 11 13 13 40 20 02 1922 Surgical B 18 11 13 13 41 19 11 13 19 18 18 11 13 09 24 09 10 2012 Paediatric Unit Paediatric Unit Paediatrics 18 11 13 09 24 18 11 13 13 43 18 11 13 09 22 28 12 1997 Paediatric Unit Paediatric Unit Paediatrics 18 11 13 09 23 18 11 13 13 43 18 11 13 09 14 16 01 1980 female OandGfloater Clinic Periop Periop Unit Gynaecology 18 11 13 09 15 18 11 13 13 44 15 11 13 09 50 01 01 1999 female Home Periop Periop Unit To peri op for D C 15 11 13 09 51 19 11 13 07 31 13 11 13 20 33 27 04 1965 male i Home BSURG Surgical B General Surgery i d perianal abcess admitted O N 13 11 13 20 33 14 11 13 06 27 13 11 13 20 32 13 02 1987 male i Hom
129. e Periop Periop Unit General Surgery i d of thigh abcess 13 11 13 20 32 14 11 13 08 40 13 11 13 17 04 26 10 2010 male Home Paediatric Unit Paediatric Unit Paediatrics MRI Brain under GA 13 11 13 17 05 15 11 13 09 51 Orthopaedic 10 11 13 14 57 04 08 2001 male Switch Home Periop Periop Unit Surgery For Closed Reduction wrist day only No 10 11 13 14 58 11 11 13 08 09 cervical cercalage HIO TPL 21 40 delivered 27 40 missed miscarriage cervagem required Orthopaedic For removal of K Wires will require Surgery OIN bed cervagem Anembryonic pregnancy 08 11 13 11 13 06 08 1990 female OQand Gfloater Home Periop Periop Unit Gynaecology Unknown 08 14 13 11 14 12 11 13 10 48 07 11 13 10 22 14 02 1986 female QandGfloater Clinic Periop Periop Unit Gynaecology Unknown 07 11 13 10 22 10 11 13 14 54 06 11 13 16 45 12 07 2000 female Home Periop Periop Unit 06 11 13 16 46 10 11 13 14 54 06 11 13 09 22 03 09 1990 female OandG floater Home Periop Periop Unit Gynaecology 06 11 13 09 22 13 11 13 13 53 Reports Manual Page 115 of 185 UM GOVERNMENT Health Table 78 Direct Ward Admission Records Data Elements Field Format Definition Rules Calculations Date Time DD MM YYYY Date time the Direct Ward Admission N A Entered hh mm request was created Surname Alphanumeric Patient s Surname N A First Name Alphanumeric Patient s First Name N A Patient ID Alphanumeric Pati
130. e report is assigned to Clicking on the Report Group header displays the list of reports available to the user based on their access level single clicking again on the Report Group header will close the list of reports Figure 3 Selecting a report gt PatientFlowPortal Test environment porting Central Coast x Gosford Hospital x Select Hospital Data Feed Schedules a Facility Reports EDD Compliance by Facility Hospital Occupancy Prediction Data Extract User Access List UserAccess Logins Ward Reports EDD Compliance by Ward Ward Activity Ward Activity Snapshot Please select a report Ward Occupancy Ward Patient Lists Ward Profile Ward Setup Specialty Reports LOS by Specialty and AMO Predicted Adm via ED by Spec Specialty Activity Reports Manual Page 12 of 185 Health GOVERNMENT Single clicking on a report name will update the main section of the window with the prompts that can be customised by the user before generating the report The prompts will differ depending on the type of report which are detailed in Section 1 3 1 The definition and usage of the report are also defined underneath the report prompts Figure 4 Report Prompts for LOS by Specialty and AMO Report PatientFlowPortal Test environment Reporting Data Fesa C Repons 7 LOS by Specialty and AMO Mener Hospital Occupancy M Gosford Hospital C Long
131. e selected LHD with e Urgency Urgent Specialist Care lt 24 hours e Completed Time was between the first and last day of month x 100 Urgency Inpatient Specialist Care 24 72 hours Count of patient transfers into the selected LHD with e Urgency Inpatient Specialist Care 24 72 hours e Request Transfer Time to Transfer Completed Time gt 72 hours e Completed Time was between the first and last day of month OR e Urgency Future Inpatient Specialist Care 24 72 hours e Estimated Transfer Time to Transfer Completed Time gt 72 hours e Completed Time was between the first and last day of month Count of patient transfers into the selected LHD with e Urgency Inpatient Specialist Care 24 72 hours e Urgency Future Inpatient Specialist Care 24 72 hours e Completed Time was between the first and last day of month x 100 Urgency Return Transfer of Care Post Specialist Care gt 1 business day Count of patient transfers into the selected LHD with e Urgency Return Transfer of Care Post Specialist Care gt 1 business day e Request Transfer Time to Transfer Completed Time gt 1 business day e Completed Time was between the first and last day of month OR e Urgency Future Return Transfer of Care Post Specialist Care gt 1 business day e Estimated Transfer Time to Transfer Completed Time gt 1 business day e Completed Time was between the first and last day of month Count of patient transfers into the se
132. ection depends on the user s access rights From Date default Today The start date for the report based on the Completed date time of the transfer To Date default Today The end date for the report based on the Completed date time of the transfer First Name optional First Name of the patient when searching for a specific transfer Surname optional Surname of the patient when searching for a specific transfer DOB optional DOB of the patient when searching for a specific transfer Chronologically by Transfer Request date time The Req Est to Completed time will be highlighted in red text for any transfers that have exceeded the expiration period for the given Urgency Category Life Threatening gt 4 hours Urgent Specialist Care lt 24 hours gt 24 hours Inpatient Specialist Care 24 72 hours gt 72 hours Return Transfer of Care Post Specialist Care gt 1 Business Day Future Inpatient Specialist Care 24 72 gt 72 hours based on Estimated hours Transfer Date Time Future Return Transfer of Care Post gt 1 Business Day based on Specialist Care Estimated Transfer Date Time e Atransfer must have a status of Completed to be included in the report e If atransfer status e g Confirmed does not have a date time recorded any calculations that utilise these date times will be calculated as null e Ifa calculation results in a negative v
133. ed EDD s e Waiting for What Delay Reasons e Inter LHD Patient Transfers The report will display up to 12 months of trend data as selected by the user Allows MoH and LHD Executives to monitor the operations of their LHD s and potentially identify areas of improvement PFP and EDWARD for NEAT LHD User and MoH User PDF only Facilities The facilities the user wants to run the report for Facilities available for selection depends on the user s access rights Snapshot Month Alphabetically by LHD W4W 1 Sort Alphabetically by W4W Category 2 Sort By W4W reason bed days highest to lowest N A N A Refer to 9 1 LHD Operational Summary Trend for details of the report layout and data elements Reports Manual Page 132 of 185 Health GOVERNMENT 9 3 LHD Operational Summary Table 82 LHD Operational Summary Overview Repo De O o po DF O o O eye Pro D o O O ed O Oraq Reports Manual LHD Operational Summary Provides a snapshot of operations for a specific LHD using the Patient Flow Portal by reporting information about e NEAT e LOS gt 49 Days e LOS gt 99 Days e Total Occupancy and ED Accessible Occupancy e Estimated Date of Discharge Clinician Defined and Expired EDD s e Waiting for What Delay Reasons e Inter LHD Patient Transfers The report will display either e One calendar month of data e Upto 12 months of aggregated data b
134. ed Pareto Chart A Pareto chart detailing the Waiting for What reasons that have consumed the most beds days during the specified date range including the cumulative percentage and the 80 cut off Bed Days Used summary table A summary table detailing the Waiting for What reasons that have consumed the most beds days during the specified date range including the cumulative percentage and total percentage per reason Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights From Date default Today To Date default Today By count of bed days delayed per each WFW reason from highest to lowest until the 80 cumulative total is reached N A e WFW reason must have been open at some period during the date range entered in the report prompts o WFW Start date is before the Date From and has a status of Open o WFW Start date is before the Date From and has a Close date or Discharge date after the Date To o WFW Start date is before the Date From and has a Close date or a Discharge date between the Date From and the Date To o WFW Start date is between the Date From and the Date To and has a status of Open e The Pareto Chart and Summary table displays the count of the bed days delayed for the individual WFW reasons wit
135. ed for the 4 performance indicators Note Readmission data is calculated based on 28 days since the patient was discharged from their previous admission where they visited a MAU As such if this report is generated for last 28 days prior to today the readmission data will not be up to date Can be used to obtain an overview of the operations and performance of Medical Assessment Units in a facility HIE All users except Ambulance User and Connecting Care User PDF in portrait display default Excel tables only LHD s user has approved access to Order within Results Tables and Trend Line Graphs is the time period in chronological order N A N A Page 166 of 185 NSW GOVERNMENT Health Figure 72 LHD MAU FY Summary Layout LHD MAU Financial Year Summary 2008 2009 2010 2011 2012 20131 suw Bin Indicators 2009 2010 2011 2012 2013 2014 Avg total hours in ED for all MAU patients Avg LOS in MAU hrs 50 7 62 2 55 8 55 8 50 4 46 0 Avg LOS of MAU patients transferred to a ward days 95 94 8 6 8 1 7 7 6 7 4 Re admission rates of MAU home or MAU ward home discharges 10 8 12 1 12 4 13 7 12 4 10 8 Process Indicators Separations from MAU 614 2816 3471 3463 4116 3454 Avg LOS in MAU for patients aged 65 hrs 49 9 65 6 58 0 59 0 52 5 48 2 Patients transferred from MAU to ward 53 7 42 3 46 0 46 4 442 39 2 Patients transferred from MAU within 48 hrs 47 1 43 8
136. ed to Note Readmission data is calculated based on 28 days since the patient was discharged from their previous admission where they visited a MAU As such if this report is generated for last 28 days prior to today the readmission data will not be up to date Can be used to obtain an overview of the operations and performance of Medical Assessment Units across NSW Health HIE All users except Ambulance User and Connecting Care User PDF in landscape display Number of months Between 1 12 Calendar Year commencing from 2008 Financial Year commencing from FY2008 2009 Results Table 1 sort Peer Group in alphabetical order 2 sort Facility in alphabetical order Column Graph Facilities in ascending order from left to right N A N A Page 168 of 185 Wii NSW Health Figure 73 NSW Health MAU Snapshot Summary Table Layout NSW Health MAU Snapshot Summary For the Period 01 11 2013 to 30 04 2014 NSW Health Re Re are Avg TOSIA Patients Patients Patients Patients admission Separations discharged transferred transferred discharged Admissions rate of MAU MAU home patients home from or MAU from MAU aged 65 from MAU to from MAU home from direct to home MAU within ward home hrs ward within 48 hrs MAU 48 hrs MAU acres discharges Avg LOS of Avg total MAU hours inED Avg LOS in patients for all MAU MAU hrs transferred pa
137. edicare Public O N Hosp Dr Charge Private single on call Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Charge Private shared on call Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Medicare Public O N Hosp Dr Charge Private single on call Dr Wi GOVERNMENT Health Table 42 Waiting for What All Reasons Data Elements PDF and Excel Definition PDF Excel Rules Calculations Patient ID Alphanumeric Patient s UID or MRN PDF and Excel Which value displays depends on the LHD preferences Patient s Surname Patient s Patient Name Alphanumeric First Name PDF N A Surname Alphanumeric Patient s Surname Excel N A First Name Alphanumeric Patient s First Name Excel N A If a WFW reason has become inactive Waiting for What Category during the specified reporting period the Delay R Alph sa PDF ps phanumerie an Waiting for What reason following displays underneath the reason Inactive since dd mm yy Pri Del i wes pr kar Alphanumeric Waiting for What Category Excel N A Reason If a WFW reason has become inactive Secondary Alphanumeric Waiting for What reason Excel during the specified reporting period the Delay Reason following displays underneath the reason Inactive since dd mm yy Free te
138. ehabilitation team rehab consult review Patients with MRO EE Number of admitted patients who are infected with a multi resistant organism Manual entry Inpatients waiting ER Count of patients with an open WFW reason who are waiting for surgery or a procedure in surgery procedure the Operating Theatre Patient iri 2 p a y Sheik P j SAG Numeric Number of patients requiring cardiac monitoring Manual entry cardiac monitoring Patients ready for transfer to another Numeric Number of patients ready for transfer out of your facility Outgoing IHT Facility Patient iti 4 ine s g oe on ne Numeric Number of patients awaiting transfer into the selected facility Incoming IHT transfer into Facility Patients with Waiti 7 z end AnG Numeric Number of patients with one or more open WFW reasons Reports Manual Page 30 of 185 Health GOVERNMENT 2 5 User Access List Table 14 User Access List Overview pO De O Repo po Da O A Repo O Repo Pro 0 co O O o Repo O Oraq User Access List Provides a list of users currently approved to access PFP at a specific facility To audit and update user access of approved users to PFP at a specific facility PFP Patient Flow Manager Patient Flow Administrator LHD User Excel only Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights 1 Sort Alphabe
139. en hour Excludes patients in beds flagged as Boarder Lodger or Well Baby Patients in Over N ment Number of patients in which the ward is Count of patients in ward at the snapshot Capacity over capacity time Total Capacity Avg Numeric Average of each data item for each day Sum the data item for each hour number of snapshots Reports Manual Page 51 of 185 NSW Health 3 7 Ward Setup Table 31 Ward Setup Overview Repo e Ward Setup Report De O Displays the ward setup for each ward in a facility The Ward Setup allows Patient Flow Administrators and Managers to view how the wards have been setup in their facility in terms of e Number of ED Accessible beds e Is ward ED Accessible Sepo i e Is ward Day Only e Is ward Designated ED e Ward Type Sub Ward Type assigned to the ward e Ward Groups assigned to the ward Repo DELEA PFP er Acce Patient Flow Managers Patient Flow Administrators and LHD Users only Report Forma Excel only ae cts Facilities The facility or facilities the user wants to run the report for Facilities l 3 available for selection depends on the user s access rights Report Sort Orde Alphabetically by Ward Description NE N A B ess Rule N A Figure 22 Ward Setup Layout Ward Setup Snapshot 29 11 13 11 10 dr ED Accessible Day Only Designated Ward Description Ward Code Total Beds ED Ward Ward Type Ward Groups Birthing Suite JHH BSUITE O
140. end If there are no weekends within the weekend i defined date range then no value is displayed Count of patients whose discharge date is from Monday 00 01 to Friday 23 59 within the reporting Week Day period Count of patients whose Discharge Rate Numeric Week day discharge rate as a of all discharges for a specific facility discharge date is within the reporting period x 100 If there are no weekdays within the defined date range then 0 0 is displayed Reports Manual Page 143 of 185 UM GOVERNMENT Health Field Weekend Discharge Rate Format Numeric Definition Displays the weekend discharge rate as a of all discharges for a specific facility Display to 1 decimal point Rules Calculations Count of patients whose discharge date is from Saturday 00 00 to Sunday 23 59 within the reporting period Count of patients whose discharge date is within the reporting period x 100 If there are no weekends within the defined date range then 0 0 is displayed Average ED Accessible Bed occupancy Calculation for hourly snapshot Total number of occupied beds in wards flagged as ED Accessible for the given facility excluding patients in Beds flagged as Leave Boarder and Perae ie percentage for a facility Well Baby Total number of available Accessible Bed Numeric The average is based on an hourly beds in wards flagged as ED Accessible Occ
141. enkaatenencehele 63 5 2 Waiting for What Current Admissions Open ReaSON ssccccccccessssssttseeeeeeeeeeseees 68 5 3 Waiting for What Bed Days ict dcotnnscansacriennedicaueasiae Aiea nae eaeieeade 71 5 4 Waiting for What Reasons Count i nscsicnacuianarmiinanamininninmnnnanemnanann 73 6 0 Transfers IHT REPR ccs saqcscasteheasntaandeaauaahsdensdeqdaennechuadabaendananacnateniaegdaeaehaaeuidepducaudeay 75 Reports Manual Page 3 of 185 Wis NSW Health 6 1 IHT Hourly Performance rrrnrnrnnnnnnnnnnrvnnnnrnnnnnnnnnnsrnnnnnnnnnnnnnnnsrnnnnnnnnnnnnnnsssnnnennnnnansnnnee 75 6 2 Inter Hospital Transfer Records rrnnrrrnnrrrnnnnnnnnnnrnnnnrrnnnnnnnnnnsnnnnrrnnnnnnnnnssnnnnssnnnnnsnnner 78 6 3 Pati nt Open Transfers ncsctcpitaideadecasddagdanidcahachnccapd gobbeadcckadeendaahdeahuchwncapdcetbeaguchedeanbennbersy 83 6 4 Patient Open Transfers by LHD ssssssssssesssssssssesssereressrerererererererrrrrerrrerererererererererererernt 86 6 5 Patient Transfer ENN rd 89 6 6 Patient Transfer TEGE 92 6 7 Patient Transfer Times Graph rrnnnnnnnrnnnnrrnnnnnnnnnnrnnnnvrnnnnnnnnnssnnnnrnnnnnnnnnnssnnnnrrnnnnnnnnner 96 6 8 Patients IN OUT sriciiniiieine aiaiai A A TEE EEA 101 DAD Transfers IWT Rea ek nada 104 7 1 Inter Ward Transfer Records essesssssseseseresssssssesreeessssssesrretreessseserreeeesesssesrreeeeesssseet 104 7 2 Inter Ward Transfer TT ES iosiicccelidiaedeasuaniaerecsantindunneemnexanddadanssuaibadqeddan
142. ent s UID or MRN WR value displays depends onthe LHD preferences DOB DD MM YYYY Patient s Date of Birth N A Gender Alphanumeric Patient s gender N A Accepting Doctor Alphanumeric MAME theDoctor accepting the N A admission Contact Alphanumeric Contact name for the accepting Doctor N A From Location Alphanumeric Where the patient is being admitted from N A To Ward Code Alphanumeric Mi Code the patient is being admitted N A To Ward Alphanumeric Ward Description the patient is being N A Description admitted to Speciality code Alphanumeric Code of the speciality the patient is being N A admitted under Description of the speciality the patient is Specialty Alphanumeric Being admitted under N A Estimated Length Numere How long the patient is expected to be N A of Stay admitted for Bed Type Alphanumeric Type of bed required by the patient N A Clinical note Alphanumeric Clinical notes entered against the N A admission Isolation Req vesorNo Flag to indicate if the patient requires N A isolation Date Time DD MM YYYY Date time the admission was requested N A Referral hh mm Date Time Patient DD MM YYYY Date time the patient was admitted into Time the user clicks on the Completed Admitted hh mm the hospital checkbox Facility ID Alphanumeric Code of the selected facility based on HIE N A facility code identifiers Facility Alphanumeric Name of the selected facility N A Count of Records Nume
143. er graph X axis Date Dates within the reporting period in Displays date chronological order left to right e Weekly Up to 12 calendar weeks of weekly snapshots per graph Displays the date range for the week e Monthly Up to 12 calendar months of daily snapshots per graph e Displays the month and year values from 0 100 Ke Line displays for 95 target on Sub report N A 3 only The of patients with LOS gt 24hrs amp Plot area Line clinician defined EDD as a line graph with N A data points for each day Legend Coloured line Line colour used for each facility and the N A with text facility name Reports Manual Page 20 of 185 GOVERNMENT Health 2 2 EPJB Audit Log Table 8 EPJB Audit Log Overview EPJB Audit Log EPJB Audit Log Provides a log of the users who have viewed patients on the Electronic Patient Journey Board module for a specific facility The audit log can only be downloaded for 1 day Can be used to monitor EPJB access by users at a specific facility ource PFP System Administrator only Excel only None Date defaulted to today and searches the events for date selected User First Name free text field that searches user s firstname a User Surname must also be entered User Surname free text field that searches user s Surname a User First Name must also be entered Patient First Name free text field that searches patient s first n
144. er of patients discharged on weekdays Number of patients discharged on the weekend Week Day Discharge Rate Weekend Discharge Rate Average ED Accessible Bed Occupancy Number of patients admitted to Hospital in the Home HITH Number of patients discharged from a Transit Lounge Number of patients who were discharged from a Transit Lounge via ED of patients who were discharged from a Transit Lounge via ED as a proportion of all Transit Lounge discharges Allows Whole of Hospital WoH Team members inclusive of Ministry of Health and relevant LHD Executives to monitor progress at WOH sites PFP MoH User Excel only From Date default Today The start date for the report To Date default Today The end date for the report Alphabetically by Facility N A N A Page 137 of 185 7 NSW Health Figure 63 Whole of Hospital Snapshot Layout Whole of Hospital Snapshot For the period 01 10 2013 to 31 10 2013 Northern Sydney Hunter New England Hunter New England Hunter New England Northern Sydney Hunter New England Murrumbidgee Murrumbidgee Hunter New England Hunter New England Illawarra Shoalhaven Hunter New England Hunter New England Hunter New England Hunter New England South Eastern Sydney Northern Sydney Reports Manual Page 138 of 185 MU GOVERNMENT Health Table 86 Whole of Hospital Data Elements Field Format Defi
145. est date time Excel 1 Sort Alphabetically by Facility From 2 Sort Alphabetically by Facility To 3 Sort Chronologically by Transfer Request date time N A A transfer must have a status of Requested Confirmed or In Progress to appear on the report Figure 38 Patient Open Transfers Layout PDF Patient Open Transfers Sol are A Reports Manual St Vincent s Hospital Darlinghurst Maitland Private Hospital Newcastle Private Hospital Maitland Private Hospital Newcastle Private Hospital Hunter Valley Private Hospital Newcastle Private Hospital Newcastle Private Hospital Warners Bay Private Hospital Lake Macquarie Private Hospital Snapshot 20 11 13 03 33 Receiving Bed Info Transfer Note Admitted 10 9 in Heart Failure Found to have PPM Lead through Tricuspid Valve causing Tricuspid Regurgitation Estimated Transfer Time Transfer Request Time Inpatient specialist een i 23 09 13 23 09 13 care 24 72hrs c Surgery 10 52 10 50 Surgical Rehabilitatio n Medicine 10 01 10 00 Rehabilitatio 02 10 13 02 10 13 n Medicine 17 03 17 00 Urgent specialist 30 09 13 30 09 13 care lt 24hrs Inpatient specialist care 24 72hrs Inpatient Specialist Care 24 72 hours Future Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Urgent specialist care lt 24hrs Urgen
146. ested requests the transfer Date time the patient was ead DD MM YY estimated to be ready for PDF and Excel N A Transfer Time hh mm transfer Cancel Transfer DD MM YY Date time the transfer was PDF and Excel N A Time hh mm cancelled Cancel Reason Alphanumeric The reason the transfer was cancelled PDF and Excel Selected from a pre defined drop down list Patient deceased Patient discharged Patient transferred to another facility Treatment provided completed at admitting hospital Request for transfer not appropriate Cancelled by receiving hospital Others Cancel Notes Alphanumeric Free text field to record additional information regarding the cancelled transfer PDF and Excel N A Reports Manual Page 91 of 185 Health GOVERNMENT 6 6 Patient Transfer Times Table 61 Patient Transfer Times overview Repo De Repo Repo Data So Repo O po Pro 0 o O O O Orq Reports Manual Patient Transfer Times Reports on the time taken to complete all incoming and outgoing transfers at a specific facility Can be used for e Hospital reporting to identify patients who breached Urgency Category transfer times e Searching for a specific completed patient transfer PFP All users except Ambulance Users PDF default and Excel Facilities The facility or facilities the user wants to run the report for Facilities available for sel
147. f a specific facility including how many were within and outside the defined expiration periods for each urgency category Provides accessible information indicating the e Frequency of meeting transfer time expiration periods e Sending and receiving hospitals that are not meeting the Urgency Category transfer timeframes PFP All users except Ambulance Users PDF only Produces eight sub reports one each of the following for transfers into and out of a specific facility Urgency Category within outside time graph A graph detailing counts of transfers into out of a specific facility by Urgency Category that were within and outside the expiration periods Urgency Category summary table A table detailing the shortest longest and average transfer times into out of a specific facility per Urgency Category Transfers from to facility within outside time graph A graph detailing the transfers from to each facility that were within and outside the expiration periods regardless of Urgency Category Transfers from to facility within outside time summary table A table detailing the counts of transfers from to each facility that were within and outside the expiration periods regardless of Urgency Category Note Expiration period is the recommended clinical timeframe for each Urgency Category in regards to transferring the patient Facilities The facility or facilities the user wants to run the report for Facilities
148. financial class Logi f th h tered Entered by Alphanumeric OEN NATE OLME ene eer Excel N A Reports Manual Page 85 of 185 Health GOVERNMENT Report Format Definition Format Rules Calculations Login name of the user who last edited Last updated by Alphanumeric the transfer det ils Excel N A 6 4 Patient Open Transfers by LHD Table 57 Patient Open Transfers by LHD Overview Repo e Patient Open Transfers by LHD Report that provides information on all outgoing and incoming open transfers within a specific LHD Can be used as a contemporary carry around list of expected transfers at meetings and for hospital and LHD reporting Repo Data SO e PFP Acce Patient Flow Manager Patient Flow Administrator LHD User and MoH User Repo pe Current Facility Snapshot Repo D 3 Excel only LHD s The LHD or LHD s the user wants to run the report for LHD s available for selection depends on the user s access rights 1 Sort Alphabetically by Facility From ort Orde 2 Sort Alphabetically by Facility To 3 Sort Chronologically by Transfer Request date time Ale N A A transfer must have a status of Requested Confirmed or In Progress to appear on the report Reports Manual Page 86 of 185 Z GOVERNMENT Health Figure 40 Patient Open Transfers Layout Excel Patient Open Transfers by LHD Current Ward Description Current
149. h d atents with a readmission via Unit type 17 or 58 in DAYS EPISODE the Emergency Department to i i Soins table Time period the same hospital within 28 A s er i MAU discharged to place of usual residence Same facility Readmission Rate days of discharge from MAU PEN j Me S ae p trans_type DIS AND unit_type is a MAU Re admissions are identified based on Within SUS o ward unitor MANE ard in the DAYS EPISODE table AND the admission date of the 2 12 MAU Discharged lt 10 to Discharge Lounge and then gr NE home direct from MAU unit to place of usual residence The inpatient stay only contained time in the MAU ward and the patient was discharged from MAU Inpatient mode of separation in 1 2 3 6 7 8 11 in the EPISODE table Numerator Count of persons in the denominator that had an admission via the emergency department within 28 days of admission Exclude patients with Planned Admissions within 28 days following the 1 admission Reports Manual Page 150 of 185 7 Health GOVERNMENT Indicator Criteria Calculation amp Data Source Tables Limitations or Comments discharge Denominator Count of admissions to MAU that were discharged from the MAU to home i e last ward was MAU or MAU Discharge Lounge Home Data source Tables DAYS EPISODE EPISODE STAY 13 MAU NEAT
150. h mm transfer request was submitted If Urgency Category equals one of e Life Threatening e Urgent Specialist Care lt 24 hours e Inpatient Specialist Care 24 72 hours e Return Transfer of Care Post Specialist Care Then the given Urgency Category is displayed Urgency Category assigned to the i EE Urgency Alphanumeric transfer If Urgency Category equals Future Inpatient Specialist Care 24 72 hours then the Urgency Category displays as Inpatient Specialist Care 24 72 hours If the Urgency Category equals Future Return Transfer of Care Post Specialist Care then the Urgency Category displays as Return Transfer of Care Post Specialist Care Code of the facility the patient To Facility ID Alphanumeric was transferred to based on HIE Displays on To worksheet only facility code identifiers To Facility Alphanumeric Full name of the facility the Displays on To worksheet only patient was transferred to From Facility ID Alphanumeric Code of the facility the patient was transferred from based on HIE facility code identifiers Displays on From worksheet only From Facility Alphanumeric Full name of the facility the patient was transferred from Displays on From worksheet only Ward Code the patient was Requ sting Alphanumeric admitted into when the transfer N A Ward Code ae request was initiated Requesting Ward Description the patient was Ward Alp
151. hanumeric admitted into when the transfer N A Description request was initiated Current Ward gt Ward Code the patient is Code RE currently admitted to N A Current Ward Alphanumeric Ward Description the patient is N A Description currently admitted to Surname Alphanumeric Patient s Surname N A First Name Alphanumeric Patient s First Name N A Patient ID Alphanumeric Patient s UID or MRN Which value displays depends on the LHD preferences DOB DD MM YYYY Patient s Date of Birth N A Gender Alphanumeric Patient s gender N A Requesting Alphanumeric Name of the Doctor requesting N A Doctor the transfer Contact name Alphanumeric Contact name for the requesting N A Doctor Contact ph ber for th Contact phone Alphanumeric eee P PG N A requesting Doctor Receivin Name of the Doctor accepting 8 Alphanumeric the patient at the receiving N A Doctor facility Receiving Alphanumeric Contact details for the receiving N A Doctor contact Doctor Patient s Financial Status which is based on their fi ial cl g Financial Status Alphanumeric asedion their financial class e g N A Public Private DVA Compensable etc Reports Manual Page 80 of 185 Wi GOVERNMENT Health Format Definition Rules Calculations Financial Description Alphanumeric Patient s Financial Description associated with their financial class N A Bed Requested Info Alphanumeric F
152. has approved access to Order within Results Tables and Trend Line Graphs is the time period i e Day Week or Month in chronological order N A N A Reports Manual Page 163 of 185 NSW Health Figure 70 LHD MAU Snapshot Summary Table Layout LHD MAU Snapshot Summary Weekly Snapshot for the Period 03 02 2014 to 27 04 2014 Re Avg LOS of Re Avg total MAU admission Avg LOS in Patients admission Patients Patients Patients rates of MAU for discharged hours in ED Avg LOS in patients MAU home Separati patients transferred transferred discharged home trom Admissions rate of MAU for all MAU MAU hrs transferred or MAU from MAU aged 65 from MAU to from MAU home from MAU within direct to home patients to a ward ward within 48 hrs MAU MAU discharges days ward home hrs 48 hrs ONLY discharges 03 02 2014 to 09 02 2014 10 02 2014 to 16 02 2014 17 02 2014 to 23 02 2014 24 02 2014 to 02 03 2014 03 03 2014 to 09 03 2014 10 03 2014 to 16 03 2014 17 03 2014 to 23 03 2014 24 03 2014 to 30 03 2014 31 03 2014 to 06 04 2014 07 04 2014 to 13 04 2014 14 04 2014 to 20 04 2014 21 04 2014 to 27 04 2014 Patient Flow Portal Medical Assessment Unit Report Page 1 of 7 NSW Health GOVERNMENT Reports Manual Page 164 of 185 Wi Health Figure 71 LHD MAU Snapshot Summary Graph Layout LHD MAU Snapshot Summary 0 03 02 2014 to 09 0
153. he Completed time XX hour s Request Time and the Transfer PDF and Excel Wen Urcenty Catecorythevalue P XX min s Completed Time 8 ET gory will display in red Reports Manual Page 110 of 185 Health GOVERNMENT 7 3 Patient Open Inter Ward Transfers Table 75 Patient Open Inter Ward Transfers Overview Repo De O o po D O A ele O o omp o O O o O Orq Ale Business rules Patient Open Inter Ward Transfers Reports on all open i e not completed inter ward transfers within a specific facility Can be used as a contemporary carry around list of expected ward transfers at meetings and for hospital reporting PFP All users except Ambulance Users PDF and Excel default Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights 1 Sort Alphabetically by From Ward 2 Sort Alphabetically by To Ward 3 Sort Chronologically by Request date time N A A transfer must have a status of Requested to appear on the report Reports Manual Page 111 of 185 7 NSW Health Figure 54 Patient Open Inter Ward Transfers Layout PDF Patient Open Inter Ward Transfers Snapshot 29 11 13 01 32 Ward From Ward To Urgency Transfer Estimated Isolation inpatient Orthopaedic Darrell ICU HDU ASURG ICU HDU specialist care P 26 11 13 10 14 26 11 13 10 10 24 72h
154. he ward or hh mm 4 Transferred e Patient was transferred into the receiving ward via the PAS Status Alphanumeric Current status of the ward transfer Requested or Completed Facility ID Alphanumeric Code of the selected facility based on HIE N A facility code identifiers Facility Alphanumeric Name of the selected facility N A Count of Records Numeric Number of IWT records in specified date range N A Reports Manual Page 106 of 185 Health GOVERNMENT 7 2 Inter Ward Transfer Times Table 73 Inter Ward Transfer Times Overview Reports Manual Inter Ward Transfer Times Reports on the time taken to complete all inter ward transfers at a specific facility Can be used for hospital reporting and to identify patients ward transfer times at a specific facility PFP All users except Ambulance Users PDF default and Excel Wards The ward or wards the user wants to run the report for All Wards display within the selected facility the user has access to From Date default Today The start date for the report based on the Transfer Request date time of the transfer To Date default Today The end date for the report based on the Transfer Request date time of the transfer 1 Sort Alphabetically by Ward 2 Sort Chronologically by Transfer Request date time The Request to Completed time will be highlighted in red text for any transfers that have e
155. heckbox will de select all facilities e The Wards or Ward Groups the user is able to run the report for If the radio button Wards is selected all wards in the given facility are displayed it is not dependent on the user s access level Wards Ward Depending on the report selected Designated ED and Day Only wards may not be available for Groups selection e If the radio button Ward Groups is selected all Ward Groups in the given facility are displayed One many or all Wards Ward Groups can be selected by ticking the associated checkbox es All are selected by default but can be de selected by unticking the Select All checkbox Date the report will generate data from Date From e Defaults to Today A date can be selected by clicking on the calendar icon and clicking on the required date Date the report will generate data to Date To Defaults to Today A date can be selected by clicking on the calendar icon and clicking on the required date Run snapshot per day Extracts aggregated retrospective data based on a calendar day The user can select to extract up to 31 days of daily data prior to a user selected date Run snapshot per week Extracts aggregated retrospective data based on a calendar week The user can select to extract up to 12 calendar weeks of data prior to a selected date A week is defined as Monday to Sunday Run snapshot per month Extracts aggregated retrospective
156. her a daily weekly or monthly snapshot is selected e Daily Up to 31 days of daily Date Date Date range for the report snapshots per table e Weekly Up to 12 calendar weeks of daily snapshots per table e Monthly Up to 12 calendar month of daily snapshots per table Facility Text Name of the facility the data relates to N A Sum of number of patients with LOS gt 24 hours 24 Avg No Pts with Numeric Number of patients for the given facility Data excludes patients in LOS gt 24hrs with LOS gt 24hrs e Wards flagged as Day Only OR Designated ED e Virtual Beds i e Well Babies Boarder and Leave Sum of number of patients with LOS gt 24 hours and Clinician Defined EDD 24 Avg No Pts with i Ae 1892448 a bees entre EN Data excludes patent Clinician Defined EDD e Wards flagged as Day Only OR EDD Designated ED e Virtual Beds i e Well Babies Boarder and Leave Avg Pts with LOS gt 24hrs amp Depeautase The of patients for the given facility with Clinician Defined g LOS gt 24hrs and a clinician defined EDD EDD Avg No Pts with LOS gt 24hrs amp Clinician Defined EDD Avg No Pts with LOS gt 24hrs x 100 Table 7 Clinician Defined EDD Compliance by Facility Graphs Data Elements Definition Rules Calculations Graph displays differently depending on whether a daily weekly or monthly snapshot is selected e Daily Up to 31 days of daily snapshots p
157. hin the reporting period which contribute to the 80 cumulative total The remaining WFW reasons are then grouped into the Others column Page 71 of 185 Health GOVERNMENT Figure 32 Waiting for What Bed Days Bed Days Used Pareto Chart and Summary Table Layout Waiting for What Bed Days For the Period 01 11 13 to 20 11 13 Bed Days Used per Waiting for What Reason WFW Bed Reasons Days cuneate ron within range Out of Hospital Referral Rehabilitation Bed or Service 85 25 25 Discharge Process Other 74 Transfer Transport IHT Waiting for Bed amp 45 Accepting Facility Diagnostics Treatment Other 39 Diagnostics Treatment Operating Theatre 19 Discharge Process Family Carer 19 Conference Others 62 WFW Bed Days within range SaneInwng Rehabilitation Bed or Ser IHT Waiting for Bed Ac Operating Theatre Family Carer Conference Denotes WFW Reasons that are now inactive Pareto principle also known as the 80 20 rule the law of the vital few and the principle of factor scarcity states that for many events roughly 80 of the effects come from 20 of the causes The purpose of the Pareto Chart is to assess the most frequently occurring delays in order to focus 80 of your time and energy on the 20 of the delays that are really important Cutoff 80 e Cumulative NN Bed Days Per Reason WE Bed Days Per Others Table 46 Waiting for What Bed D
158. hour occupied by a patient at the snapshot time Number of Unavailable beds in the ward Count of Unavailable beds in ward at the Unavailable beds Numeric at the given hour snapshot time Patients in Number of occupied Unavailable beds in Count of Unavailable beds in the ward Numeric i F P i Unavailable beds the ward at the given hour occupied by a patient at the snapshot time Number of Surge beds in the ward atthe Count of Surge beds in ward at the Surge beds Numeric given hour snapshot time Patients in Surge Number of occupied Surge beds in the Count of Surge beds in the ward occupied Numeric z i beds ward at the given hour by a patient at the snapshot time Number of Open Available Surge beds Count of Open beds in ward at the Open Beds Numeric i in the ward at the given hour snapshot time Patients in Open Number or orcupied Open Available Count of Open beds in the ward occupied Numeric Surge beds in the ward at the given beds hour by a patient at the snapshot time Number of Closed beds in the ward at Count of Closed beds in ward at the Closed beds Numeric the given hour snapshot time Patients in Closed Number of occupied Closed beds in the Count of Closed beds in the ward occupied Numeric z Beds ward at the given hour by a patient at the snapshot time Total of patients Available Beds 100 Occupancy of Available beds in the 9 Occupancy Percentage ward at the giv
159. ilable beds per day across the LHD for the given Available Beds g LOS gt 99 days as a percentage month x 100 Occupancy Text Title for data about Occupancy N A AVe Occ bane RS Count of occupied available beds for all facilities in a LHD excludes patients in Beds flagged as 5 pany Percentage on i res g Boarder Leave or Well Baby or Inactive Wards Count of available beds for all facilities in a LHD x the facilities within a LHD 100 Avg ED Average ED Accessible Bed occupancy Count of number of occupied available ED Accessible beds for all facilities in a LHD excludes patients Accessible Bed Percentage percentage for all the facilities withina in Beds flagged as Boarder Leave or Well Baby or Inactive Wards Count of available ED Accessible Occupancy LHD beds for all facilities in a LHD x 100 Estimated Date Text Title for data about Estimated Date of N A of Discharge Discharge or EDD Average clinician defined EDD Count of patients within an LHD with a Clinician Defined EDD excludes patients in wards flagged as Pa ies de Day Only OR Designated ED and beds flagged as Boarder leave or Well Baby and LOS lt 24hrs Avg Clinician percentage for all the facilities within a f sails Percentage Count of patients within a LHD excludes patients in wards flagged as Day Only OR Designated ED Defined EDD LHD and beds flagged as Boarder leave or Well Baby and LOS lt 24hrs x 100 Reports M
160. ined by the user and displayed as DD MM YY if Daily Snapshot selected Sum of all transfers and discharges OUT of ALL Specialties Snapshot Date DD MM YY DD MM YY to DD MM YY if Weekly N A snapshot selected MMM YYYY if Monthly snapshot selected Number ot panen admitted ve Count of patients admitted or transferred INTO Specialty Numeric transferred into the specialty for the 5 into the specialty in the snapshot period given snapshot period Number BE patients Waastered Count of patients transferred or discharged OUT Specialty Numeric discharged out of the specialty for the out of the specialty in the snapshot period given snapshot period Total of all transfers and admissions INTO Sum of all INTO Specialty for the snapshot TOTAL ALL Specialties period Sum of all OUT Specialty for the snapshot period Reports Manual Page 61 of 185 Wis NSW Health 5 0 WAITING FOR WHAT REPORTS Figure 27 is a diagrammatical representation of the business rules for a Waiting for What WFW reason to be included in the following reports e Waiting for What All reasons e Waiting for What Bed Days e Waiting for What Reasons Count Figure 27 Waiting for What Report Business Rules Date range prompts TE Date From Date To 01 08 2011 14 08 2011 Start date Close date 20 07 2011 Discharge Process Discharge equipment still open Close date or Start date i reke
161. information about Medical Assessment Units based on a daily weekly or monthly snapshot for 1 or more LHD s a user has approved access to Average Total Hours in ED for all MAU Patients Average LOS in MAU Hours Average LOS of MAU Patients Transferred to a Ward Days Readmission Rates within 28 days of MAU Home or MAU ward home discharges Separations from MAU Average LOS in MAU for patient aged 65 Hours patients transferred from MAU within 48 hours patients discharged home from MAU patients discharged home from MAU within 48 hours MAU patients transferred to ward Admissions direct to MAU Re admission rate of MAU home discharges ONLY MAU NEAT The data is presented in both tabular and graphical format Trend line graphs are displayed for the 4 performance indicators Note Readmission data is calculated based on 28 days since the patient was discharged from their previous admission where they visited a MAU As such if this report is generated for last 28 days prior to today the readmission data will not be up to date Can be used to obtain an overview of the operations and performance of Medical Assessment Units in a LHD HIE All users except Ambulance User and Connecting Care User PDF in landscape display default Excel tables only Daily snapshot up to 31 calendar days Weekly snapshot up to 12 calendar weeks Monthly snapshot up to 12 calendar months LHD s user
162. ion data is calculated based on 28 days since the patient was discharged from their previous admission where they visited a MAU As such if this report is generated for last 28 days prior to today the readmission data will not be up to date Can be used to obtain an overview of the performance of Medical Assessment Units across NSW Health Repo DELE s HIE Acce All users except Ambulance User and Connecting Care User PDF in portrait display Excel tables only dato e Number of months Between 1 12 Results Table 1 sort Peer Group in alphabetical order ort Orde 2 sort Facility in alphabetical order Trend Line Graph Time period in chronological order from left to right Ale N A N A Reports Manual Page 171 of 185 Health GOVERNMENT Figure 75 NSW Health MAU Performance Trend Summary Table Layout NSW Health MAU Performance Trend Summary For the Period Jul 2013 to Dec 2013 NSW Health Average total hours in ED for all MAU Patients E Aug Sep Oct Nov Dec Hospital A1 14 79 6 5 52 5 1 5 5 Hospital A1 3 7 32 3 0 3 1 3 3 3 3 Hospital Al 68 68 7 0 7 1 6 1 6 1 Hospital Al 75 78 6 7 6 0 5 6 5 6 Al 92 96 72 48 6 5 6 1 A1 6 5 65 58 5 1 47 4 1 A1 6 3 75 6 8 6 5 55 63 Al 5 0 37 35 3 2 29 29 Al 65 56 6 2 7 2 5 6 55 Al 64 83 6 7 6 0 5 8 56 A1 129 136 118 117 104 75 A1 4 1 3 1 3 0 2 8 24 A1 99 9 1 94 8 6 6 5 2 5 5 8 1 8 7 8 5 8 1 6 4 5 8 9 0 7 0 T2 7 o
163. ional Summary LHD Operational Summary Trend NSW Health Operational Summary Reports Manual Page 16 of 185 NSW GOVERNMENT Health 2 0 FACILITY REPORTS 2 1 Clinician Defined EDD Compliance by Facility Table 5 Clinician Defined EDD compliance by Facility Overview pO D o pO D A ee O D o po Pro o O O O olge Reports Manual Clinician Defined EDD Compliance by Facility EDD Compliance by Facility Provides an average daily snapshot of the following data for a facility e Avg number of patients with LOS gt 24hrs e Avg number of patients with LOS gt 24hrs and clinician defined EDD e Avg percentage of patients with LOS gt 24hrs and clinician defined EDD All values exclude patients in wards flagged as Designated ED and Day Only Allows Patient Flow Managers and Hospital Executives to review EDD compliance as a measure of care coordination within the organisation PFP All users except Ward User Clinical Manager and Ambulance User PDF only Produces three sub reports Summary table A summary table detailing the EDD compliance per calendar day calendar week or calendar month as selected for each facility All facilities Avg Compliance comparison graph A graph comparing the Avg EDD compliance of all facilities selected Individual facility gt 95 Compliance graph A graph displaying the Avg EDD compliance for each facility
164. it 14 03 1957 female Neralee 55310 Chargeable r E pg Intensive Care Unit Intensive Care Unit G2ASU G2 Neurosciences 12 08 1958 female Neralee 55310 Chargeable Urgent specialist biain Cena inal F3C F3 Cardiac Surgery care lt 24hrs Vascular Urgent specialist idino Cara Unit F3C F3 Cardiac Surgery care lt 24hrs Vascular r ee seng Intensive Care Unit G2 Neurosciences G2ASU G2 Neurosciences 20 06 1952 male Neralee 55310 Public Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist Intensive Care Unit F3C F3 Cardiac Surgery care lt 24hrs Vascular Urgent specialist Intensive Care Unit F3C F3 Cardiac Surgery care lt 24hrs Vascular Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist F3 Cardiac Surgery Gie lt DAS Intensive Care Unit Vascular Urgent specialist F3 Cardiac Surgery cne lt 20 Intensive Care Unit Vascular Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs ha r igj Intensive Care Unit G1 G1 General Surgery 26 06 1942 female Neralee 55310 Chargeable Urgent specialist North Ward Rankin Park f ENG Zak Intensive Care Unit Hospital G2ASU G2 Neurosciences 19 03 1927 female Neralee 55310 Public 26 11 13 11 11 25 11 13 10 55 25 11 13 10 54 25 11 13 10 54 r 21 11 13 09 45 29 08 1936 femal
165. ital Maitland Private Hospital Manning Base Hospital Norwest Private Hospital Pendlebury Clinic Private Prince of Wales Hospital Quirindi Community Hospi Singleton District Hospital es Graph Homsby and Ku Ring Gai Hospital Hunter Valley Private Hospital Lake Macquarie Private Hospital Muswellbrook District Hospital Newcastle Private Hospital Hospital ital Scott Memorial Hospital Scone St Vincent s Private Hospital The Children s Hospital at Westmead Warners Bay Private Hospital gt Sr Outside poem 2 F 3 3 For the Period 01 09 13 to 31 10 13 Excludes incomplete transfers Table 67 Patient Transfer Times Graph Transfers From To Facility Within Outside Time Summary Table Data Elements Format Transfers OUT and IN Definition Rules Calculations From Facility or To Facility Alphanumeric Name of facility the patient was transferred from or to N A Within Time Numeric Count of patients who were transferred from or to the given facility within the expiration period of their assigned Urgency Category N A Outside Time Numeric Count of patients who were transferred from or to the given facility outside the expiration period of their assigned Urgency Category N A Reports Manual Page 100 of 185 GOVERNMENT Health 6 8 Patients IN OUT Table 68 Patients IN OUT Overview Repo Patients IN OUT a 3 Number
166. itted in March 2012 but met the admission risk in April 2012 they will appear in the count for March 2012 e Patients in a ward assigned to one of the following ward type sub ward types do not display in this report Medical Dialysis OR Paediatric Dialysis OR Ambulatory Care No Subtype e Refer to the Predictive Tool User Manual for further information about Control Charts and Nelson Rules Page 184 of 185 Wi GOVERNMENT Health Last Refreshed 26 11 2013 12 12 Admission Risk Multiple admissions Gosford Hospital Mav 2013 I Reports Manual Page 185 of 185
167. lected LHD with Reports Manual Page 127 of 185 Wis GOVERNMENT Health Format Definition Rules Calculations e Urgency Return Transfer of Care Post Specialist Care gt 1 business day e Urgency Future Return Transfer of Care Post Specialist Care gt 1 business day e Completed Time was between the first and last day of month x 100 Avg Breached Wait Time hrs Transfers OUT Hours Average waiting time for patients who have breached the transfer urgency time for Transfers OUT Urgency Life Threatening Sum of minutes for patient transfers out of the selected LHD with e Urgency Life Threatening e Request Transfer Time to Transfer Completed Time gt 4 hours e Completed Time was between the first and last day of month Count of patient transfers out of the selected LHD with e Urgency Life Threatening e Request Transfer Time to Transfer Completed Time gt 4 hours e Completed Time was between the first and last day of month Urgency Urgent Specialist Care lt 24 hours Sum of minutes for patient transfers out of the selected LHD with e Urgency Urgent Specialist Care lt 24 hours e Request Transfer Time to Transfer Completed Time gt 24 hours e Completed Time was between the first and last day of month Count of patient transfers out of the selected LHD with e Urgency Urgent Specialist Care lt 24 hours e Request Transfer Time to Transfer Completed
168. led i e not completed within a given a date range for a specific facility To look retrospectively at cancelled transfers the reasons for cancellation and analysis of waits PFP All users except Ambulance Users PDF default and Excel Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights From Date default Today The start date for the report based on the Transfer Cancel date time of the transfer To Date default Today The end date for the report based on the Transfer Cancel date time of the transfer PDF Chronologically by Transfer Request date time Excel 1 Sort Alphabetically by Facility From 2 Sort Alphabetically by Facility To 3 Sort Chronologically by Transfer Request date time N A A transfer must have a status of Cancelled to appear on the report Page 89 of 185 W NSW Health Figure 41 Patient Transfer Cancellations Layout PDF Patient Transfer Cancellations For the Period 1 06 13 to 5 12 13 From Transfer Estimated Transfer Specialty Request Transfer Cancel Cancel Reason Cancel Notes Time Time Time Patient ID Patient Name Facility To peed Emmaville Vegetable Creek Multi Purpose Service Return Transfer of Acute Care Post Specialist Geriatric Care Medicine tena 100018 vee Cancelled by receiving hospital pt now for re
169. lphanumeric Name of the Doctor requesting the N A Doctor transfer Open Transfer Time X days Y hours Length of time the request has been open Expired transfers will display in red Current transfers will display in black Future estimated transfers will display in green Status Alphanumeric Current status of the transfer request Expired transfers will display in red Current transfers will display in black Future estimated transfers will display in green Transfer note Alphanumeric Free text information about the transfer Information entered in the Transfer Notes field on the Transfer request window Patient s Financial Status which is based on their financial class e g Financial Status Alphanumeric Public Private DVA Compensable N A etc Financial Patient s Financial Description nae Alphanumeric p fe N a Description associated with their financial class Entered by Alphanumeric Login name of the user who entered N A the transfer Logi f th ho last edited Last updated by Alphanumeric EN ere penser ge N A the transfer details Reports Manual Page 88 of 185 Health GOVERNMENT 6 5 Patient Transfer Cancellations Table 59 Patient Transfer Cancellations Overview Repo De O o po D ele O pO Pro D co O O eq O Oraq Reports Manual Patient Transfer Cancellations Report of all transfers that were cancel
170. ludes AMO specialty ED Total number of beds that were needed to meet demand including booked direct Actual Beds required Numeric na 3 admissions and Emergency admitted patients Actual Booked Numeric Total number of booked admissions Admissions Actual Direct Numeric Actual number of direct admissions Admissions Actual Discharges Numeric Actual number of discharges from ED accessible beds excluding Day Only Maternity and well babies Actual EDO patients who were admitted and separated within 24 hours from an EDO Actual EDO Numeric Unit Bed Actual Medical Numeric Actual medical overnight admissions Overnight Actual Surgical 2 3 TE y a mr Numeric Actual surgical overnight admissions Overnight All ED Admissions Numeric Total number of ED admissions EDO 23h tient i F F s I EE Actual number of EDO patients who were admitted with an intention to separate within 28 requiring an Numeric impatient bed hours and then required an overnight ward Bed Available ED Numeric accessible beds Average number of available ED accessible beds Bed Demand Status umerit Predicted beds available minus predicted beds required Shows the surplus or deficit of expected beds G Expected Extended Day Only EDO 23 hour patients who will be admitted and separated Booked ERO AE within 24 hours into an EDO Unit Bed Manual entry ea Numeric Expected overnight medical admission
171. mated Discharge Excel N A Date Specialty Alphanumeric Patient s specialty PDF and Excel N A Ward Code Alphanumeric Ward Coge Palen Ne PDF and Excel N A currently admitted into Ward Alphanumeric Ward Description patient is Excel N A Description currently admitted into Med Officer Alphanumeric Patient s AMO PDF and Excel N A Patient s Financial Status which is based on their Financial Status Alphanumeric financial class e g Public Excel N A Private DVA Compensable etc Financial Patient s Financial ae Alphanumeric Description associated with Excel N A Description ne their financial class Last Updated DD MM NY Date the WFW reason was Excel N A Date last updated Reports Manual Page 66 of 185 Health GOVERNMENT Format Definition PDF Excel Rules Calculations Logon id of the person who Last Updated By Alphanumeric last updated the WFW Excel N A reason EN S Facility code based on the HIE Excel Facility Alphanumeric facility code identifier N A Reports Manual Page 67 of 185 Health GOVERNMENT 5 2 Waiting for What Current Admissions Open Reasons Table 43 Waiting for What Current Admissions Open Reasons Overview epo Repo De O ReDo a Repo BE O er 5 Repo O Repo Pro 0 o O C A ad O ejg Business Rules Figure 30 Waiting for What Current Admissions Open Reasons La
172. me N A User PC IP Displays the IP address of the PC the Text pe N A Address user was using Displays the patient UID or MRN Patient ID Text PER TER N A depending on the AHS PAS Patient Text Displays the patient s surname N A Surname Patient First Text Displays the patient s first name N A Name Displays the event as either e Patient View e Patient Detail View e Incoming IHT Event Text Incoming IWT N A e Outgoing IHT e Outgoing IWT e Outlier out of ward e Admitted Patient in ED Event i Date Time Displays the date time of the event N A Date Time Reports Manual Page 22 of 185 NSW GOVERNMENT Health 2 3 Hospital Occupancy Table 10 Hospital Occupancy Overview Reports Manual Hospital Occupancy Hour by hour snapshot of total capacity total available beds total occupancy ED Accessible Bed occupancy and surge beds occupied Can be used to obtain a snapshot occupancy indicating hourly demand for any given day to provide an indication of patterns in capacity and demand PFP All users except Ambulance User PDF default and Excel Facilities The facility or facilities the user wants to generate the report for Facilities available for selection depends on the user s access rights From Date default Today To Date default Today 1 Sort Chronologically by Date 2 Sort Chronologically by Snapshot hour The report will highlight the h
173. mmary Daily Snapshot for the Period 01 12 2013 to 31 12 2013 Hospital Hunter New England Re Avg LOS of seai Avg total MAU moa Sp kyst Patients Patients Patients discharged admission hours in ED Avg LOS in patients Separations transferred transferred discharged Admissions rate of MAU for all MAU MAU hrs transferred oe from MAU toe from MAU to from MAU home from shee EE direct to home patients to a ward Ser AE orke ward within 48 hrs MAU air roman MAU discharges days ONLY discharges Patients Re 01 12 2013 Sun 02 12 2013 Mon 03 12 2013 Tue 04 12 2013 Wed 05 12 2013 Thu 06 12 2013 Fri 07 12 2013 Sat 08 12 2013 Sun 09 12 2013 Mon A 10 12 2013 Tue 53 11 12 2013 Wed 57 12 12 2013 Thu 59 13 12 2013 Fri 5 1 14 12 2013 Sat 20 15 12 2013 Sun 33 16 12 2013 Mon 44 17 12 2013 Tue 8 0 18 12 2013 Wed 66 23 6 54 19 12 2013 Thu 49 21 2 11 9 20 12 2013 Fri 7 0 24 1 77 21 12 2013 Sat 51 192 8 4 22 12 2013 Sun 52 15 6 1 8 Patient Flow Portal Medical Assessment Unit Report Page 1 of 7 NSW Health Reports Manual Page 157 of 185 Ws GOVERNMENT Health Figure 67 Facility MAU Snapshot Summary Graph Layout Facility MAU Snapshot Summary Daily Snapshot for the Period 01 12 2013 to 31 12 2013 Average LOS in MAU Hours 01 12 2013 Sun 02 12 2013 Mon 03 12 2013 Tue 04 12 2013 Wed 05 12 2013 Thu 06 12 2013 Fri 07 12 2013 Sa
174. n Count of bed days consumed for all W4W reasons Capacity terms of the number of bed days Sum of daily average of number of available beds across the LHD Daily average is calculated as sum Equivalent consumed by W4W delay reasons for a of hourly snapshots divided by 24 x 100 all categories Avg Pts with Percentage of patients who have had Count of patients with an open WFW reason between the first and last day of the month for all WA4W Reason Percentage an open W4W reason between the categories first and last day of the month Count of all patients admitted at a specific LHD x 100 Waiting for What By Text Title for data about W4W Delay N A Reasons by category Category Count of number of W4W reasons for the given category open at some time between the first and Total number of open W4W reasons last day of month Records Numeric which are consuming bed days for each category Total Sum of all open W4W reasons between the first and last day of month Total number of bed days consumed Count of beds days consumed for W4W reasons for the given category open at some point between Bed Days Numeric for all open W4W delay reasons by the first and last day of the month Category Count of bed days per W4W reason Number of days from W4W Start Date to one of the following Reports Manual Page 122 of 185 Wis GOVERNMENT Health Format Definition Rules Calculations dates
175. n Transfer of Care Post Specialist Care gt 1 business day e Request Transfer Time to Transfer Completed Time gt 1 business day e Completed Time was between the first and last day of month OR e Urgency Future Return Transfer of Care Post Specialist Care gt 1 business day e Estimated Transfer Time to Transfer Completed Time gt 1 business day e Completed Time was between the first and last day of month Count of patient transfers into the selected LHD with e Urgency Return Transfer of Care Post Specialist Care gt 1 business day AND Request Transfer Time to Transfer Completed Time gt 1 business day Reports Manual Page 130 of 185 Health GOVERNMENT Field Format Definition Rules Calculations e Urgency Future Return Transfer of Care Post Specialist Care gt 1 business day AND Estimated Transfer Time to Transfer Completed Time gt 1 business day e Completed Time was between the first and last day of month Reports Manual Page 131 of 185 NSW GOVERNMENT Health 9 2 Facility Operational Summary Trend Table 81 Facility Operational Summary Trend Overview Facility Operational Summary Trend Provides a snapshot of operations for a specific Facility using the Patient Flow Portal by reporting information about e NEAT e LOS gt 49 Days e LOS gt 99 Days e Total Occupancy and ED Accessible Occupancy e Estimated Date of Discharge Clinician Defined and Expir
176. nit Indicator Calculations All the MAU reports provide data about specific performance and process indicators that are consistent across each report The performance indicators are all patient centric focussing on the benefits of the MAU for patients whilst the process indicators are to assist LHD s and facilities to understand manage and monitor internal processes The targets criteria calculation data source tables limitations and other comments are identified in Table 88 as opposed to being documented in each of the reports detailed below All data for the MAU reports are sourced from NSW Health s Health Information Exchange HIE data warehouse Table 88 MAU Performance and Process Indicator Descriptions Indicator Target Criteria Calculation amp Data Source Tables Limitations or Comments Performance Indicators Numerator Sum episode_length_hours Average hours in ED for ALL where unit type in 17 758 e Discharged patients Average Total Hours patients admitted to the MAU e Time period 1 in ED for all MAU lt 4hrs direct admissions who bypass Denominator Count of stays where patient e Same facility sum patients ED ED triage will be given was admitted to MAU episode length hours gt 0 where Ohrs for ED LOS unit_type 87 Data Source Tables DAYS EPISODE EPISODE Limitations e Discharged patients Numerator Sum episode_length_hours e Time period where unit_type 8
177. nition Rules Calculations LHD Alphanumeric Name of the LHD N A MER Alphanumeric Four digit facility code N A Code Facility Alphanumeric Facility name N A Admissions to Displays the number of patients transferred via the Emergency Department to wards identified as Emergency Department Short Stay Number of patients admitted based on admission date via the Emergency Department to wards identified as EDSSU using Ward Type Sub Ward Type e Emergency EMU EDSSU 108003 e Paediatrics EMU EDSSU EDSSU defined date range at a specific facility Note If patient is admitted or transferred to EDSSU multiple times in 1 admission this is only counted once Numeric Unit EDSSU during the defined date EDSSU via ED range at a specific facility de Emergency Department is defined as a Note If patient is admitted or ward flagged as Designated ED and transferred to EDSSU multiple times in Ward Type Sub Ward Type lt gt 1 admission this is only counted once e Emergency EMU EDSSU 108003 e Paediatrics EMU EDSSU 119007 Displays the number of patients Number of patients admitted to or admitted or transferred to wards i ae transferred to based on admission identified as Emergency Department date to the EDSSU wards identified umeric e Emergency EMU EDSSU 108003 e Paediatrics EMU EDSSU 119007 Reports Manual Page 139 of 185 UM
178. nt Info Alphanumeric Indicator as to how the field was completed Indicates how the transfer was flagged as In Progress e No send note the sending facility manually ticked the In Progress checkbox on the Transfer window e System discharged the patient was discharged on the PAS at the sending facility and the system automatically updated the status Date Time Patient Sent DD MM YY hh mm Date time the patient was sent from the requesting facility Date time the e User clicks on the In Progress checkbox or e Patient was discharged from the sending facility via the PAS Patient Arrived Info Alphanumeric Indicator as to how the field was completed Indicates how the transfer was flagged as Completed e No arrival note the receiving facility manually ticked the Completed checkbox e System admitted the patient was admitted by the receiving hospital on the PAS and the system automatically updated the status Date Time Patient Arrived DD MM YY hh mm Date time the patient arrived at the receiving facility Date time the e User clicks on the Completed checkbox or e Patient was admitted into the receiving hospital via the PAS How the transfer request was Indicates where the transfer request was initiated from within the PFP e PFP Manual the transfer was initiated from the Source Alphanumeri
179. nt ward Total number of patients presenting to an Emergency Department and were not admitted x100 Includes ED Visit Type Codes 01 Emergency Presentation 03 Unplanned return visit for continuing condition 11 Disaster Pts KEENE Emergency Department lt 4 hours eee TOE 02 01 Departed treatment completed 02 02 Departed transferred to another hospital 02 03 Departed did not wait 02 04 Departed left at own risk 02 05 Departed for other clinical service location 03 Dead on both arrival and departure Exclude ED Separation Mode Code for Data Entry Error LOS gt 49 days Text Title for data about LOS gt 49 days N A Number of patients whose admission Pts Numeric had a LOS gt 49 days during the given Count of patients with LOS gt 49 days between the 1st and last day of the month month Count of patients with LOS gt 49 days between the 1st and last day of the month where specialty description is e Child amp Adolescent Psychiatry e Institutional Mental Health Services Number of mental health patients og Mental Health a e Liaison Psychiatry Number whose admission had a LOS gt 49 days ia during the given month S Menea AEAN e Mental Health Rehab e Neuropsychiatry e Paediatric Psychiatry e Psychogeriatric Pts Excluding Mirar Number of patients whose admission Count of patients with LOS gt 49 days between the 1st and last day of the month excluding the Mental Health had a
180. nterology Inpatient specialist care 24 72hrs Gynaecology Inpatient specialist care 24 72hrs Gastrointestinal Surgery Inpatient specialist care 24 72hrs Urgent specialist care lt 24hrs Reports Manual Page 101 of 185 Health GOVERNMENT Table 69 Patients IN OUT Specialty Urgency Category Summary Table Data Elements Field Format Definition Rules Calculations Transfer OUT and IN Specialty the patient was Specialty Alphanumeric transferred under i e the N A specialty of the AMO If Urgency Category equals one of e Life Threatening e Urgent Specialist Care lt 24 hours e Inpatient Specialist Care 24 72 hours e Return Transfer of Care Post Specialist Care Then the transfer is included in the count for the given Urgency Category Urgency Category Alphanumeric Urgency Category assigned to the If Urgency Category equals Future Inpatient transfer Specialist Care 24 72 hours then the transfer is included in the count for the Inpatient Specialist Care 24 72 hours Urgency Category If the Urgency Category equals Future Return Transfer of Care Post Specialist Care then the transfer is included in the Count for the Return Transfer of Care Post Specialist Care Urgency Category A count of the number of patients transferred out of or OUT given facility Total Patients IN Numeric into a facility for the given N A Urgency Category per specialty The total number of
181. o 31 10 13 Excludes incomplete transfers To Facility NNN Transfers within time NNN Transfers outside time Table 66 Patient Transfer Times Graph Transfers From To Facility Within Outside Time Graph Data Elements Format Definition Rules Calculations Transfers OUT and IN Count of completed transfers from or to each facility that were within and outside the expiration period for the Urgency Category of the transfer Life Threatening gt 4 hours Urgent Specialist Care lt 24 Classifies the transfers to HOU gt 24 hours n Vertical each facility ay being within Inpatient Specialist Care 24 72h To Facility or or outside the expiration 72h gt ours oe Grouped Bar ours From Facility Chart period for all Urgency Return Transfer of Care Categories gt 1 Business Day Post Specialist Care gt 72 hours based on Estimated Transfer Date Time gt 1 Business Day based on Estimated Transfer Date Time Future Inpatient Specialist Care 24 72 hours Future Return Transfer of Care Post Specialist Care Reports Manual Page 99 of 185 Wis GOVERNMENT Health Figure 48 Patient Transfer Times Graph Transfers From To Facility Within Outside Time Summary Table Layout Patient Transfer Tim Transfers out Calvary Mater Newcastle Cessnock District Hospital Dungog District Hospital John Hunter Hospital Lingard Private Hospital Liverpool Hosp
182. o Can be used to better identify those patients that are a re admission into a MAU DO D O HIE A All users except Connecting Care and Ambulance User DO O Excel He sb Facilities user has approved access to based on the LHD selected 5 Month defaults to 2 months prior to current month 1 Sort Chronologically by Discharge Date O Oraq Reports Manual 2 Sort Alphabetically numerically by Patient ID N A N A Page 152 of 185 Wi GOVERNMENT Health Figure 64 Facility MAU Re admissions Layout Facility MAU Re admissions For the Period 01 04 2014 to 30 04 2014 Patient ID Discharge Date p ereen se Stay Number Re admission Date Prior to Discharge 0000066717 4143074 01 04 2014 MAU 0000148878 4142329 01 04 2014 Inpatient Ward 0000311116 4142650 01 04 2014 Inpatient Ward 0000567274 4136130 01 04 2014 MAU 0000027095 4143129 02 04 2014 Inpatient Ward 0000066194 4110599 02 04 2014 MAU 0000069177 4142085 02 04 2014 inpatient Ward 0000102804 4139480 02 04 2014 MAU 0000178235 4139572 02 04 2014 Inpatient Ward 0000383355 4116965 02 04 2014 Inpatient Ward 0000498003 4142649 02 04 2014 inpatient Ward 0000513852 4140754 02 04 2014 inpatient Ward 0000712238 4142982 02 04 2014 Inpatient Ward 0000000334 4150201 03 04 2014 MAU 0000104585 4143047 03 04 2014 Inpatient Ward 0000298849 4138790 03 04 2014 inpatient Ward 0000506955 4152122 03 04 2014 MAU 0000744158 4143077 03 04 2014 inpatient Ward 0000888671 4150226 0
183. o mae ee John Hunter Inpatient specialist Cardiology 13 11 13 15 11 13 14 11 13 Hospital care 24 72hrs Medical 14 37 14 30 11 21 John Hunter Urgent specialist care Cardiology 15 11 13 15 11 13 15 11 13 Patient transferred to another Hospital lt 24hrs Procedural 15 54 17 00 21 59 facility Others Duplicate Data Entry Others Error Others To Transfer Estimated Transfer Specialty Request Transfer Cancel Cancel Reason Cancel Notes Time Time Time Urgency Patient ID Patient Name Facility From Category John Hunter Inpatient specialist General 31 05 13 31 05 13 02 06 13 Hospital care 24 72hrs Medicine 16 45 16 40 12 24 Return Transfer of Care Post Specialist Care Patient discharged General 24 07 13 25107113 25 07 13 Patient transferred to another Medicine 14 38 10 30 11 03 facility Lake Macquarie Private Hospital Figure 42 Patient Transfer Cancellations Layout Excel Patient Transfer Canc For the Period 1 08 13 to 29 11 13 Urgenc ome Estimated ULL Patient ID Surname FirstName Facility From Facility To a Specialty Request Cancel Cancel Reason Cancel Notes Category Ses Transfer Time a John Hunter Newcastle Private Inpatient specialist Rehabilitatio Request for transfer not Hospital Hospital care 24 72hrs nMedicine 1 07 13 08 52 12 07 13 08 50 08 08 13 13 55 appropriate Retum Transfer of ae Maitland Hospital CarePost Orthopaedic Hospital Specialist Care 24 07 13 14 50 26 07
184. o the MAU e Total number of admissions to the PECC e Average Clinician Defined Estimated date of Discharge EDD e Average Expired EDD Report De 5 e The total number of patients discharged e The total number of patients discharged on weekdays e The total number of patients discharged on the weekend e Week Day Discharge Rate e Weekend Discharge Rate e Average ED Accessible Bed Occupancy e The total number of patients admitted to Hospital in the Home HITH e The total number of patients discharged from a Transit Lounge e The total number of patients who were discharged from a Transit Lounge via ED e The of patients who were discharged from a Transit Lounge via ED as a proportion of all Transit Lounge discharges Allows Whole of Hospital WoH Team members inclusive of Ministry of Health and i relevant LHD Executives to monitor progress at WOH sites Repo DELEA PFP Acce MoH User Report Forma Excel only Facilities The facilities the user wants to run the report for Facilities available for selection depends on the user s access rights From Date default Today The start date for the report To Date default Today The end date for the report ort Orde Alphabetically by Facility NE N A N A Refer to 9 5 Whole of Hospital Snapshot for details of the report layout and data elements Reports Manual Page 146 of 185 Wi GOVERNMENT Health 10 0 MEDICAL ASSESSMENT UNIT REPORTS 10 1 Medical Assessment U
185. of patients admitted based on admission date via the Emergency Department to wards identified as MAU using Ward Type and Sub Ward Type e Aged Care Medical Assessment Displays the number of patients Unit 101004 admitted or transferred via the 2 Medical Medical Assessment Emergency Department to wards Unit 114009 ye e Paediatrics Medical Assessment identified as Medical Assessment Unit Admissions to Unit 119012 Numeric MAU during the defined date range MAU via ED at a specific facility Note If patient is admitted or transferred to MAU multiple times in 1 admission this is only counted once Emergency Department is defined as a ward flagged as Designated ED and Ward Type Sub Ward Type lt gt e Aged Care Medical Assessment Unit 101004 e Medical Medical Assessment Unit 114009 e Paediatrics Medical Assessment Unit 119012 Reports Manual Page 141 of 185 UM sommer Health Field Format Definition Rules Calculations Count of patients admitted or transferred during the reporting period to wards identified as MAU using Ward Type and Sub Ward Type Number of patients admitted or e Aged Care Medical Assessment transferred to wards identified as Unit 101004 Admissions to Medical Assessment Unit MAU e Medical Medical Assessment Numeric MAU during the defined date range ata Unit 114009 specific facility e Paediatrics Medical Asses
186. ollowing the Category e Discharge Date for the patient s admission g ocr e WFW reason Closed Date e No date as WFW reason is still open Numerator Number of bed days consumed for Displays the capacity equivalent f each top 3 reason per category percentage in terms of the number of i Capacity Denominator Sum of daily average of number of Numeric bed days for each of the top 3 WFW Equivalent 2 available beds across the LHD Daily average is reasons per category Display to 1 ae j calculated as sum of hourly snapshots divided by decimal point 24 Reports Manual Page 135 of 185 GOVERNMENT H ea l t h 9 4 Facility Operational Summary Table 84 Facility Operational Summary Overview Repo e Facility Operational Summary Provides a snapshot of operations for a specific facility using the Patient Flow Portal by reporting information about e NEAT e LOS gt 49 Days e LOS gt 99 Days e Total Occupancy and ED Accessible Occupancy Report De O e Estimated Date of Discharge Clinician Defined and Expired EDD s e Waiting for What Delay Reasons e Inter LHD Patient Transfers The report will display either e One calendar month of data e Upto 12 months of aggregated data based on financial year as selected by user e Upto 12 months of aggregated data based on calendar year as selected by user Allows MoH and LHD Executives to monitor the operations of their LHD s and po
187. ology 2 2 If the specialty a patient is transferred into is the same as their last specialty due to a change in AMO this is not counted as a transfer ASU Acute Surgery 45 53 into or out of a Specialty CAR Cardiology CDS Cardiac Surgery CTS Thoracic Surgery DEN Oral Surgery DMT Dermatology END Endocrinology ENS Endoscopy ENT Ear Nose and Throat EYE Ophthalmology GE Gastroenterology GER Geriatrics GES General Surgery GONC Gynaecology Oncology GYN Gynaecology IMM Immunology MED Medical Service NEP Nephrology NEU Neurology NIC Neonatal Intensive Care NRS Neurosurgery OBS Obstetrics Table 38 Specialty Activity Summary table Data Elements Format Definition Rules Calculations Displays the Specialty Description unless Specialty Alphanumeric Specialty Description not available then the Specialty Code displays Date range for the report Activity DD MM YYYY Displays as DD MM YYYY DD MM NYYY Displays on Summary view only Count of patients admitted or transferred into the specialty in the defined date Number of patients admitted or range INTO Specialty Numeric transferred into the specialty within the iven data range F g g Excludes patients where New specialty Current specialty Count of patients transferred or discharged out of the specialty in the defined date range Number of patients transferred or OUT Specialt
188. on data is calculated based on 28 days since the patient was discharged from their previous admission where they visited a MAU As such if this report is generated for last 28 days prior to today the readmission data will not be up to date Can be used to obtain an overview of the operations and performance of Medical Assessment Units in a facility HIE All users except Ambulance User PDF in portrait display default Excel tables only Facilities user has approved access to Date From Date To Facility name in alphabetical order N A N A Page 154 of 185 NG NSW Health Figure 65 Facility MAU Summary Layout Facility MAU Summary For the period 01 02 2014 to 28 02 2014 Re Avg LOS of e Re Avg total MAU en ANER Patients da Patients viner admission hours in ED Avg LOS in patients MAU home Separations patients transferred from MAU discharged home from Admissions rate of MAU for all MAU MAU hrs transferred or MAU from MAU aged 65 from MAU to within 48 home from MAU within direct to home patients to a ward ward home hrs ward hrs MAU 48 hrs MAU ae days discharges Facility 62 34 0 72 6 1 22 7 8 9 For the period 01 02 2014 to 28 02 2014 08 00 16 00 Re Re awm Oai Patients Patients Patients Patients admission Separations transferred x discharged MAU_home patients transferred from MAU discharged home from Admissions
189. onsults Consults Consults Consults Consults Diagnostics Treatment Diagnostics Treatment Diagnostics Treatment Diagnostics Treatment Diagnostics Treatment Diagnostics Treatment Diagnostics Treatment Diagnostics Treatment Diagnostics Treatment Diagnostics Treatment Diagnostics Treatment Diagnostics Treatment Diagnostics Treatment Diagnostics Treatment Diagnostics Treatment Diagnostics Treatment Primary Delay Secondary Delay Reason Physiotherapist Rehabilitation Rehabilitation Rehabilitation Other Medicine Operating Theatre Operating Theatre Operating Theatre Operating Theatre Other Optional Text Await review Med Team and Gynae team awaiting CABG no date as yet for OT awaiting cranioplasty Awaits further surgery Stage 2 revision ongoing wound management Acute Acute Await Rheumatology review Acute awaiting improvement services can not assist untill independent with nocte care Acute Acute Acute Admissio n Date 12 11 13 06 09 13 01 11 13 22 10 13 13 10 13 28 10 13 06 11 13 211143 21411113 14 05 13 23 09 13 21 10 13 06 11 13 31 10 13 03 11 13 14 10 13 18 11 13 11 1113 174143 071143 20 11 13 WFW Start Date 25 11 13 12 11 13 26 1113 26 11 13 08 11 13 06 11 13 07 11 13 22 11 13 22 11 13 24 07 13 01 10 13 07 14
190. oo oo oo oo o om o o o ZBR Reports Manual Page 172 of 185 UM Health Figure 76 NSW Health MAU Performance Trend Summary Graph Layout A1 Principal referral Patient Flow Portal Medical Assessment Unit Report Page 5 of 17 Average total hours in ED for all MAU Patients EG A Indicator Target WH _ NSW Health Reports Manual Page 173 of 185 GOVERNMENT Health 10 11 NSW Health MAU Process Trend Summary Table 98 NSW Health MAU Process Trend Summary Overview Reports Manual NSW Health MAU Process Trend Summary Provides process indicator information about Medical Assessment Units as a trend for the period of 1 to 12 months as defined by the user e Separations from MAU e Average LOS in MAU for patient aged 65 Hours e patients transferred from MAU within 48 hours e patients discharged home from MAU e patients discharged home from MAU within 48 hours e patients transferred from MAU to ward e Admissions direct to MAU e Re admission rate of MAU home discharges ONLY e MAU NEAT The data is presented in both tabular and graphical format and summarised at state level as well comparing facilities based on peer groups The number of graphs printed will be determined by the number of different peer groups the facilities are assigned to Note Readmission data is calculated based on 28 days since the patient was discharged from their previous admission whe
191. ool Data Definitions spreadsheet available on the Patient Flow Systems website Page 27 of 185 Wis NSW Health Figure 9 Prediction Data Extract Layout Prediction Data Extract For the Period 01 10 2013 to 31 10 2013 02 10 2013 03 10 2013 04 10 2013 08 10 2013 09 10 2013 10 10 2013 11 10 2013 12 10 2013 16 10 2013 17 10 2013 18 10 2013 Actual Actual Admissions to ED 23 23 24 27 14 14 25 20 23 19 21 Actual Actual Admissions to EMU 20 23 30 32 22 22 30 23 19 24 25 23 Actual Actual Admissions via ED 55 63 69 69 70 27 69 49 59 59 60 Actual Actual Beds Required 125 91 54 30 76 99 Actual Actual Booked Admissions 45 49 48 33 8 16 19 43 13 40 44 32 Actual Actual Direct Admissions 14 20 28 17 8 16 16 13 12 16 29 16 Actual Actual Discharges 93 90 71 58 31 77 36 89 Actual Actual EDO Actual Actual Medical Overnight 2 10 4 Actual Actual Surgical Overnight 18 20 12 Actual All ED Admissions 93 94 81 Actual EDO 23hr patients requiring an inpatient bed Prediction Available ED accessible beds Prediction Bed Demand Status Prediction Booked EDO Prediction Booked Medical Overnight Prediction Booked Overnight admissions Prediction Booked Surgical Overnight Prediction EDD Prediction Empty Available ED accessible beds at 7am Prediction Ideal Buffer Beds Prediction Planned Booked Admissions Prediction Predicted admissions via ED Prediction Predicted Beds Available Prediction Predicted Beds Required Prediction Predicted
192. or ALL Wards Groups at the selected facility or facilities Ward Type Activity A breakdown of patient activity by each Ward Type displays for ALL Wards Types at the selected facility or facilities Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights Snapshot time Daily Weekly Monthly 1 Sort Chronologically by Date 2 Sort Alphabetically by Ward Code Ward Group and Ward Type within the corresponding sub report N A N A Page 42 of 185 NSW Health Figure 16 Ward Activity Snapshot Ward Activity Layout Ward Activity Snapshot Daily Snapshot for the Period 01 10 2013 to 30 10 2 Ward Activity Ward Code and Description 01 10 13 02 10 13 03 10 13 04 10 13 05 10 13 06 10 13 07 10 13 08 10 13 09 10 13 10 10 13 11 10 13 IN IN OUT IN OUT IN IN OUT OUT IN IN IN IN OUT 3E 3E ED accessible 4 7 7 4 7 6 2 1 2 6 4 4 4 3EANX 3E Annex 4E 4E Surgical ED accessible AW 4W ED accessible B4 B4 ED accessible B7 B7 ED accessible own 9 B8 B8 ED accessible BU Birthing Unit C2 C2 C3 C3 ED accessible ononn wer on No N HO We DH N ou HN C4 C4 ED accessible C6 C6 C7 C7 ED accessible CCUWH Coronary Care Unit ED accessible CDC Cardiac Diagnostic Centre CDUW Clinical Decision Unit Figure 17 Ward Activity Snapshot Wa
193. ort is generated for last 28 days prior to today the readmission data will not be up to date Can be used to obtain an overview of the operations and performance of Medical Assessment Units across NSW Health HIE All users except Ambulance User and Connecting Care User PDF in portrait display Excel tables only N A Order within Results Tables and Trend Line Graphs is the time period in chronological order N A N A Page 177 of 185 NSW GOVERNMENT Health Figure 79 NSW Health MAU FY Summary Layout NSW Health MAU Financial Year Summary NSW Health 2008 2009 2010 2011 I 2012 I 2013 I SUM g Performance Indicators 2009 2010 2011 2012 2013 2014 AVG 1 Avg total hours in ED for all MAU patients 2 Avg LOS in MAU hrs 57 1 50 7 51 0 52 0 46 9 42 3 3 Avg LOS of MAU patients transferred to a ward days 11 6 10 7 10 3 10 4 98 92 4 Re admission rates of MAU home or MAU ward home discharges 11 3 11 1 10 8 11 2 113 10 4 Process Indicators 5 Separations from MAU 28304 42439 48732 50485 52513 47826 Avg LOS in MAU for patients aged 65 hrs 61 1 54 6 55 4 56 6 51 1 45 9 Patients transferred from MAU to ward 44 4 49 6 49 2 46 9 49 3 47 8 Patients transferred from MAU within 48 hrs 60 6 60 9 60 9 64 7 68 1 Patients discharged home from MAU i 48 5 50 1 i 49 0 Patients discharged home from MAU within 48 hrs 63 5 63 9 f 71 5 Admissions direct to MAU i f 6 2 6 6
194. our which had the highest Total Occupancy and highest ED Accessible bed occupancy on a given day e ED accessible beds are beds in Wards that have been flagged as ED accessible in the Bed Management Admin module of PFP e Requires the Schedule in Bed Board Bed Management to be set up correctly e Excludes patients in Virtual beds Page 23 of 185 7 4 y NSW Health Figure 7 Hospital Occupancy Layout PDF Hospital Occupancy For the Period 09 10 2013 to 16 10 2013 Snapshot Time Avg 0 00 1 00 2 00 3 00 4 00 5 00 6 00 7 00 8 00 9 00 10 00 11 00 12 00 13 00 14 00 15 00 16 00 17 00 18 00 19 00 20 00 21 00 22 00 23 00 Total Capacity 1099 1099 1099 1099 1099 1099 1099 1099 1099 1099 1099 1099 1099 1099 1099 1099 1099 1099 1099 1099 1099 1099 Total Available Beds 910 910 910 910 943 987 1042 1042 1042 1030 1019 996 970 910 985 Total Occupied 795 795 795 795 800 842 862 879 900 819 813 812 807 09 10 2013 Total Occupancy 87 4 848 i 3 82 7 84 4 j I 795 798 83 7 887 Wednesday Total ED Accesible Available Beds 525 525 525 525 525 Total ED Accesible Beds Occupied 467 475 480 ED Accesible Beds Occupancy 89 905 Surge Beds Occupied 0 0 Total Capacity Total Available Beds Total Occupied Date Day Indicator 10 10 2013 Total Occupancy Thursday Total ED Accesible Available Beds Total ED Accesible Beds Occupied ED Accesible Beds Occupancy Surge Beds Occupied Total Capacity Total
195. ports Manual Page 25 of 185 Ws GOVERNMENT Health Table 11 Hospital Occupancy Data Elements Definition Rules Calculations Date DD MM YYYY The date the rows of data apply to N A Snapshot Time hh 00 The hour applicable to the counts and N A occupancy Total Capacit N rieri Count of all open unavailable and closed Sum of Available Unavailable Surge PN beds in all wards at the given hour Closed beds in all wards Total Available PEN Number of Available beds in all wards at Count of available beds in all wards Beds the given hour Number of occupied Available beds in all Count of available beds in all wards Total Occupied Numeric i wards at the given hour occupied by a patient Total Occupancy Numeric 1 Occupancy of Available beds in all Total Occupied Total Available Beds x Accessible Bed Occupancy decimal place Accessible wards at the given hour decimal place wards at the given hour 100 Total ED Number of Available beds in ED Count of available beds in ED Accessible Accessible Numeric i Accessible wards at the given hour wards Available Beds Total ED i Number of occupied Available beds in ED Count of available beds in ED Accessible Accessible Beds Numeric 3 Accessible wards at the given hour wards occupied by a patient Occupied Total ED Numeric 1 Occupancy of Available beds in ED Total ED Accessible
196. predicting the unplanned admissions via ED by each clinical specialty This is achieved by providing granular data by clinical specialty so that patient flow managers and department heads can use in a user friendly easily accessible format to communicate clinical specialty patient flow trends for the next 14 days PFP All Users except Ambulance Users Excel only Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights 1 Sort Alphabetically by Specialty 2 Sort Chronologically Date N A N A Figure 24 Predicted Admissions via ED by Specialty Layout Predicted Admissions via ED by Specialty Snapshot 19 11 13 14 20 Predicted Admissions via ED by Specialty Acute Surgical Unit Cardiology Dentistry Ear Nose amp Throat Surgery Endocrinology Fasciomaxillary Surgery Gastroenterology Geriatrics Gynaecology Haematology Medical Oncology Medicine Neurology Obstetrics Reports Manual Indicator PP 1 wn 3 2 3 aj g 4 11 2013 25 11 2013 26 11 2013 da N N NN gt gt gt NOON NNa aaa owa 5 NWw NnN lt 200N N Na VNG Nass 4s 09NNN NNSNS245 0 28 oh N Page 56 of 185 Wis GOVERNMENT Health Table 36 Predicted Admissions via ED by Specialty Data Elements Definition Rules Calculations Specialty Alphanumeric Speci
197. r left to right e Weekly Up to 12 calendar weeks of weekly snapshots per graph Displays the date range for the week e Monthly Up to 12 calendar months of daily snapshots per graph e Displays the month and year values from 0 100 ae Percentage Line displays for 95 target on Sub report N A 3 only The of patients with LOS gt 24hrs amp Plot area Line clinician defined EDD as a line graph with N A data points for each day Coloured line Line colour used for each Ward or Ward Legend Group and the Ward code and description N A with text or Ward Group name Reports Manual Page 38 of 185 Health 3 2 Ward Activity GOVERNMENT Table 21 Ward Activity Overview Repo De O Repo Repo Data 50 Repo O D o pO Pro D o O O o Repo O Ol cel Reports Manual Ward Activity Provides summarised count of patient activity for each ward ward type and ward group within a facility based on a user defined date range Allows Patient Flow Managers Clinical Managers Nurse Unit Mangers and Hospital Executives to monitor activity at a ward level to better understand and plan for future activity PFP All Users except Ambulance User PDF only Produces three sub reports Ward Activity A breakdown of patient activity by each ward displays for ALL wards at the selected facility or facilities Ward Group Activity A breakdown of patient activity by each Ward Group display
198. ransfer Time to Transfer Completed Time gt 1 business day e Completed Time was between the first and last day of month Count of patient transfers out of the selected LHD with e Urgency Return Transfer of Care Post Specialist Care gt 1 business day e Urgency Future Return Transfer of Care Post Specialist Care gt 1 business day e Completed Time was between the first and last day of month x 100 Breached All Transfers Transfers IN Numeric Percentage of completed patient transfers into the given LHD that breached each urgency category between the first and last day of the month Urgency Life Threatening Count of patient transfers into the selected LHD with e Urgency Life Threatening e Request Transfer Time to Transfer Completed Time gt 4 hours e Completed Time was between the first and last day of month Count of patient transfers out of the selected LHD with e Urgency Life Threatening e Completed Time was between the first and last day of month x 100 Reports Manual Page 126 of 185 7 Health GOVERNMENT Format Definition Rules Calculations Urgency Urgent Specialist Care lt 24 hours Count of patient transfers into the selected LHD with e Urgency Urgent Specialist Care lt 24 hours e Request Transfer Time to Transfer Completed Time gt 24 hours e Completed Time was between the first and last day of month Count of patient transfers out of th
199. ransfers OUT 100 0 Transfers IN Transfers OUT 16 7 37 8 Transfers IN 0 0 Transfers OUT 35 5 198 8 Transfers IN 250 123 8 Transfers OUT 50 0 194 0 Transfers IN 40 0 35 4 Life threatening Urgent specialist care lt 24hrs Inpatient specialist care 24 72hrs Return Transfer of Care Post Specialist Care Figure 61 LHD Operational Summary Layout page 2 Waiting for What Summary Top 3 Reasons per Category Orthopaedics 116 Consults Rehabilitation 24 70 0 2 Aged Care 15 54 0 2 CT 17 63 02 Diagnostics Treatment Other 29 61 02 AMO Team Review 27 52 02 Other 11 28 0 1 Discharge Process Discharge Equipment 8 0 0 Family Carer Conference 5 7 0 0 Residential Aged Care Service 0 8 Out of Hospital Referral ACAT Assessment 06 Other 03 Other 23 Transfer Transport IHT Waiting for Bed Accepting Facility 1 0 IWT Ward Bed 07 Reports Manual Page 134 of 185 UM GOVERNMENT Health Figure 62 LHD Operational Summary Layout page 3 Local Health District Inter LHD Transfers OUT and IN Transfers Transfer OUT Transfer IN Transfer OUT Transfer IN Transfer OUT Transfer IN Transfer OUT Transfer IN Transfer OUT Transfer IN Transfer OUT Transfer IN Transfer OUT Transfer IN Transfer OUT Transfer IN Transfer OUT Transfer IN Transfer OUT Transfer IN Life Threatening lt 4 hours 8 x8 8 8 2 2 2 oa o oa Urgent Specialist Care lt 24 hours en Speco 2472 or Ra eae hans
200. rd Group Layout Ward Activity Snapshot Daily Snapshot for the Period 01 10 2013 to 30 10 2013 Ward Group Activity A ity Ward Group 01 10 13 02 10 13 03 10 13 04 10 13 05 10 13 06 10 13 07 10 13 08 10 13 09 10 13 10 10 13 11 10 13 IN OUT IN OUT IN OUT IN OUT IN IN IN OUT IN OUT OUT IN OUT IN Medical ward 80 58 56 64 69 72 86 46 29 30 24 62 72 65 62 71 79 Obstetric ward 17 19 15 25 21 26 27 13 5 16 16 23 25 16 18 14 22 Paediatric ward 13 12 12 16 14 16 18 6 4 3 17 5 14 14 10 22 Surgical Wards 25 22 20 30 33 25 30 28 27 27 31 32 26 22 25 24 Figure 18 Ward Activity Snapshot Ward Type Layout Ward Activity Snapshot Daily Snapshot for the Period 01 10 2013 to 30 10 2013 Ward Type Activity Activity Ward Type 01 10 13 02 10 13 03 10 13 04 10 13 05 10 13 06 10 13 07 10 13 08 10 13 09 10 13 10 10 13 11 10 13 IN OUT IN OUT IN OUT IN IN IN OUT IN OUT IN OUT IN IN OUT Aged Care 6 6 4 4 3 4 2 2 2 2 3 4 T 3 6 4 Emergency 96 98 97 95 96 96 84 91 97 102 118 Hospital In The Home 2 2 5 4 5 4 3 2 5 Medical 93 85 82 72 76 93 Mental Health 2 2 F 8 2 Neurosciences 5 2 6 4 3 Obstetrics 18 26 17 16 22 Paediatrics 13 16 9 22 Rehabilitation 5 8 5 5 Surgery 25 26 40 28 Reports Manual Page 43 of 185 Wis GOVERNMENT Health Table 24 Ward Activity Snapshot Data Elements Definition Rules Calculations The Ward code and Description within ne Alphanumeric the selected facility N A Ward
201. re they visited a MAU As such if this report is generated for last 28 days prior to today the readmission data will not be up to date Can be used to obtain an overview of the performance of Medical Assessment Units across NSW Health HIE All users except Ambulance User and Connecting Care User PDF in portrait display Excel tables only Number of months Between 1 12 Results Table 1 sort Peer Group in alphabetical order 2 sort Facility in alphabetical order Trend Line Graph Time period in chronological order from left to right N A N A Page 174 of 185 NSW GOVERNMENT Health Figure 77 NSW Health MAU Process Trend Summary Table Layout NSW Health MAU Process Trend Summary For the Period Jul 2013 to Dec 2013 NSW Health Separations from MAU Facility peer Group es Hospital Hospital Hospital Hospital Reports Manual Hospital Hospital Hospital Hospital A1 A1 A1 A1 A1 A1 A1 A1 A1 A1 A1 A1 A1 A2 BRB o N 139 198 167 Aug 13 144 231 165 235 306 185 285 278 134 280 100 240 206 130 171 55 101 112 126 Sep 13 143 187 162 301 246 184 219 252 118 257 88 245 192 100 144 39 93 100 113 107 133 51 83 154 161 64 119 111 219 Oct 13 162 211 174 297 280 178 261 277 135 262 110 252 200 Nov 13 157 203 Dec 13 205 152 357 253 219 29
202. ree text information about the bed required Information entered in the Bed Type Required field on the Transfer request window Speciality code Alphanumeric Code of the speciality the patient was transferred under N A Specialty Alphanumeric Description of the speciality the patient was transferred under N A Transfer note Alphanumeric Free text information about the transfer Information entered in the Transfer Notes field on the Transfer request window Isolation Yes or No Flag to indicate if the patient N A Requirement needs to be isolated Estimated DD MM YY Date time the patient is N A Transfer Time hh mm estimated to be discharged Request Accepted Info Alphanumeric Indicator as to how the confirmed field was completed Indicates how the transfer was flagged as Confirmed no accept note the receiving facility manually ticked the Confirmed checkbox Date Time Request DD MM YY Pate sim me bed is contirmed Date time the user clicked on the Confirmed checkbox hh mm by the receiving hospital Accepted Ward the patient has been Ward Allocated Alphanumeric allocated to at the receiving N A hospital Bed the patient has been Bed Allocated Alphanumeric allocated at the receiving N A hospital Date Time Bed Allocated DD MM YY hh mm Date time the bed was allocated Not applicable in the PFP Patient Se
203. ric Number of direct ward admission records in the specified date range Count of records Reports Manual Page 116 of 185 GOVERNMENT H ea l t h 9 0 EXECUTIVE REPORTS 9 1 LHD Operational Summary Trend Table 79 LHD Operational Summary Trend Overview Repo e LHD Operational Summary Provides a snapshot of operations for a specific LHD using the Patient Flow Portal by reporting information about e NEAT e LOS gt 49 Days ma s e LOS gt 99 Days ps e Total Occupancy and ED Accessible Occupancy e Estimated Date of Discharge Clinician Defined and Expired EDD s e Waiting for What Delay Reasons e Inter LHD Patient Transfers The report will display up to 12 months of trend data as selected by the user Allows MoH and LHD Executives to monitor the operations of their LHD s and oy potentially identify areas of improvement Report D O PFP and EDWARD for NEAT Acce LHD User and MoH User DO D PDF only Report Promp LHD The LHD s the user wants to run the report for LHDs available for selection dato e depends on the user s access rights Snapshot Month Alphabetically by LHD s W4W 1 Sort Alphabetically by W4W Category 2 Sort By W4W reason bed days highest to lowest IN N A 3 e E N A Figure 57 LHD Operational Summary Trend Layout page 1 LHD Operational Summary Trend For Period 01 05 2013 to 31 10 2013 Operational Indicator May 13 Jun 13
204. rs ward MAU days discharges ONLY 69 415 71 6 5 29 2 83 For the period 01 02 2014 to 28 02 2014 08 00 16 00 Re Avg total MAU sr om Patients Flemmen Patients pairon hours in ED Avg LOS in patients MAU home Separations ationts transferred from MAU discharged tt ons for all MAU MAU hrs transferred gt from MAU p z direct to home ama MAU MAU within i from MAU to t home from patients to a ward or MAU aged 65 within 48 MAU discharges ward home hrs hrs 48 hrs days discharges ONLY Avg LOS of Re admission Admissions rate of MAU 52 39 0 46 49 31 8 20 5 For the period 01 02 2014 to 28 02 2014 16 00 00 00 Re Avg LOS of admission Avg LOS in Avg total MAU en l hours in ED Avg LOS in patients MAU home Separations patients from MAU discharged home from for all MAU MAU hrs transferred from MAU from MAU to ge home from x direct to home patients award or MAU aged 65 within 48 MAU within MAU discharges ward MAU days discharges ONLY Re admission Admissions rate of MAU Patients Patients Patients Patients discharged MAU for transferred transferred ward home hrs hrs 48 hrs Patient Flow Portal Medical Assessment Unit Report Page 1 of 3 NSW Health GOVERNMENT Reports Manual Page 162 of 185 GOVERNMENT Health 10 7 LHD MAU Snapshot Summary Table 94 LHD MAU Snapshot Summary Overview LHD MAU Snapshot Summary Provides
205. rs Surgery Inpatient Danica ICU HDU ASURG BSURG specialist care Urology 26 11 13 08 08 26 11 13 08 05 24 72hrs Inpatient Miriam ICU HDU ASURG BSURG specialist care Gastroenterology 26 11 13 13 47 26 11 13 11 40 24 72hrs Inpatient Carmel ICU HDU ASURG ICU HDU specialist care Gastroenterology 26 11 13 08 12 26 11 13 00 00 24 72hrs Inpatient Ella ICU HDU GENMED Resp specialist care General Medicine 11 11 13 12 03 11 11 13 00 00 24 72hrs Inpatient Italo ICU HDU Neuro Resp specialist care Neurology 11 11 13 11 55 11 11 13 10 50 24 72hrs Figure 55 Patient Open Inter Ward Transfers Layout Excel Patient Open Inter Ward Transfers Snapshot 29 11 13 01 34 Patient ID ne First Name Ward From Ward From Ward To Ward To Current Current Ward EE Specialty Transfer Request Estimated Isolation Code Description Code Description Ward Code Description ve goy p Time Transfer Time Req 26 11 13 10 14 26 11 13 10 10 Bed Info Transfer Note Inpatient specialist Orthopaedic care 24 72hrs Surgery psp nn Urology 26 11 13 08 08 26 11 13 08 05 Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs Inpatient specialist care 24 72hrs ICUHDU ICU HDU ASURG Surgical A ICU HDU ICU HDU ICUHDU ICU HDU ASURG Surgical A BSURG Surgical B ICUHDU ICU HDU ASURG Surgical A BSURG Surgical B Gastroenterology 26 11 13 13 47 26 11 13 11 40 ICUHDU ICU HDU ASURG Surgical A ICUHDU ICU HDU Gastroenterology 26
206. s Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Urgent specialist care lt 24hrs Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Page 109 of 185 01 10 13 08 25 01 10 13 08 25 01 10 13 08 25 01 10 13 08 25 02 10 13 08 20 02 10 13 08 20 02 10 13 08 20 02 10 13 08 25 02 10 13 08 25 02 10 13 08 25 02 10 13 08 25 02 10 13 08 25 02 10 13 08 25 03 10 13 08 45 03 10 13 08 45 03 10 13 08 45 03 10 13 08 50 07 10 13 11 00 07 10 13 11 00 08 10 13 10 10
207. s amp Clinician Defined EDD Avg Pts with LOS gt 24hrs amp Clinician Defined EDD Avg No Pts with LOS gt 24hrs Avg No Pts with LOS gt 24hrs amp Clinician Defined EDD Avg Pts with LOS gt 24hrs amp Clinician Defined EDD Avg No Pts with LOS gt 24hrs Avg No Pts with LOS gt 24hrs amp Clinician Defined EDD Avg Pts with LOS gt 24hrs amp Clinician Defined EDD Avg No Pts with LOS gt 24hrs Avg No Pts with LOS gt 24hrs amp Clinician Defined EDD Avg Pts with LOS gt 24hrs amp Clinician Defined EDD Reports Manual Page 18 of 185 Health Figure 5 Clinician Defined EDD compliance by Facility All facilities Ave Compliance comparison graph Layout GOVERNMENT Clinician Defined EDD Compliance by Facility Daily Snapshot for the Period 04 09 2013 to 19 09 2013 Avg Pts with LOS gt 24hrs amp Clinician Defined EDD See mann II 3 2 F 2 i gt S ac ke Ne ke gt D QN 5 8 2 A amp 3 S Auburn Hospital Blacktown Hospital Concord Hospital Gosford Hospital John Hunter Hospital Westmead Hospital all units he tg Portal NY ET NSW OOS NE Reports Manual Page 19 of 185 Wis GOVERNMENT Health Table 6 Clinician Defined EDD Compliance by Facility Summary table Data Elements Format Definition Rules Calculations Displays differently depending on whet
208. s Estimated Discharge PDF and Excel N A Date Specialty Alphanumeric Patient s specialty PDF and Excel N A Ward Code Alphanumeric Ward Code patient is PDF and Excel N A currently admitted into Ward i Alphanumeric Ward Description patient is Excel N A Description currently admitted into Med Officer Alphanumeric Patient s AMO PDF and Excel N A Last Updated DD MM NY Date the WFW reason was Excel N A Date last updated Patient s Financial Status which is based on their Financial Status Alphanumeric financial class e g Public Excel N A Private DVA Compensable etc Financial Patient s Financial n Alphanumeric Description associated with Excel N A Description Sia their financial class Logon id of the person who Last Updated By Alphanumeric last updated the WFW Excel N A reason Facility ID Alphanumeric Facility code RON EIE Excel N A Reports Manual Page 70 of 185 GOVERNMENT Health 5 3 Waiting for What Bed Days Table 45 Waiting for What Bed Days overview Reports Manual Waiting for What Bed Days Pareto Chart of reasons consuming the most bed days at a specific facility Assist with identifying the Wait reasons that impact the most on the available bed days Provides an evidence base for prioritising areas for process redesign to reduce delays and improve patient flow PFP All Users except Ambulance Users PDF Produces two sub reports Bed Days Us
209. s for ALL Wards Groups at the selected facility or facilities Ward Type Activity A breakdown of patient activity by each Ward Type displays for ALL Wards Types at the selected facility or facilities Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights From Date default Today The start date for the report To Date default Today The end date for the report Alphabetically by Ward Code Ward Group and Ward Type within the corresponding sub report N A N A Page 39 of 185 Health GOVERNMENT Figure 13 Ward Activity Layout Ward Activity For the Period 01 08 2013 to 31 10 2013 Ward Activity 01 08 2013 31 10 2013 Ward Code and Description Total Transfers Transfers OUT 3E 3E ED accessible 371 370 741 3EANX 3E Annex 50 50 100 4E 4E Surgical ED accessible 1063 4W 4W ED accessible 789 B4 B4 ED accessible 987 B7 B7 ED accessible 542 B8 B8 ED accessible 864 BU Birthing Unit 1466 C2 C2 C3 C3 ED accessible C4 C4 ED accessible C6 C6 C7 C7 ED accessible CCUWH Coronary Care Unit ED accessible CDC Cardiac Diagnostic Centre CDUW Clinical Decision Unit CPWH Chest Pain Assessment Unit ED accessible Figure 14 Ward Activity Ward Group Layout Ward Activity For the Period 01 08 2013 to 31 10 2013 01 08 2013 31 10 20
210. s the Predictive Tool is by facility Reports Manual Page 57 of 185 Health GOVERNMENT 4 3 Specialty Activity Table 37 Specialty Activity Overview Repo De O Repo Repo Data 50 Repo O Repo Pro 0 O O O o Repo O Orde Reports Manual Specialty Activity Provides a summary of the count of patient activity for each specialty within a facility based on a user defined date range Allows Patient Flow Managers Clinical Managers Medical Officers and Hospital Executives to monitor activity via Specialty to better understand and plan for future activity PFP All Users except Ambulance Users PDF default and Excel Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights From Date default Today The start date for the report To Date default Today The end date for the report Alphabetically by Specialty N A Excludes patients where New specialty Current specialty Page 58 of 185 UM GOVERNMENT Health Figure 25 Specialty Activity Summary Layout Specialty Activity For the Period 10 11 2013 to 19 11 2013 Includes Patient Transfers amp Admissions into Specialty INTO Specialty E 10 11 13 19 11 13 Specialty INTO OUT Includes Patient Transfers amp Specialty Specialty OUT Specialty Discharges out of Specialty ANA Anaesthesi
211. s within 28 days of MAU Home or MAU ward home discharges Separations from MAU Average LOS in MAU for patient aged 65 Hours patients transferred from MAU within 48 hours patients discharged home from MAU patients discharged home from MAU within 48 hours MAU patients transferred to ward Admissions direct to MAU Re admission rate of MAU home discharges ONLY MAU NEAT The data is presented in both tabular and graphical format Trend line graphs are displayed for the 4 performance indicators Note Readmission data is calculated based on 28 days since the patient was discharged from their previous admission where they visited a MAU As such if this report is generated for last 28 days prior to today the readmission data will not be up to date Can be used to obtain an overview of the operations and performance of Medical Assessment Units in a facility HIE All users except Ambulance User PDF in landscape display default Excel tables only Daily snapshot up to 31 calendar days Weekly snapshot up to 12 calendar weeks Monthly snapshot up to 12 calendar months Facilities user has approved access to Order within Results Tables and Trend Line Graphs is the time period i e Day Week or Month in chronological order N A N A Reports Manual Page 156 of 185 NSW Health Figure 66 Facility MAU Snapshot Summary Table Layout Facility MAU Snapshot Su
212. sfers EEE e Patient Open Transfers by LHD e Predicted Admissions via ED by Specialty User Access List e Waiting for What Current Admissions Open Reasons e Ward Lists e Ward Setup e Admission Risk Direct Ward Admission Records e Facility MAU Re admissions e Facility MAU Summary Hospital Occupancy Inter Hospital Transfers Hourly Performance Inter Hospital Transfer Records Inter Ward Transfer Records Inter Ward Transfer Times LHD MAU Summary e NSW Health MAU Re Admissions e Patients IN OUT Patient Transfer Cancellations Date Range e Patient Transfer Times e Patient Transfer Times Graph e Prediction Data Extract e Specialty Activity User Access Logins e Waiting for What All Reasons e Waiting for What Bed Days Reports Manual Page 15 of 185 NSW GOVERNMENT Health Report Data Category Reports Waiting for What Reasons Count Ward Activity Ward Profile Report Whole of Hospital Snapshot Whole of Hospital Snapshot by Facility Historical Snapshot Clinician Defined EDD Compliance by Ward Clinician Defined EDD Compliance by Facility Facility LHD Operational Summary Facility LHD Operational Summary Trend Facility MAU Snapshot Summary LHD MAU Snapshot Summary NSW Health MAU Snapshot Summary NSW Health MAU Performance Trend Summary NSW Health MAU Process Trend Summary Specialty Activity Snapshot Ward Activity Snapshot Ward Occupancy LHD Operat
213. sment Unit 119012 If patient is admitted or transferred to MAU multiple times in 1 admission this is only counted once Count of patients admitted or transferred based on admission date to wards identified as PECC using Ward Number of patients admitted or ee Type Sub Ward Type EE transferred to wards identified as PECC e Emergency PECC 108005 Numeric for the defined date range at a specific PECC facility e Mental Health PECC 115007 If patient is admitted or transferred to PECC multiple times in 1 admission this is only counted once Average Clinician Defined EDD Numeric Average clinician defined EDD percentage for the defined date range at a specific facility The average is based on an hourly snapshot taken each hour of the day for a facility Hourly snapshot Count of patients within a facility with a Clinician Defined EDD excluding patients in e Wards flagged as Day Only OR Designated ED e Virtual Beds i e Well Babies Boarder and Leave e LOS lt 24 hours Count of patients within a specific facility excluding patients in e Wards flagged as Day Only OR Designated ED e Virtual Beds i e Well Babies Boarder and Leave e LOS lt 24 hours x 100 Calculation for average is Sum of each daily snapshot Number of daily snapshots within the defined date range Reports Manual Page 142 of 185 UM Health Field Average Expired
214. sode length hours gt 0 where unit type 87 Average Length of Numerator Sum episode length hours Discharged patients 6 Stay hours in MAU lt 48hrs Patients aged 65 that were where unit_type 87 and age in STAY table Time period for patients aged 65 and over admitted to a MAU gt 65 Denominator Count of stays where patient Same facility sum episode_length_hours gt 0 where Reports Manual Page 148 of 185 UM GOVERNMENT Health Indicator Criteria Calculation amp Data Source Tables was in a MAU and age in STAY table gt 65 Data source Tables DAYS EPISODE EPISODE STAY Limitations or Comments unit type 87 patients 80 90 If a patient has been transferred in out from MAU more than once during the Numerator Count of stays of stays where sum episode_length_hours lt 48 Currently this may cause a rounding problem so alternately sum the difference in hours and minutes between start_date and end_date for Discharged patients Time period 7 transferred from the Guide same inpatient episode the all MAU wards Same facility sum MAU within 48hrs only stay is only counted once but episode_length_hours gt 0 where total time in MAU is Denominator Count of stays where patient unit_type 87 aggregated was in a MAU Data source Tables DAYS EPISODE EPISODE Numerator Count of MAU discharges where trans_type DIS
215. specialist 4o99 CessnockDistid enopy Emergency Department 0914478 29112945 female Pallipana PFU 49855300 49855300 care lt 24hrs Hospital Urgent specialist care lt 24hrs Urgent specialist Kurri Kurri District if if r care lt 24hrs Q205 Hospital EDKDH Emergency Department 0687380 25 05 1935 male Okwor Ojwang PFU 49855300 49855300 x r r r Urgent specialist 0244 BelmontHospital ED Emergency 0590582 26 02 1989 male Merran PFU 498556300 49855300 r r r Emergency Department 2810366 28 10 1950 male Ranasinghe 49855300 49855300 24 11 13 16 29 24 11 13 15 10 r r r 24 11 13 14 03 Q206 Maitland Hospital EMERG ED 2018350 02 09 1940 male Racquesh PFU 49855300 49855300 24 11 13 14 00 24 11 13 13 58 Urgent specialist 0225 Nelson Bay and 23 11 13 18 14 care lt 24hrs District Polyclinic Urgent specialist 1225 Manning Base care lt 24hrs Hospital r r r Urgent specialist q295 Maitland Hospital ED 0911453 17 12 2001 male Candrick 49855300 49855300 r r r Urgent specialist Muswellbrook cara lt Sitar Q209 District Hospita A 0782581 19 10 1979 male Le 49855300 49855300 r r r Emergency 2216981 11 08 1947 male Vasfi 49855300 49855300 23 11 13 15 15 23 11 13 14 46 23 11 13 12 49 Reports Manual Page 79 of 185 Wi GOVERNMENT Health Table 37 Inter Hospital Transfer Records Data Elements Definition Rules Calculations Date Time DD MM YY Date time the inter hospital N A Entered h
216. spite at glen innes nh TRRH no bed available for tranmsfer back to own aged care facilitty now pending transport Tamworth Base Inpatient specialist Orthopaedic 11 06 13 11 06 13 17 06 13 Patient transferred to another Hospital care 24 72hrs Surgery 13 19 13 15 12 40 facility Tamara Private Inpatient specialist Orthopaedic 11 06 13 11 06 13 16 06 13 Hospital care 24 72hrs Surgery 13 31 13 30 16 22 P Urgent specialist care 7 14 08 13 14 08 13 15 08 13 Patient transferred to another Maitland Hospital lt 24hrs Pacdiatics 19 22 19 20 13 06 facility Urgent specialist care General 14 08 13 14 08 13 14 08 13 lt 24hrs Medicine 19 23 19 20 21 54 Others Maitland Hospital Others Wrong Referring Hospital John Hunter Inpatient specialist Ni 23 08 13 27 08 13 04 09 13 Request for transfer not Hospital care 24 72hrs T 13 57 13 55 17 11 appropriate Lake Macquarie Urgent specialist care Cardiology 26 08 13 26 08 13 26 08 13 Patient transferred to another Private Hospital lt 24hrs Procedural 15 05 15 00 17 05 facility John Hunter Urgent specialist care Orthopaedic 22 09 13 22 09 13 22 09 13 Hospital lt 24hrs Surgery 13 08 12 55 13 17 John Hunter Inpatient specialist Cardiology 23 10 13 23 10 13 24 10 13 Hospital care 24 72hrs Procedural 22 17 22 15 16 06 John Hunter Urgent specialist care Cardiology 09 11 13 09 11 13 10 11 13 Patient transferred to another Hospital lt 24hrs Procedural 11 50 11 50 13 13 facility Pic
217. st Care gt 1 business day Count of completed inter LHD patient transfers into the selected LHD with e Urgency Return Transfer of Care Post Specialist Care gt 1 business day e Request Transfer Time to Transfer Completed Time gt 1 business day e Completed Time was between the first and last day of month OR e Urgency Future Return Transfer of Care Post Specialist Care gt 1 business day e Estimated Transfer Time to Transfer Completed Time gt 1 business day e Completed Time was between the first and last day of month Breached All Transfers Transfers OUT Numeric Percentage of completed patient transfers out of the given LHD that breached each urgency category between the first and last day of the month Urgency Life Threatening Count of patient transfers out of the selected LHD with e Urgency Life Threatening e Request Transfer Time to Transfer Completed Time gt 4 hours e Completed Time was between the first and last day of month Count of patient transfers out of the selected LHD with e Urgency Life Threatening e Completed Time was between the first and last day of month x 100 Urgency Urgent Specialist Care lt 24 hours Count of completed inter LHD patient transfers out of the selected LHD with e Urgency Urgent Specialist Care lt 24 hours e Request Transfer Time to Transfer Completed Time gt 24 hours e Completed Time was between the first and last day of month
218. t 08 12 2013 Sun 09 12 2013 Mon 10 12 2013 Tue 11 12 2013 Wed 12 12 2013 Thu 13 12 2013 Fri 14 12 2013 Sat 15 12 2013 Sun 16 12 2013 Mon 17 12 2013 Tue 18 12 2013 Wed 19 12 2013 Thu 20 12 2013 Fri 21 12 2013 Sat 22 12 2013 Sun 23 12 2013 Mon 24 12 2013 Tue 25 12 2013 Wed 26 12 2013 Thu 27 12 2013 Fri 28 12 2013 Sat 29 12 2013 Sun 30 12 2013 Mon 31 12 2013 Tue Hospital Indicator Target Patient Flow Portal Medical Assessment Unit Report Page 4 of 7 NSW Health GOVERNMENT Reports Manual Page 158 of 185 GOVERNMENT 10 5 Facility MAU FY Summary Health Table 92 Facility MAU FY Summary Overview Reports Manual Facility MAU FY Summary Provides information about Medical Assessment Units based on financial years commencing from FY08 09 for 1 or more facilities a user has approved access to Average Total Hours in ED for all MAU Patients Average LOS in MAU Hours Average LOS of MAU Patients Transferred to a Ward Days Readmission Rates within 28 days of MAU Home or MAU ward home discharges Separations from MAU Average LOS in MAU for patient aged 65 Hours patients transferred from MAU within 48 hours patients discharged home from MAU patients discharged home from MAU within 48 hours MAU patients transferred to ward Admissions direct to MAU Re admission rate of MAU home discharges ONLY MAU NEAT The da
219. t specialist care lt 24hrs Med Medical Rehabilitatio 03 10 13 07 10 13 n Medicine 11 21 11 20 Medical 04non3 08013 Urology 13 10 10 30 Rehabilitatio 04 10 13 08 10 13 n Medicine 15 27 10 30 Rehabilitatio 06 10 13 n Medicine 12 18 Rehabilitatio 06 10 13 n Medicine 12 22 12 20 Rehabilitatio N 07 10 13 07 10 13 n Medicine 09 05 09 00 07 10 13 07 10 13 1 09 15 Surgical Medical 06 1 o s 3 Med 06 10 13 Cardiology Procedural Page 83 of 185 NSW Health Figure 39 Patient Open Transfers Layout Excel Patient Open Transfers Current Ward Current Ward Requesting Ward Requesting Ward Urgency Transfer Estimated Isolation Receiving Open Transfer Code Description Code Description Category SE Request Time Transfer Time Req Hi Doctor Time Inpatient Rehabilitatio 14 days RNC3 specialist care SG 21 11 13 07 57 21111113 07 55 9 hours Requested n Medicine 24 72hrs Inpatient x 14 days specialist care Renabilitatio 34444743 45 04 21 11 13 15 00 Medical 2hours Requested n Medicine 24 72hrs Inpatient Specialist Care Rehabilitatio 24 72hours n Medicine Future Inpatient Specialist Care General 24 72hours Medicine Future Inpatient general 10 days specialist care 25 11 13 10 26 25 11 13 10 25 Medical 7 hours In Progress Medicine 24 72hrs Patient ID Surname Facility From Facility To Status Transfer Note Name RNC 1 Orthopaedic RNC 3 Rehabilitation Orthopaedics 1
220. t to lowest N A To be included in the report the WFW reason must have been open at some period during the date range entered in the report prompts e WFW Start date is before the Date From and has a status of Open e WFW Start date is before the Date From and has a Close date or Discharge date after the Date To e WFW Start date is before the Date From and has a Close date or a Discharge date between the Date From and the Date To e WFW Start date is between the Date From and the Date To and has a status of Open Page 63 of 185 Health GOVERNMENT Figure 28 Waiting for What All Reasons Layout PDF Waiting for What All Reasons Patient ID Patient Name i f Reports Manual Delay Reason Optional Text Consults Cardiology Consults Gastroenterology Endoscopy Consults Neurology Consults Palliative Care Consults Palliative Care Awaiting another review by Palliative Care regarding anxiety and Home oxygen Await measuring and ordering of a specific hip splint Consults Palliative Care Consults Physiotherapist Consults Physiotherapist Consults Physiotherapist Needs education for hip brace plus community support Consults Physiotherapist Consults Physiotherapist Consults Physiotherapist Consults Rehabilitation Consults Rehabilitation Consults Rehabilitation
221. ta is presented in both tabular and graphical format Trend line graphs are displayed for the 4 performance indicators Note Readmission data is calculated based on 28 days since the patient was discharged from their previous admission where they visited a MAU As such if this report is generated for last 28 days prior to today the readmission data will not be up to date Can be used to obtain an overview of the operations and performance of Medical Assessment Units in a facility HIE All users except Ambulance User PDF in portrait display default Excel tables only Facilities user has approved access to Order within Results Tables and Trend Line Graphs is the time period in chronological order N A N A Page 159 of 185 NSW GOVERNMENT Health Figure 68 Facility MAU FY Summary Layout Facility MAU Financial Year Summary Hospital 2008 2009 2010 2011 2012 2013 E ras 2009 2010 2011 2012 2013 2014 Avg total hours in ED for all MAU patients Avg LOS in MAU hrs 45 7 45 6 426 38 1 38 5 36 8 Avg LOS of MAU patients transferred to a ward days 9 8 8 5 7 6 a3 6 5 6 3 Re admission rates of MAU home or MAU ward home discharges 10 6 12 0 12 8 13 6 11 9 9 3 Process Indicators Separations from MAU 373 975 1392 1501 1782 1491 Avg LOS in MAU for patients aged 65 hrs 47 1 47 1 44 0 39 4 39 4 38 4 Patients transferred from MAU to ward 72 7 67 9 68 6 65
222. tentially identify areas of improvement Report Data So e PFP and EDWARD for NEAT Acce LHD User and MoH User Repo O 3 PDF only Facilities The facilities the user wants to run the report for Facilities available for port Promp selection depends on the user s access rights dato e Snapshot Month othe e stated Calendar Year Financial Year Alphabetically by LHD W4W 1 Sort Alphabetically by W4W Category 2 Sort By W4W reason bed days highest to lowest Ale N A N A Refer to 9 2 LHD Operational Summary for details of the report layout and data elements Reports Manual Page 136 of 185 Health GOVERNMENT 9 5 Whole of Hospital Snapshot Table 85 Whole of Hospital Snapshot Overview Repo De O o DO DF O o O po Pro D o O O O Orq Reports Manual Whole of Hospital Snapshot Provides a snapshot of information about Admissions to the Emergency Department Short Stay Unit EDSSU via the Emergency Department ED Number of admissions to the EDSSU Admissions to Inpatient Ward via ED and EDSSU Admissions to Inpatient Ward via ED and EDSSU Number of discharges from EDSSU Patients in EDSSU where LOS lt 24 hours Admissions to the Medical Assessment Unit MAU via ED Number of admissions to the MAU Number of admissions to the PECC Average Clinician Defined Estimated date of Discharge EDD Average Expired EDD Number of patients discharged Numb
223. the cell will be highlighted in green Number of patients presenting to and discharged from an Emergency Department within 4 hours who were admitted to an inpatient ward Total number of patients presenting to an Emergency Department and who were admitted to an inpatient ward x 100 Includes ED Visit Type Codes 01 Emergency Presentation 03 Unplanned return visit for continuing condition 11 Disaster The of admitted patients in an Percentage Emergency Department lt 4 hours Includes ED Separation Mode Code like 01 01 Formally admitted not further defined 01 01 Formally admitted and discharged within emergency department 01 02 Formally admitted then transferred to other hospital 01 03 Formally admitted to admitted patient ward not elsewhere classified 01 04 Formally admitted to operating theatre suite 01 05 Formally admitted to admitted patient critical care unit 01 06 Formally admitted and died in emergency department 01 07 Formally admitted and then left at own risk Excludes ED Separation Mode Code for Data Entry Error Admitted Pts Reports Manual Page 119 of 185 Wis GOVERNMENT Health Non Admitted Format Definition The of non admitted patients in an Rules Calculations Number of patients presenting to and discharged from an Emergency Department within 4 hours who were discharged from the Emergency Department i e not admitted to an inpatie
224. tically by Surname 2 Sort Alphabetically by First Name N A Table 15 User Access List Data Elements Ward Users and Clinical Managers will appear multiple times on the report based on wards they have approved access to Field Format Definition Rules Calculations Surname of the user who has access to Excludes MoH Users and System Surname Alphanumeric si DYR the facility Administrators irst N fth ho h t First Name Alphanumeric Firs a E a N A the facility Logon ID of the user who logged onto the Login Alphanumeric given facility during the specified date N A range Email Alphanumeric User s email address N A Phone No Numeric User s phone number N A Access Level Alphanumeric PFP Access Level of the user N A DD MM YY Date time the user last successfully N A Date of Last Login hh mm logged into the PFP Date Access DD MM YY Date time the user s access was N A Approved hh mm approved First f th that Approver Alphanumeric irst name and Surname of the user tha N A approved the given user eed Access Alphanumeric Access Level of the approver N A Tot l numberof sersatasp cific Count of number of approved users for the Total Users Numeric P given facility excluding MoH Users and facility System Administrators Reports Manual Page 31 of 185 GOVERNMENT H ea l t h 2 6 User Access Logins Table 16 User Access Logins Overview
225. tients to a ward days Facility 40 3 2 55 5 8 8 0 4 4 5 0 3 4 52 5 1 98 23 256 8 9 62 0 7 0 276 8 1 28 9 6 9 30 9 99 72 7 Hospital 16 6 57 1 Patient Flow Portal Medical Assessment Unit Report Page 1 of 7 NSW Health Reports Manual Page 169 of 185 NSW GOVERNMENT Health Figure 74 NSW Health MAU Snapshot Summary Graph Layout NSW Health MAU Snapshot Summary For the Period 01 11 2013 to 30 04 2014 NSW Health Average Total Hours in ED for all MAU Patients Patient Flow Portal Medical Assessment Unit Report Page 3 of 7 NSW Health COVERROENT Reports Manual Page 170 of 185 Health GOVERNMENT 10 10 NSW Health MAU Performance Trend Summary Table 97 NSW Health MAU Performance Trend Summary Overview Repo e NSW Health MAU Performance Trend Summary Provides information about Medical Assessment Units as a trend for the period of 1 to 12 months as defined by the user e Average Total Hours in ED for all MAU Patients e Average LOS in MAU Hours e Average LOS of MAU Patients Transferred to a Ward Days e Readmission Rates within 28 days of MAU Home or MAU ward home discharges The data is presented in both tabular and graphical format and summarised at state level as well comparing facilities based on peer groups The number of graphs printed will be determined by the number of different peer groups the facilities are assigned to Note Readmiss
226. upancy snapshot taken each hour of the day for the given facility x 100 for each facility within the LHD g y Calculation for average Sum of all hourly snapshots Number of hourly snapshots within the week Count of patients admitted or transferred during the reporting period to wards identified as HITH ing Ward T Sub Ward Type Number of Number of patients admitted or KO ee E patients who transferred to wards identified as HITH e Hospital In The Home 112000 received HITH Humen during the defined date range ata e Paediatrics Hospitalin The Home ee 119009 care specific facility If patient is admitted or transferred to HITH multiple times in 1 admission this is only counted once Number et Number of patients discharged from Count af Dale whose T patients ps discharged during the reporting period Numeric wards identified as Transit Lounge at a N discharged from specific facilit from a Transit Lounge using Ward Type a Transit Lounge p vs Transit Discharge Lounge 126000 Count of patients admitted or transferred to First ward Emergency Department Number of defined as a ward flagged as patients Number of patients discharged froma Designated ED and Ward Type lt gt discharged from Numeric transit lounge via ED i e first ward is Transit Discharge Lounge 126000 a Transit Lounge via ED ED and second ward is transit lounge AND Discharged during the reporting period
227. urs Count of completed inter LHD patient transfers out of the selected LHD with e Urgency Urgent Specialist Care lt 24 hours e Request Transfer Time to Transfer Completed Time gt 24 hours e Completed Time was between the first and last day of month Urgency Inpatient Specialist Care 24 72 hours Reports Manual Page 123 of 185 Wis GOVERNMENT Health Format Definition Rules Calculations Count of completed inter LHD patient transfers out of the selected LHD with e Urgency Inpatient Specialist Care 24 72 hours e Request Transfer Time to Transfer Completed Time gt 72 hours e Completed Time was between the first and last day of month OR e Urgency Future Inpatient Specialist Care 24 72 hours e Estimated Transfer Time to Transfer Completed Time gt 72 hours e Completed Time was between the first and last day of month Urgency Return Transfer of Care Post Specialist Care gt 1 business day Count of completed inter LHD patient transfers out of the selected LHD with e Urgency Return Transfer of Care Post Specialist Care gt 1 business day e Request Transfer Time to Transfer Completed Time gt 1 business day e Completed Time was between the first and last day of month OR e Urgency Future Return Transfer of Care Post Specialist Care gt 1 business day e Estimated Transfer Time to Transfer Completed Time gt 1 business day e Completed Time was between the first and last d
228. urs Requested Medicine 24 72hrs Consultant Inpatient 6 days Reports Manual Page 84 of 185 UM GOVERNMENT Health Table 56 Patient Open Transfers Data Elements PDF and Excel Field Patient ID Format Alphanumeric Definition Patient s UID or MRN Report Format PDF and Excel Rules Calculations Which value displays depends on the LHD preferences Patient s Surname Patient s First Patient Name Alphanumeric PDF N A Name Surname Alphanumeric Patient s Surname Excel N A First Name Alphanumeric Patient s First Name Excel N A Facility From Alphanumeric eg Tie pentis to Be Ole PDF and Excel N A Facility To Alphanumeric ee the patient ie be transferred PDF and Excel N A Current Ward Alphanumeric Ward Code the patient is currently PDF and Excel N A Code admitted into Current Ward Alphanumeric Ward Description the patient is Excel N A Description currently admitted into Requesting Ward Ward Code the patient was admitted AE E Alphanumeric into when the transfer request was PDF and Excel N A initiated Ward Description the patient was Requesting Ward Alphanumeric admitted into when the transfer Excel N A Description ne request was initiated Urgency Alphanumeric Urgency Category assigned to the PDF and Excel N A Category transfer Specialty Alphanumeric Specialty of the patient s AMO PDF and Excel N A Transfer Request
229. with patients AMO Alphanumeric admitted under them for the given Displays as Surname First name specialty Total LOS N merie Total LOS of all patients admitted under Sum of LOS for all patients admitted under the given Specialty and AMO the given Specialty and AMO Total No Patients Numeric Total number of patients admitted under Count of number of patients admitted the given Specialty and AMO under the given Specialty and AMO Average LOS for patients admitted under Total No Patients Total LOS admitted Avg LOS Numeric f the given Specialty and AMO under the given Specialty and AMO Number of patients per LOS breakdown No Patients by Numeric admitted under the given Specialty and Count of number of patients per LOS LOS AMO breakdown Reports Manual Page 55 of 185 Health GOVERNMENT 4 2 Predicted Admissions via ED by Specialty Table 35 Predicted Admissions via ED by Specialty Overview Repo De O ReDo a Repo DF O er a Repo O Repo Pro 0 o O O o ad Repo O Orde Predicted Admissions via ED by Specialty Displays the number of predicted admissions for the next 14 days via ED to an inpatient overnight bed by clinical specialty i e Historical count of admitted patients in ward s flagged as Emergency in the PFP where AMO specialty is not ED The Predictive Admissions via ED by Specialty report is designed to assist with capacity and demand planning by
230. xceeded the expiration period for the given Urgency Category Life Threatening gt 4 hours Urgent Specialist Care lt 24 hours gt 24 hours Inpatient Specialist Care 24 72 hours gt 72 hours A transfer must have a status of Completed to appear on the report For PDF Report From Ward and To Wards are displayed in two tables underneath each other Page 107 of 185 NN NSW Health Figure 52 Inter Ward Transfer Times Layout PDF Inter Ward Transfer Times For the Period 01 06 2013 to 31 10 201 From Ward ICU Intensive Care Unit ED Accessible Transfer Transfer Urgency 8 Estimated Request to Patient ID Patient Name Ward To Code Category Specialty Tranier Tike Request Completed Completed Time ime Time i J3M Urgent specialist care lt 24hrs Not Specified 03 09 13 08 10 03 09 13 08 13 03 09 13 13 36 Shows G1 Urgent specialist care lt 24hrs Not Specified 05 09 13 08 25 05 09 13 08 26 05 09 13 09 47 Jour Urgent specialist care lt 24hrs Not Specified 05 09 13 08 25 05 09 13 08 27 05 09 13 09 47 klasa 5 days Urgent specialist care lt 24hrs Neurosurgery 11 09 13 12 10 11 09 13 12 11 17 09 13 10 07 21 hours 56 mins Urgent specialist care lt 24hrs Not Specified 16 09 13 09 40 16 09 13 09 50 17 09 13 10 07 Jo Urgent specialist care lt 24hrs _ Not Specified 16 09 13 09 50 16 09 13 09 50 17 09 13 10 04 Ber 1 days
231. xt notes entered Optional Text Alphanumeric against the WFW reason PDF and Excel N A Admission Date DD MM YY Patient s Admission date Excel N A Discharge Date DD MM YY Patient s Discharge date PDF and Excel N A If Discharge date is not null then Difference between Discharge date and aai Admission date LOS Numeric Patient s Length of Stay PDF and Excel if Discharge date is null then Difference between Date To and Admission date WFW Start Date DD MMAYY Date the WFW reason was PDF and Excel N A started requested WFW Closed DD MM YY Date the WFW reason was PDE and Excel N A Date actioned closed Number of beds days during Difference ea earliest of WPW WFW Days oes Closed date Discharge date or Date ee Numeric the specified date range lost Excel j a a within range To and latest of WFW Start date and due to the WFW reason i j Date From WFW Total Total number of days the DINE RE NES between arli st of APA Days Numeric WEW reason has been ope PDF and Excel Closed date or Discharge date and y ae WEW Start date Status of the WFW reason either open or WEW Status Alphanumeric Status of the WFW reason PDF and Excel closed If a patient has a WFW reason Open or Closed that is still open on Discharge it will still be displayed as open EDD DD MM NY Patient s Esti
232. y Numeric discharged out of the specialty within the iven data range g g Excludes patients where New specialty Previous specialty Sum of all INTO Specialty for the defined date range Total of all transfers and admissions INTO ALL Specialties Sum of all transfers and discharges OUT of ALL Specialties TOTAL Sum of all OUT Specialty for the defined date range Reports Manual Page 59 of 185 Health GOVERNMENT 4 4 Specialty Activity Snapshot Table 39 Specialty Activity Snapshot Overview Repo De O o po D O A o O ele omp o O O o Repo O Orde Reports Manual Specialty Activity Snapshot Provides a summary of the count of patient activity for each specialty within a facility based on a daily weekly or monthly snapshot as defined by the user The report can be downloaded as a PDF and Excel file Allows Patient Flow Managers Clinical Managers Medical Officers and Hospital Executives to monitor activity via Specialty to better understand and plan for future activity PFP All Users except Ambulance Users PDF default and Excel Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights Snapshot time Daily Weekly Monthly Alphabetically by Specialty N A Excludes patients where New specialty Current specialty Page
233. y Other 28 day re admit Reports Manual Page 182 of 185 UM GOVERNMENT Health Table 102 Admission Risk Records Data Elements Field Format Definition Rules Calculations LHD Alphanumeric Code of the LHD N A Ms i Code of the selected facility based on HIE Facility 1D Alphanumeric facility code identifiers N A AUID Alphanumeric Patient s UID N A MRN Alphanumeric Patient s MRN N A Admission DD MM YYYY Patient s admission date and time N A Date time hh mm Discharge DD MM YYYY Patient s discharge date and time N A Date time hh mm Surname Alphanumeric Patient s Surname N A First Name Alphanumeric Patient s First Name N A DOB DD MM YYYY Patient s Date of Birth N A Sex Alphanumeric Patient s gender N A Address line 1 Alphanumeric Patient s address line 1 N A Address line 2 Alphanumeric Patients address line 2 N A City Alphanumeric Patient s city N A Postcode Alphanumeric Patient s Postcode N A Telephone Alphanumeric Patient s contact number N A number AMO Specialty Alphanumeric Description of the speciality the patient N A was admitted under Patient s Financial Status which is based on Financial Status Alphanumeric their financial class e g Public Private N A DVA Compensable etc Financial Alphanumeric Patient s Financial Description associated N A Description with their financial class AdmissionRick Alphanumeric er risk the patient
234. yout PDF Waiting for What Current Admissions Open Reasons Displays open waits recorded against patients who are currently admitted at a specific facility Provides detailed information about patients currently delayed in hospital including notes about their waiting for what reason PFP All Users except Ambulance Users PDF and Excel default Facilities The facility or facilities the user wants to run the report for Facilities available for selection depends on the user s access rights 1st Sort Alphabetically by Primary Delay Reason 2nd Sort Alphabetically by Secondary Delay Reason 3rd Sort WFW Total Days highest to lowest N A WFW reason must have a status of Open for patients currently admitted to the selected facility Waiting for What Current Admissions Open Reasons Reports Manual RNC1 RNC1 F3C F3C H3S H3S CAPAC O amp amp A F1 STHRPH Consults Physiotherapist Consults Rehabilitation Consults Rehabilitation Consults Rehabilitation Consults Other Medicine Diagnostics Treatment Operating Theatre Diagnostics Treatment Operating Theatre Diagnostics Treatment Operating Theatre Diagnostics Treatment Operating Theatre Diagnostics Treatment Other Diagnostics Treatment Other Diagnostics Treatment Other Diagnostics Treatment Other Diagnostics Treatment Diagnostics Treatment Other Diagnostics Treatment Other Aw

Patient Flow Portal Reports Module and Reports User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents