ER Wait
We track the time accepted patients spend in the ER before physically arriving on the ward/unit.
The data is collected as part of regular data collection, specific instructions are in the relevant component fields.
Purpose
To assess the ER Delay from when a patient is first accepted to service while in the site's own ER (emergency room) to when the patient physically arrives .
ER Delay is calculated as the difference Arrive DtTm - Accept DtTm for patients coming from ER in CFE
Template:Data Integrity Checks
ER Wait and from-ER consistency
- uses the following queries
- s_tmp_ER_Wait_long_delay - gives error if delay is > 3 days
The following can go as last pre-dispo patients are discharged:
- s_tmp_ER_Wait_has_tmp_not_from_ER - error if ER wait entry but is not from ER
- s_tmp_ER_Wait_from_ER_no_ER_Wait - error if from ER but has no ER wait entry
- s_tmp_ER_Wait_chronological - error if tmp date/time is null or is <= admit date/time
- s_tmp_ER_Wait_duplicate_entry - gives error if more than one ER wait entry
Legacy
- This used to be collected as a tmp project. Start date: June 2011; End Date: June 2016
- PROJECT: ER_Wait
- ITEM:
- ER admit ( if coming from own hospital ER)
- Direct admit (if coming from other location, facility or hospital and not your own hospital ER, ward, ICU)
- Column E: Date (arrived on ward bed)
- Column M: time (arrived to ward bed)
- Column Q: 'Parked in ER' if Direct admit
- As of 2016-07-01 it will only be collected as part of 2016 Time and Place changes.
- Conversion of June 2011 to June 2016 data from tmp ER Wait project to Centralized_data was done June 22, 2016
- The date and time in the ER Wait for patients coming from ER populated the Arrive_DtTm in the L_LOG table of centralized_data.