ER Wait: Difference between revisions

(7 intermediate revisions by one other user not shown)

Line 1:

{{LegacyContent

|explanation=Existing data was copied into [[~~Accept~~ DtTm field]] so this data can be ignored. Now calculated from [[Boarding Loc]] entries

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

Line 19:

== Dates ==

* Start Date: June 4, 2011

** September 1, 2007 ~~ER Wait~~ was included ~~with~~ [[Moves for Medicine]]

* End Date: June 30, 2016

~~{{DJ |~~

* no ER ~~Wait concept in~~ [[~~Moves for Medicine~~]], ~~so not sure what~~ this ~~means.~~ [[~~User:Ttenbergen|Ttenbergen~~]] ~~13:53~~, 2024 ~~November 14 (CST)~~

== Migration Dates to [[Arrived DtTm field]] ==

}}

* Oct 1, 2003 to Aug 31, 2007

*~~Change Date: July~~ 1, ~~2016~~

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

**~~old TMP Project~~ ER ~~wait data~~ from ~~June 4~~, ~~2011~~ to ~~Jun 30~~, ~~2016 for Medicine profiles, was migrated into~~ the [[Arrived DtTm field]]

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

~~{{DJ|~~

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

* The closest thing I have been able to find to a definition for the earlier state of this is \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\CFE_ERWait_Moves.sas ~~, but that file has a date stamp of 2016-3-17, so it wouldn't have any of the newer developments in it. Is there a definitive file you use? [[User:Ttenbergen|Ttenbergen]] 22:59, 2024 November 16 (CST)~~

* Also, that file uses this project from 2011-06-04 onward, but this project doesn't contain data until 2013-11-23. So we seem to have a gap. [[User:Ttenbergen|Ttenbergen]] 22:59, 2024 November 16 (CST)

}}

[[Category: Legacy Data]]

[[Category:Legacy Data]]

}}

@@ Line 1: / Line 1: @@
 {{LegacyContent
-|explanation=Existing data was copied into [[Accept DtTm field]] so this data can be ignored. Now calculated from [[Boarding Loc]] entries
+|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=
@@ Line 19: / Line 19: @@
 == Dates ==
 * Start Date: June 4, 2011
-** September 1, 2007 ER Wait was included with [[Moves for Medicine]]
+* End Date: June 30, 2016
-{{DJ |
-* no ER Wait concept in [[Moves for Medicine]], so not sure what this means. [[User:Ttenbergen|Ttenbergen]] 13:53, 2024 November 14 (CST)
+== Migration Dates to [[Arrived DtTm field]]  ==
-}}
+*  Oct 1, 2003 to Aug 31, 2007
-*Change Date: July 1, 2016
+** 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]].
-**old TMP Project ER wait data from June 4, 2011 to Jun 30, 2016 for Medicine profiles, was migrated into the [[Arrived DtTm field]]
+* 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 ==
-{{DJ|
+\\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\CFE_ERWait_Moves.sas
-* The closest thing I have been able to find to a definition for the earlier state of this is \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\CFE_ERWait_Moves.sas , but that file has a date stamp of 2016-3-17, so it wouldn't have any of the newer developments in it. Is there a definitive file you use? [[User:Ttenbergen|Ttenbergen]] 22:59, 2024 November 16 (CST)
-* Also, that file uses this project from 2011-06-04 onward, but this project doesn't contain data until 2013-11-23. So we seem to have a gap. [[User:Ttenbergen|Ttenbergen]] 22:59, 2024 November 16 (CST)
-}}
-[[Category: Legacy Data]]
+[[Category:Legacy Data]]
 }}