ER Delay: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(20 intermediate revisions by 2 users not shown)
Line 2: Line 2:
| field_name = ER Delay
| field_name = ER Delay
| 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.
| 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_2021 table
| data_type = date
| data_type = date
| datafield_length = n/a
| datafield_length = n/a
Line 10: Line 10:
}}
}}


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_2021 query]] and stored in [[Created_Variables_Common_2021 table]] in [[CFE]]. It is related to one of our [[Indicators]], [[Length_of_Time_for_Transfer_from_ED_to_ICU_within_same_facility]].  


== Data use ==
== Data use ==
Line 16: Line 16:
* 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.


== ER Delay when there are [[Visits to temporary locations]] between initial ER and first unit ==
== ER Delay Calculation ==
{{Todo
* Before Oct 2020 : If [[Previous Location]] is own ER
| who = all
** Non-EMIP / Non-ECIP :  [[Arrive DtTm]] - [[Accept DtTm]]  and [[Accept DtTm missing]] is not marked
| question = 
*** if [[Accept DtTm missing]] is marked then ER Delay is missing.
* Make sure to update [[Visits to temporary locations]]when this is resolved, if needed.
** EMIP/ECIP: [[Dispo DtTm]] - [[Accept DtTm]]
}}
*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])
 
== Log ==
{{DT |  
* I have re-updated [[Created_Variables_Common_maker_2021 query]], for some reason the change I had made was not reflected in the master version. Ready to test. [[User:Ttenbergen|Ttenbergen]] 13:25, 2022 June 28 (CDT)
** emailed Tina some inconsistencies found in ER Delays Aug 15,2022. --[[User:JMojica|JMojica]] 13:21, 2022 August 29 (CDT)}}


{{DiscussTask |
* 2022-06-28 - previous change got lost somehow, re-applied it; updated query to use [[query created_PatientFollow]] rather than in-query definition
*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.
* 2022-06-09 - updated [[Created_Variables_Common_maker_2021 query]] with the new definition.  
*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. 
*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.
*If YES in the question above, then we should add this rule for EMIP or ECIP cases
#Arrive dttm equals dispo dttm
#first post-ER Boarding Loc dttm equals dispo dttm
in this way, ER Delay will be consistent in both formulas. 
*For discussion. --[[User:JMojica|JMojica]] 10:17, 2022 March 9 (CST)
** Discussed at [[Task Team Meeting - Rolling Agenda and Minutes 2022#ICU Database Task Group Meeting – March 9, 2022]] - Julie and Lisa will bring more data to next task meeting Apr 6. [[User:Ttenbergen|Ttenbergen]] 22:27, 2022 March 9 (CST)
** now that we have retired accept/arrive concepts can we delete this? or do we need to update first service/second boarding loc? [[User:Lkaita|Lisa Kaita]] 08:01, 2022 April 28 (CDT)
*** I think the question of how Julie will interpret and report the scenario she describes is still open, even when defined with [[Boarding Loc]] and [[Service tmp entry]] rather than Accept/Arrive. I think Julie was going to bring data today to hopefully decide and be done with this. [[User:Ttenbergen|Ttenbergen]] 10:42, 2022 May 4 (CDT)
}}


{{Data Integrity Check List}}
{{Data Integrity Check List}}

Latest revision as of 15:52, 2023 April 19

Data Element (edit)
Field Name: ER Delay
CCMDB Label: not stated
CCMDB tab: not stated
Table: Created_Variables_Common_2021 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.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


It's is calculated by Created_Variables_Common_maker_2021 query and stored in Created_Variables_Common_2021 table in CFE. It is related to one of our Indicators, Length_of_Time_for_Transfer_from_ED_to_ICU_within_same_facility.

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

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])

Log

  • I have re-updated Created_Variables_Common_maker_2021 query, for some reason the change I had made was not reflected in the master version. Ready to test. Ttenbergen 13:25, 2022 June 28 (CDT)
    • emailed Tina some inconsistencies found in ER Delays Aug 15,2022. --JMojica 13:21, 2022 August 29 (CDT)
  • SMW


  • Cargo


  • Categories

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\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.

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=ER_Delay&oldid=159047"