ER Wait: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 7: Line 7:


== Reporting and Analysis ==
== Reporting and Analysis ==
*ER Wait is calculated as the difference [[Arrive DtTm]] - [[Accept DtTm]] for patients coming from ER
*[[ER Delay]] is calculated as the difference [[Arrive DtTm]] - [[Accept DtTm]] for patients coming from ER in [[CFE]]
*The SAS Program to read the data is in X:\Julie\SAS_CFE\CFE_macros\CFE_ERWait.sas {{discussion}} still true for new fields? Ttenbergen 10:24, 2016 July 3 (CDT)
*The SAS Program to read the data is in X:\Julie\SAS_CFE\CFE_macros\CFE_ERWait.sas {{discussion}} still true for new fields? Ttenbergen 10:24, 2016 July 3 (CDT)



Revision as of 09:16, 6 July 2016

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 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 .

Reporting and Analysis

  • ER Delay is calculated as the difference Arrive DtTm - Accept DtTm for patients coming from ER in CFE
  • The SAS Program to read the data is in X:\Julie\SAS_CFE\CFE_macros\CFE_ERWait.sas Template:Discussion still true for new fields? Ttenbergen 10:24, 2016 July 3 (CDT)

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.
  • As of 2016-07-01 it will only be collected as part of 2016 Time and Place changes.
  • Template:Discussion Need to move the data across.
    • 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
  • Cleaned out old wiki instructions that might confuse.