ER Wait: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(15 intermediate revisions by 2 users not shown)
Line 1: Line 1:
#redirect: [[ER Delay]]
{{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=
 
{{Project
| 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.  
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.  
Line 5: Line 17:
Review article history for legacy info, deleted to avoid confusion.  
Review article history for legacy info, deleted to avoid confusion.  


== Legacy Info ==
== Dates ==
*Start Date: June 4, 2011  
* Start Date: June 4, 2011  
**NOTE: September 1, 2007 ER Wait was included with Moves Tmp Project Data for Medicine
* End Date: June 30, 2016
*Change Date: July 1, 2016
 
**old TMP Project ER wait data from June 4, 2011 to Jun 30, 2016 for Medicine profiles, was migrated into the [[Accept DtTm field]]
== 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 10:32, 30 July 2025

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