ER Delay

From CCMDB Wiki
Revision as of 10:40, 2021 September 15 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
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, or ER Boarding Loc and first post-ER Boarding Loc, 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.

It is also calculated and checked by query check_ER_Delay_not_too_big.

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)

 AppStatus
Query s tmp Boarding Loc ER delay reasonableCCMDB.accdbimplemented

related fields

Reporting and Analysis

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

Legacy

Related articles

Related articles: