ER Delay: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) 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 | | element_description = The ER Delay is the difference between the pre-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 25: | Line 25: | ||
{{DiscussTask | | {{DiscussTask | | ||
*Lisa replied ‘when boarding loc is only ER the arrivedttm equals accept dttm equals first service dttm, dispo time should be the discharge dttm'. I have thought the same – that this is how we were doing it with EMIPs. Can’t find this rule in WIKI. | *Lisa replied ‘when boarding loc is only ER the arrivedttm equals accept dttm equals first service dttm, dispo time should be the discharge dttm'. I have thought the same – that this is how we were doing it with EMIPs. Can’t find this rule in WIKI. | ||
*Before we move to tmp service and boarding loc. I calculated ER delay equals Arrive dttm – accept dttm. Now we added another or second way, | *Before we move to tmp service and boarding loc. I calculated ER delay equals Arrive dttm – accept dttm. Now we added another or second way, ER Delay equals first post-ER Boarding Loc dttm - ER Boarding Loc dttm. | ||
*This caused an issue for boarding loc only ER. There is no post-ER boarding loc. if I follow the first way, ER delay is ZERO since arrive dttm is the same as accept dttm. | *This caused an issue for boarding loc only ER. There is no post-ER boarding loc. if I follow the first way, ER delay is ZERO since arrive dttm is the same as accept dttm. | ||
*Should the whole stay at ER be considered as an ER delay or NOT? If yes, then in the past I was underestimating it because all EMIPs have ZERO delay. | *Should the whole stay at ER be considered as an ER delay or NOT? If yes, then in the past I was underestimating it because all EMIPs have ZERO delay. | ||
| Line 39: | Line 39: | ||
== related fields == | == related fields == | ||
* [[ | * [[Boarding Loc]] DtTm | ||
* [[LOS]] | * [[LOS]] | ||
* [[Transfer Delay]] | * [[Transfer Delay]] | ||
Revision as of 15:48, 2022 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 pre-ER Boarding Loc and first post-ER Boarding Loc, 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.
ER Delay when there are Visits to temporary locations between initial ER and first unit
for all |
|
|
|
in this way, ER Delay will be consistent in both formulas.
|
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\datetimes.sas
Legacy
- 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.