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.

Data Integrity Checks (automatic list)

	App	Status
Query s tmp Boarding Loc ER delay reasonable	CCMDB.accdb	implemented

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.