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.