ER Wait: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,558 edits
No edit summary
 
(33 intermediate revisions by 3 users not shown)
Line 1: Line 1:
We track the time medicine patients spend in the ER before being admitted to a medicine ward bed.
{{LegacyContent
|explanation=Existing data was copied into [[Arrived DtTm field]] so this data can be ignored. Now calculated from [[Boarding Loc]] entries
|successor=[[ER Delay]]
|content=


== Purposes of collecting "ER Wait" data: ==
{{Project
To assess the "time delay" from when a patient is first accepted to Medicine Service while in the site's own ER (emergency room) to when the patient actually arrives in a medicine ward bed of the same hospital. (This is done in conjunction with [[Admit date and time | admit time]]).
| Project = ER_Wait
| ProjectActive = legacy
| ProjectProgram = Med
| ProjectRequestor =
| ProjectCollectionStartDate = 2011-06-04
| ProjectCollectionStopDate = 2016-06-30
}}


We used to track the track the time accepted medicine patients spent in the ER before physically arriving on the ward/unit in the tmp file. See [[ER Delay]] for how this is tracked now.


== Collection Guideline ==
Review article history for legacy info, deleted to avoid confusion.


For every patient admitted from the ER, enter date and time arrived to medicine ward bed
== Dates ==
* Start Date: June 4, 2011
* End Date: June 30, 2016


*Any patient admitted '''from the ER''' must have one ER Wait date/time entered into tmp file. It does not matter if first bed moved to into an in-service or off-service bed.
== Migration Dates to [[Arrived DtTm field]]  ==
*  Oct 1, 2003 to Aug 31, 2007
** When patient is admitted from site's OWN emergency department (ER), the physical arrival date/time to the medicine ward bed is not yet collected.  The entry in the [[Arrived DtTm]] is made the same as the [[Accept DtTm]].
* September 1, 2007  to June 3, 2011 : the concept of "actual arrival date/time" to the medicine ward bed was included in tmp [[Moves for Medicine]]
** This is when a patient is "MOVED" from site's OWN emergency department (ER), the first "MOVE" is the "actual arrival date/time" to the medicine ward bed.
** These cases coming from own ER can be migrated into the [[Arrived DtTm field]] - to be done by Julie on Dec 16, 2024.
* June 4, 2011 to June 30, 2016
**The dttm from this Project [[ER Wait]] was migrated into the [[Arrived DtTm field]] for the Medicine profiles on July 1, 2016
* July 1, 2016 to Mar 22, 2024
** The  physical arrival date/time to the Med ward is saved in the [[Arrived DtTm field]] 
* Oct 1, 2020 to present
** The tmp [[Boarding Loc]] also collects the "actual arrival date/time"  when  a patient is moved  to the next location. When a Med patient is "MOVED" from site's OWN emergency department (ER), the first "MOVE" is the "actual arrival date/time" to the medicine ward bed.  This is equivalent to the concept in the [[Arrived DtTm field]].   
** The overlapping period from Oct 1, 2020 to Mar 22, 2024 of the [[Boarding Loc]] and [[Arrived DtTm field]] must give the same date/time value.  


*project: '''ER_Wait'''
== SAS ==
*as appropriate one of the following items
\\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\CFE_ERWait_Moves.sas 
**'''ER admission''' - is a patient who is admitted '''TO a medicine service physician ''' '''FROM a '''ER physician service.
**'''[[Direct admit|Direct Admission]]''' - A direct admission means direct admission '''TO medicine physician service''' but for some reason parked in ER before going to a ward bed. These patients are NOT admitted under a ER physician service prior to being accepted to medicine service. (NOTE: Inter-facility transfers in the region, e.g. ward to another hospital's ward, are not included in this project.)


*the date & time arrived in med ward bed from the unit log or nurses note.
[[Category: Legacy Data]]
 
}}
===TMP file entry===
*PROJECT:
**ER_Wait
*ITEM:
**ER Admit (NOTE: For Medicine this is the '''ward arrival''' date and time)
**direct admit
*Column E:  Date (arrived on ward bed)
*Column M:  time (arrived to ward bed)
 
{{Discussion}}
*The Item label, in TMP, for this project would prefer it to be changed to: ''' ward arrival''' rather than ER Admit. This is more intuitive label.-[[User:TOstryzniuk|Trish Ostryzniuk]] 18:23, 2015 December 8 (CST)
 
== Collection Parameters ==
 
*Start and stop date
**Start Date: June 4, 2011 
**Stop Date: none
*Data is sent when complete and upon final check.
*Data is saved in L_TmpV2 under Project 'ER_Wait' of the centralized_data.mdb
*Prior ER Wait data
**From Sept 1, 2007 to June 3, 2011, ER wait is under the Project 'Moves' ([[Moves for Medicine]]).
**Note that the collection guideline of the Project 'Moves' is different from the Project ER_Wait.
== Reporting and Analysis ==
 
*ER Wait is calculated as the difference between the Arrival in Ward Date_time - Admit Date_Time
*The SAS Program to read the data is in X:\Julie\SAS_CFE\CFE_macros\CFE_ERWait.sas
 
=={{Data Integrity Checks}}==
=== ER Wait and from-ER consistency ===
* uses the following queries
** s_tmp_ER_Wait_has_tmp_not_from_ER - error if ER wait entry but is not from ER
** s_tmp_ER_Wait_from_ER_no_ER_Wait - error if from ER but has no ER wait entry
** s_tmp_ER_Wait_chronological - error if tmp date/time is null or is <= admit date/time
** s_tmp_ER_Wait_long_delay - gives error if delay is > 3 days
 
== Data Structure ==
We capture ER Wait (moves) in [[L_TmpV2]].
The data is sent to and stored in [[TmpV2_1.mdb]].
 
 
 
 
 
[[Category: Medicine Elements]]
[[Category: L_TmpV2 Data]]
[[Category: All Projects Medicine Only]]
[[Category: Multiple Encounter linking]]
[[Category: Dispo]]

Latest revision as of 11:17, 17 December 2024

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

Projects
Active?: legacy
Program: Med
Requestor:
Collection start: 2011-06-04
Collection end: 2016-06-30

We used to track the track the time accepted medicine patients spent in the ER before physically arriving on the ward/unit in the tmp file. See ER Delay for how this is tracked now.

Review article history for legacy info, deleted to avoid confusion.

Dates

  • Start Date: June 4, 2011
  • End Date: June 30, 2016

Migration Dates to Arrived DtTm field

  • Oct 1, 2003 to Aug 31, 2007
    • When patient is admitted from site's OWN emergency department (ER), the physical arrival date/time to the medicine ward bed is not yet collected. The entry in the Arrived DtTm is made the same as the Accept DtTm.
  • September 1, 2007 to June 3, 2011 : the concept of "actual arrival date/time" to the medicine ward bed was included in tmp Moves for Medicine
    • This is when a patient is "MOVED" from site's OWN emergency department (ER), the first "MOVE" is the "actual arrival date/time" to the medicine ward bed.
    • These cases coming from own ER can be migrated into the Arrived DtTm field - to be done by Julie on Dec 16, 2024.
  • June 4, 2011 to June 30, 2016
  • July 1, 2016 to Mar 22, 2024
  • Oct 1, 2020 to present
    • The tmp Boarding Loc also collects the "actual arrival date/time" when a patient is moved to the next location. When a Med patient is "MOVED" from site's OWN emergency department (ER), the first "MOVE" is the "actual arrival date/time" to the medicine ward bed. This is equivalent to the concept in the Arrived DtTm field.
    • The overlapping period from Oct 1, 2020 to Mar 22, 2024 of the Boarding Loc and Arrived DtTm field must give the same date/time value.

SAS

\\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\CFE_ERWait_Moves.sas

Retrieved from "https://ccmdb.kuality.ca/index.php?title=ER_Wait&oldid=162209"