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,596 edits
to be continued
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,596 edits
No edit summary
 
(20 intermediate revisions by 3 users not shown)
Line 1: Line 1:
We track the time accepted patients spend in the ER before physically arriving on the ward/unit.
{{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=


The data is collected as part of regular data collection, specific instructions are in the relevant component fields.
{{Project
| Project = ER_Wait
| ProjectActive = legacy
| ProjectProgram = Med
| ProjectRequestor =
| ProjectCollectionStartDate = 2011-06-04
| ProjectCollectionStopDate = 2016-06-30
}}


== Purpose ==
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.  
To assess the '''[[ER Delay]]''' from when a patient is first accepted to service while in the site's '''own ER''' (emergency room) to when the patient '''physically arrives''' .


[[ER Delay]] is calculated as the difference [[Arrive DtTm]] - [[Accept DtTm]] for patients coming from ER in [[CFE]]
Review article history for legacy info, deleted to avoid confusion.  
 
=={{Data Integrity Checks}}==
=== ER Wait and from-ER consistency ===
* uses the following queries
** s_tmp_ER_Wait_long_delay - gives error if delay is > 3 days
 
The following can go as last pre-dispo patients are discharged:
[[Category: Dispo]]
* 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_duplicate_entry - gives error if more than one ER wait entry
 
== Legacy ==
[[Category: L_TmpV2 Data]]
*This used to be collected as a tmp project.
*As of 2016-07-01 it will only be collected as part of [[2016 Time and Place changes]].
**PROJECT:
**ER_Wait
**ITEM:
***'''ER admit''' ( if coming from own hospital ER)
***'''Direct admit''' (if coming from other location, facility or hospital and not your own hospital ER, ward, ICU)
**Column E:  Date (arrived on ward bed)
**Column M:  time (arrived to ward bed)
**Column Q:  'Parked in ER' if '''Direct admit'''
*Cleaned out old wiki instructions that might confuse.
 
*Conversion of data from tmp [[ER Wait]] project to Centralized_data
**The date and time in the [[ER Wait]] for patients coming from ER populated the ArriveDtTm in the L_LOG table. The


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


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


[[Category: Legacy Data]]
[[Category: Legacy Data]]
}}

Latest revision as of 12:17, 17 December 2024

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

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