ER Delay: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "Created_variables_common table" to "Created_Variables_Common table"
mNo edit summary
Line 10: Line 10:
}}
}}


It's is calculated by [[created_variables_common_maker query |''created_variables_common_maker'' query]] and stored in [[created_variables_common table |''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]].  


== data use ==
== data use ==
* Measure the time spent using ER bed/facilities/staff while already accepted under a Medicine or Critical Care Service.
* 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.
* Measure the delay of movement of patient from ER bed to Medicine or Critical Care bed.


{{Data Integrity Check List}}
{{Data Integrity Check List}}
Line 34: Line 34:




[[Category: Reporting]]
[[Category:Reporting]]
[[Category: Admit/Discharge]]
[[Category:Admit/Discharge]]
[[Category:Created Variables]]

Revision as of 13:41, 2021 April 21

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)

 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

Used to be collected as ER Wait and before that as Moves for Medicine.

Related articles

Related articles: