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:	[[ER Delay, Service/Location]]
Firmness:	soft check
Timing:	complete always
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. Property "DICRelatedConcepts" (as page type) with input value "ER Delay]], [[Service/Location" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

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