ER Delay: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
{{Data_element
{{Data_element
| field_name = ER Delay
| field_name = ER Delay
| element_description = The ER Delay is the difference between the [[Accept DtTm]] and [[Arrive_DtTm]] for patients arriving from the ER.
| element_description = 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.
| in_table = Created_Variables_Common table
| in_table = Created_Variables_Common table
| data_type = date
| data_type = date
Line 11: Line 11:


It's is calculated by [[Created_Variables_Common_maker query]] and stored in [[Created_Variables_Common table]] in [[CFE]].  
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 ==
== data use ==
Line 28: Line 30:


== Legacy ==
== Legacy ==
Used to be collected as [[ER Wait]] and before that as [[Moves for Medicine]].  
* Used to be just the difference between the [[Accept DtTm]] and [[Arrive_DtTm]] for patients arriving from the ER.
* Used to be collected as [[ER Wait]] and before that as [[Moves for Medicine]].  


== Related articles ==
== Related articles ==

Revision as of 10:40, 2021 September 15

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: