ER Wait: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m changed start dt from 2011-06-02 to 2013-11-23 because that's the earliest record in our db |
No edit summary |
||
| (9 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{LegacyContent | {{LegacyContent | ||
|explanation=Existing data was copied into [[ | |explanation=Existing data was copied into [[Arrived DtTm field]] so this data can be ignored. Now calculated from [[Boarding Loc]] entries | ||
|successor=[[ER Delay]] | |successor=[[ER Delay]] | ||
|content= | |content= | ||
| Line 9: | Line 9: | ||
| ProjectProgram = Med | | ProjectProgram = Med | ||
| ProjectRequestor = | | ProjectRequestor = | ||
| ProjectCollectionStartDate = | | ProjectCollectionStartDate = 2011-06-04 | ||
| ProjectCollectionStopDate = 2016- | | ProjectCollectionStopDate = 2016-06-30 | ||
}} | }} | ||
| Line 19: | Line 19: | ||
== Dates == | == Dates == | ||
* Start Date: June 4, 2011 | * 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 11:17, 17 December 2024
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
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