ER Delay: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
No edit summary |
||
| Line 12: | Line 12: | ||
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]]. | ||
{{DJ | This is really one of the [[Indicators]], right? If so we should add that template... That would also include which reports use it, and what the n is, etc. [[User:Ttenbergen|Ttenbergen]] 10:27, 2023 February 2 (CST) }} | {{DJ | This is really one of the [[Indicators]], right? If so we should add that template... That would also include which reports use it, and what the n is, etc. [[User:Ttenbergen|Ttenbergen]] 10:27, 2023 February 2 (CST) | ||
*we have already [[Length_of_Time_for_Transfer_from_ED_to_ICU_within_same_facility]] | |||
--[[User:JMojica|JMojica]] 15:30, 2023 April 19 (CDT)}} | |||
== Data use == | == Data use == | ||
Revision as of 14:30, 2023 April 19
| 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.
|
This is really one of the Indicators, right? If so we should add that template... That would also include which reports use it, and what the n is, etc. Ttenbergen 10:27, 2023 February 2 (CST)
--JMojica 15:30, 2023 April 19 (CDT) |
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 Calculation
- Before Oct 2020 : If Previous Location is own ER
- Non-EMIP / Non-ECIP : Arrive DtTm - Accept DtTm and Accept DtTm missing is not marked
- if Accept DtTm missing is marked then ER Delay is missing.
- EMIP/ECIP: Dispo DtTm - Accept DtTm
- Non-EMIP / Non-ECIP : Arrive DtTm - Accept DtTm and Accept DtTm missing is not marked
- Starting Oct 2020 : if first Boarding Loc is own ER
- Only one ER Boarding Loc: Dispo DtTm - first ER Boarding Loc start Dttm
- At least two Boarding Loc: First NonER Boarding Loc start Dttm - first ER Boarding Loc start Dttm
Implemented as
- ER_Delay:
- IIf(Not [PatientFollow],
- IIf([location_name] Like "*EMIP*",[Dispo_DtTm],[Arrive_DtTm])-Nz([Accept_dttm],
- [Arrive_dttm]),Nz([created_FirstNonER_BoardingLoc].[dttm],[Dispo_DtTm])-[created_FirstER_BoardingLoc].[dttm])
- IIf(Not [PatientFollow],
- ER_Delay:
Log
|
|
- 2022-06-28 - previous change got lost somehow, re-applied it; updated query to use query created_PatientFollow rather than in-query definition
- 2022-06-09 - updated Created_Variables_Common_maker_2021 query with the new definition.
Data Integrity Checks (automatic list)
| App | Status | |
|---|---|---|
| Query s tmp Boarding Loc ER delay reasonable | CCMDB.accdb | implemented |
- Boarding Loc DtTms
- LOS
- Transfer Delay
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.