ER Delay

Data Element (edit)
Field Name:	ER Delay
CCMDB Label:	not stated
CCMDB tab:	not stated
Table:	Created_variables_common table
Data type:	date
Length:	n/a
Program:	Med and CC
Created/Raw:	Created
Start Date:	1988-07-11
End Date:	2300-01-01
Sort Index:	8

The ER Delay is the difference between the Accept DtTm and Arrive_DtTm for patients arriving from the ER.

• SMW

Legacy implementation right in the table

• Cargo

• Categories

• Forms

It's is calculated by created_variables_common_maker query and stored in created_variables_common table in CFE.

data use

• Measure the time spent using ER bed/facilities/staff while already accepted under a Medicine or Critical Care Service.
• Measure the delay of movement of patient from ER bed to Medicine or Critical Care bed.

Template:CCMDB Data Integrity Checks

The data collector will receive an error if the ER Delay is greater than:

• CC - 8 hours
• Med – 44 hours

• as of 2017-10-17 Julie would like that cross check; Tina needs to implement it still.
  • Julie, this warning, it should only apply if the patient is from the location collection's own ER, right? Or also if from other ER?Ttenbergen 17:51, 2017 December 6 (CST)
    • Own ER only. also I change the limits of CC from 9 to 8. I did a rerun on the corrected data after the audit. --JMojica 09:29, 2017 December 7 (CST)
      • How about EMIPs?

Implementation: started query check_ER_Delay_not_too_big to exclude other sites and include only from this site. Waiting for EMIP question. Ttenbergen 17:25, 2017 December 9 (CST)

related fields

• Accept DtTm
• Arrive_DtTm
• LOS
• Transfer Delay

Reporting and Analysis

The SAS Program to read the data is in X:\Julie\SAS_CFE\CFE_macros\CFE_ERWait_Moves.sas

Legacy

Used to be collected as ER Wait and before that as Moves for Medicine.