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.

Integrity checks

Data Integrity Checks
Summary:	Unusually long ER Delay
Related:	Accept DtTm, Arrive_DtTm, Service/Location
Firmness:	soft check
Timing:
App:	CCMDB.mdb
Coding:	query check_ER_Delay_not_too_big
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	date change was rolled out / first applied
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property. 

• Categories:  

• form:

The data collector will receive an error if:

• ER Delay is greater than:
  • CC - 8 hours
  • Med – 44 hours
• Patient came from ER at own hospital
• Service/Location is not an EMIP

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.