ER Wait: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (→‎Purpose: link)
(to be continued)
Line 6: Line 6:
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''' .
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''' .


== Reporting and Analysis ==
[[ER Delay]] is calculated as the difference [[Arrive DtTm]] - [[Accept DtTm]] for patients coming from ER in [[CFE]]
*[[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)


=={{Data Integrity Checks}}==
=={{Data Integrity Checks}}==
Line 26: Line 24:
*This used to be collected as a tmp project.  
*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]].
*As of 2016-07-01 it will only be collected as part of [[2016 Time and Place changes]].
*{{Discussion}} Need to move the data across.
**PROJECT:  
**PROJECT:  
**ER_Wait  
**ER_Wait  
Line 36: Line 33:
**Column Q:  'Parked in ER' if '''Direct admit'''
**Column Q:  'Parked in ER' if '''Direct admit'''
*Cleaned out old wiki instructions that might confuse.
*Cleaned out old wiki instructions that might confuse.
*Conversion of data from tmp [[ER Wait]] project to Centralized_data
**The date and time in the [[ER Wait]] for patients coming from ER populated the ArriveDtTm in the L_LOG table. The




[[Category: Legacy Data]]
[[Category: Legacy Data]]

Revision as of 16:55, 2017 March 16

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.
  • As of 2016-07-01 it will only be collected as part of 2016 Time and Place changes.
    • 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.
  • Conversion of data from tmp ER Wait project to Centralized_data
    • The date and time in the ER Wait for patients coming from ER populated the ArriveDtTm in the L_LOG table. The