ER Delay

From CCMDB Wiki
Revision as of 16:35, 2022 June 9 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
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.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


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 Calculation

Implemented as

ER_Delay: IIf([accept_dttm]<#2020-10-01# Or [dispo_dttm]<#2020-10-01#,
IIf([location_name] Like "*EMIP*",[Dispo_DtTm],[Arrive_DtTm])-[Accept_DtTm],
Nz([created_FirstNonER_BoardingLoc].[dttm],[Dispo_DtTm])-[created_FirstER_BoardingLoc].[dttm])

1

  • Discussed with Julie: ER end dttm needs to be:
use first non ER,
if null (this includes old records) then (if not Service/Location EMIP use arrive)
else use dispo (ie for EMIPs)
  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Log

2022-06-09 - updated Created_Variables_Common_maker_2021 query with the new definition.

  • 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: