ER Wait

Legacy Content

This page contains Legacy Content.

• Explanation: Existing data was copied into Arrived DtTm field so this data can be ignored. Now calculated from Boarding Loc entries
• Successor: ER Delay

Expand

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
  • 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