ER Wait: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,558 edits
No edit summary
 
(43 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
}}


==Start and stop date==
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.  
*Start Date: June 4, 2011  (NOTE: September 1, 2007 ER Wait was included with [[Moves for Medicine]]).
*Stop Date: none


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


*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 or direct admit
*E:  Date (arrived on ward bed)
*M:  time (arrived to ward bed)
 
== Sending to TmpV2.1mdb ==
ER Wait data is sent to [[Regional Server]] only when all of the patients data file is complete and also being sent in.
 
== Reporting and Analysis ==
Julie?
{{discussion}}
*because there was a change made to ITEM in temp for ER Wait, which was not the plan,  Julie must reprogram her SAS to pull data from TmpV2.1mdb two different ways to calculate delay to ward bed from the ER.  --[[User:TOstryzniuk|TOstryzniuk]] 14:08, 16 June 2011 (CDT)
 
=={{Data Integrity Checks}}==
=== ER Wait and from-ER consistency ===
* uses the following queries
** s_tmp_ER_Wait_has_tmp_not_from_ER
** s_tmp_ER_Wait_from_ER_no_ER_Wait
** s_tmp_ER_Wait_chronological
** 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]]

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"