ER Delay: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
No edit summary
 
Line 1: Line 1:
{{Reporting Indicators
|description=The ER Delay is the difference between the initial ER [[Boarding Loc]] and first post-ER [[Boarding Loc]], for patients arriving from the ER.
|created_raw=Created
|Program=Critical Care
|DataDependencies=Transfer Ready DtTm; Admit DtTm; Boarding Loc
|indicator_name={{PAGENAME}}
|program=Critical Care
}}
{{Data_element
{{Data_element
| field_name = ER Delay
| field_name = ER Delay
Line 8: Line 17:
| created_raw = Created
| created_raw = Created
| data_element_sort_index = 8
| data_element_sort_index = 8
}}
{{Reporting Indicators
|description=The ER Delay is the difference between the initial ER [[Boarding Loc]] and first post-ER [[Boarding Loc]], for patients arriving from the ER.
|created_raw=Created
|Program=Critical Care
|DataDependencies=Transfer Ready DtTm; Admit DtTm; Boarding Loc
|indicator_name={{PAGENAME}}
|program=Critical Care
}}
}}


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]].  
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 ==

Latest revision as of 16:03, 8 December 2025

The ER Delay is the difference between the initial ER Boarding Loc and first post-ER Boarding Loc, for patients arriving from the ER.

Indicators
Indicator: ER Delay
Created/Raw: Created
Program: Critical Care
Start Date:
End Date:
Reports: Length of Time for Transfer from ED to ICU within same facility
Data Dependencies(Reports/Indicators/Data Elements): Transfer Ready DtTm • Admit DtTm • Boarding Loc


  • Cargo


  • Helper template:
  • Cargo


  • Categories

none

  • SMW:
  • Categories
  • Default form:


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
Data Dependencies(Reports/Indicators/Data Elements):

The ER Delay is the difference between the initial 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.


  • This measure is not referenced by any of the Reports pages. Which reports actually use this? Is it wrapped into a specifically stratified indicator like beds lost or similar? Ttenbergen 15:14, 7 December 2025 (CST)
  • SMW


  • Cargo


  • Categories

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

Outliers

ED stays in mid-hospitalization

  • there are occasions where pts go back to the ED while under the care of ICU; we do not include these in ER Delays; discussed at JALT 2024-10-31...

Moves for Medicine

  • This data is problematic before 2011-Q2,the only reason there are any is because it derives them for EMIPs. Some data may be available in Moves for Medicine, but that would still leave a gap. Ttenbergen 23:09, 2024 November 16 (CST)
    • OK, will be working on this getting data from Moves for Medicine from period Sept 2007 to June 3, 2011. will give to Pagasa for upload to Arrive DtTm field. I will update the WIKI as soon as done. Conclusion: for Medicine, prior Sept 2007, no ER delay while for Critical Care, no ER Delay prior July 1, 2016 -- these are treated as missing. --JMojica 16:35, 2024 December 11 (CST)
  • SMW


  • Cargo


  • Categories

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)
      • are these still an issue? Ttenbergen 11:15, 2024 May 1 (CDT)
        • I will re-check again. Can't remember if have been resolved. --JMojica 14:40, 2024 October 2 (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 S:\MED\Med_CCMED\​S:\MED\Med_CCMED\Julie\SAS_CFE\CFE_macros\datetimes.sas


  • I just had a look at that sas file (they open as text files) to see how you define transfer delay. If that file is still being used we may have a problem, it still defines tdelay different if a pt goes to a higher level of care, goes AMA or dies, and we changed that some time ago. So is this still the reference of how you calculate this? Ttenbergen 22:50, 2024 November 16 (CST)
  • SMW


  • Cargo


  • Categories

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=168139"