ER Delay: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "Created_variables_common table" to "Created_Variables_Common table" |
||
| Line 2: | Line 2: | ||
| 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]] for patients arriving from the ER. | ||
| in_table = | | in_table = Created_Variables_Common table | ||
| data_type = date | | data_type = date | ||
| datafield_length = n/a | | datafield_length = n/a | ||
Revision as of 13:37, 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.
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 |
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.