|
|
| (32 intermediate revisions by 3 users not shown) |
| Line 1: |
Line 1: |
| We track the time '''Medicine''' patients spend in the ER before being admitted to a medicine ward bed. (not applicable to ICU)
| | {{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= |
|
| |
|
| == Purposes of collecting "ER Wait" data: == | | {{Project |
| To assess the '''time delay''' from when a patient is first accepted to '''Medicine Physician Service'' while in the site's '''own ER''' (emergency room) to when the patient '''physically arrives''' to a medicine ward bed of the same hospital. (This is done in conjunction with [[Admit_date_and_time#Definition_for_Medicine]]).
| | | Project = ER_Wait |
| | | ProjectActive = legacy |
| | | ProjectProgram = Med |
| | | ProjectRequestor = |
| | | ProjectCollectionStartDate = 2011-06-04 |
| | | ProjectCollectionStopDate = 2016-06-30 |
| | }} |
|
| |
|
| == Collection Guideline ==
| | 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. |
|
| |
|
| For every patient admitted ''from the ER''', enter date and time arrived to medicine ward bed
| | Review article history for legacy info, deleted to avoid confusion. |
|
| |
|
| *Any patient admitted '''from the ER''' MUST have one ER Wait date/time entered into tmp file. It does not matter if first bed moved to into an in-service or off-service bed. | | == Dates == |
| | * Start Date: June 4, 2011 |
| | * End Date: June 30, 2016 |
|
| |
|
| *project: '''ER_Wait''' | | == Migration Dates to [[Arrived DtTm field]] == |
| *as appropriate one of the following items | | * Oct 1, 2003 to Aug 31, 2007 |
| **'''ER admit''' - is the date/time patient arrives on Medicine ward from the ER. | | ** 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]]. |
| **'''[[Direct admit|Direct Admission]]''' - A direct admission means direct admission '''TO medicine physician service''' but for some reason parked in ER before going to a ward bed. These patients are NOT admitted under a ER physician service prior to being accepted to medicine service. (NOTE: Inter-facility transfers in the region, e.g. ward to another hospital's ward, are not included in this project.) | | * 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. |
|
| |
|
| *the date & time arrived in med ward bed from the unit log or nurses note.
| | == SAS == |
| | \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\CFE_ERWait_Moves.sas |
|
| |
|
| ===TMP file entry===
| | [[Category: Legacy Data]] |
| *PROJECT:
| | }} |
| **ER_Wait
| |
| *ITEM:
| |
| **'''ER admit''' (NOTE: For Medicine only, this is the '''ward arrival''' date and time.)
| |
| **'''direct admit'''
| |
| *Column E: Date (arrived on ward bed)
| |
| *Column M: time (arrived to ward bed)
| |
| | |
| {{Discussion}}
| |
| *The Item label, in TMP, for this project would prefer it to be changed to: ''' ward arrival''' rather than ER admit. This is more intuitive label.-[[User:TOstryzniuk|Trish Ostryzniuk]] 18:23, 2015 December 8 (CST)
| |
| | |
| == Collection Parameters ==
| |
| | |
| *Start and stop date
| |
| **Start Date: June 4, 2011
| |
| **Stop Date: none
| |
| *Data is sent when complete and upon final check.
| |
| *Data is saved in L_TmpV2 under Project 'ER_Wait' of the centralized_data.mdb
| |
| *Prior ER Wait data
| |
| **From Sept 1, 2007 to June 3, 2011, ER wait is under the Project 'Moves' ([[Moves for Medicine]]).
| |
| **Note that the collection guideline of the Project 'Moves' is different from the Project ER_Wait.
| |
| == Reporting and Analysis ==
| |
| | |
| *ER Wait is calculated as the difference between the Arrival in Ward Date_time - Admit Date_Time
| |
| *The SAS Program to read the data is in X:\Julie\SAS_CFE\CFE_macros\CFE_ERWait.sas
| |
| | |
| =={{Data Integrity Checks}}==
| |
| === ER Wait and from-ER consistency ===
| |
| * uses the following queries
| |
| ** 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_long_delay - gives error if delay is > 3 days
| |
| | |
| == Data Structure ==
| |
| We capture ER Wait (moves) in [[L_TmpV2]].
| |
| The data is sent to and stored in [[TmpV2_1.mdb]].
| |
| | |
| | |
| | |
| | |
| | |
| [[Category: Medicine Elements]]
| |
| [[Category: L_TmpV2 Data]]
| |
| [[Category: All Projects Medicine Only]]
| |
| [[Category: Multiple Encounter linking]]
| |
| [[Category: Dispo]]
| |