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
m minor
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,558 edits
No edit summary
 
(32 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. (not applicable to ICU)
{{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 Physician Service'' while in the site's '''own ER''' (emergency room) to when the patient '''physically arrives''' to a medicine ward bed of the same hospital. (This is done in conjunction with [[Admit_date_and_time#Definition_for_Medicine]]).
| Project = ER_Wait
| ProjectActive = legacy
| ProjectProgram = Med
| ProjectRequestor =  
| ProjectCollectionStartDate = 2011-06-04
| ProjectCollectionStopDate = 2016-06-30
}}


== Collection Guideline ==
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.


For every patient admitted ''from the ER''', enter date and time arrived to medicine ward bed
Review article history for legacy info, deleted to avoid confusion.


*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.
== Dates ==
* Start Date: June 4, 2011
* End Date: June 30, 2016


*project: '''ER_Wait'''  
== Migration Dates to [[Arrived DtTm field]]  ==
*as appropriate one of the following items
*  Oct 1, 2003 to Aug 31, 2007
**'''ER admit''' - is the date/time patient arrives on Medicine ward from the ER.  
** 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]].
**'''[[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.)
* 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.  


*the date & time arrived in med ward bed from the unit log or nurses note.
== SAS ==
\\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\CFE_ERWait_Moves.sas 


===TMP file entry===
[[Category: Legacy Data]]
*PROJECT:
}}
**ER_Wait
*ITEM:
**'''ER admit''' (NOTE: For Medicine only, 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"