ER Delay: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 17: | Line 17: | ||
=={{CCMDB Data Integrity Checks| ready to implement}} == | =={{CCMDB Data Integrity Checks| ready to implement}} == | ||
The data collector will receive an error if | The data collector will receive an error if: | ||
* CC - 8 hours | |||
* Med – 44 hours | * ER Delay is greater than: | ||
** CC - 8 hours | |||
** Med – 44 hours | |||
* Patient came from ER at own hospital | |||
* [[Service/Location]] is not an [[EMIP]] | |||
{{discussion}} | {{discussion}} | ||
* as of 2017-10-17 Julie would like that cross check; Tina needs to implement it still. | * as of 2017-10-17 Julie would like that cross check; Tina needs to implement it still. | ||
Implementation: started query ''check_ER_Delay_not_too_big'' to exclude other sites and include only from this site. Waiting for EMIP question. Ttenbergen 17:25, 2017 December 9 (CST) | |||
== related fields == | == related fields == | ||
Revision as of 12:13, 2017 December 11
| 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.
Template:CCMDB Data Integrity Checks
The data collector will receive an error if:
- ER Delay is greater than:
- CC - 8 hours
- Med – 44 hours
- Patient came from ER at own hospital
- Service/Location is not an EMIP
- as of 2017-10-17 Julie would like that cross check; Tina needs to implement it still.
Implementation: started query check_ER_Delay_not_too_big to exclude other sites and include only from this site. Waiting for EMIP question. Ttenbergen 17:25, 2017 December 9 (CST)
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.