Moves for Medicine: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
 
(112 intermediate revisions by 4 users not shown)
Line 1: Line 1:
==Moves for Medicine==
{{Project
*'''Primary Purpose of MOVE data:'''
|ProjectActive=legacy
To assess the time delay from when a patient is first accepted to Medicine Service in ER (emergency room) to when the patient actually arrives in a medicine ward bed.
|ProjectProgram=Med
*'''Secondary Purpose of MOVE data:'''
|ProjectRequestor=unknown/legacy
To assess how much time an in-service medicine patient spends on off service wards while still
|ProjectCollectionStartDate=2007-09-01
under a medicine service physician's care. (we will assess this in one year and see if there is any
|ProjectCollectionStopDate=2011-06-03
useful information there).
|Project={{PAGENAME}}
}}
{{LegacyContent
|explanation= We stopped doing it.
|successor=[[Boarding Loc]]
|content=


 


In the Medicine program in each [[Site and Location | hospital]] in the Winnipeg Region, we track, by date, time and location, all individual medicine patients who are accepted and cared for by Medicine service physicians, in the emergency department and in "off service" beds within the facility for the period of time until they arrive onto to an available Med Service bed.


*On September 1, 2007, we started capturing medicine ward patient movements (MOVES) in the tmp file on the PDA. This information is sent to an ACCESS database (TMPV2) on the Regional Server.


*The current “MOVE” data is now much more informative because it not only includes the location that a patient has moved to, but also the date and time therefore we can assess total LOS in ER or in an off-service ward bed.
== Purposes of collecting "Move" data: ==
*With the addition of MOVE data,the tagging of “overflows” in variable slots 3 & 5 at the VIC is now redundant (Nov 1.07 stopped).
#To assess the "time delay" from when a patient is first accepted to Medicine Service while in the site's own ER (emergency room) to when the patient actually arrives in a medicine ward bed of the same hospital. (This is done in conjunction with [[Admit date and time | admit time]]).
#To assess how much time an in-service medicine patient spends on off service [[Site and Location | wards]] while still under a medicine service physician's care.


== Move TO Record is Required ==
#for all patients who are admitted from your '''own site's emergency department'''.
# admitted to a contingency bed (EXCEPTIONS) if, prior to going to a contingency bed, patient was from site's own emergency department.
#*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. 
#Move '''TO''' date/time-for patients that "go to" to off-service ward beds but still under Medicine service therefore, followed as a continuous admission on your ward. 


**need to add more information[[User:TOstryzniuk|TOstryzniuk]] 17:52, 12 August 2008 (CDT)
===Contingency bed exceptions===
*'''EXCEPTIONS''':
**'''HSC''' first move allowed can be to: H7N (contingency beds).
**'''VIC''' first move allowed can be to: S2, N4, N4F (code purple contingency beds)
**'''GRA''' first move allowed can be to: S2, W4, E4 (contingency beds)  
**'''STB''' first move can be - A6S


See [[Admit date and time#Definition for Medicine]] for how to collect the date/time used in the '''"admit date/time"''' field.


===Where to Record Data===
*TMP file in ACCESS ([[CCMDB.accdb]])


===Where is data sent to===
*To[[TmpV2_1.mdb]] in the output folder on the [[Regional Server]]. Data is only sent when all of patient file is complete.


{{stub}}
== Move Record is NOT Required ==
If a patient is NOT from a site's own ER, or is NOT a direct admission that is parked in ER or is NOT using a contingency bed (exceptions) then do NOT record a "move".


[[Category: Medicine Elements]]
Do NOT record a "move" for admission or transfers from:
[[Category: Data Collection Guide]]
*any ICU (MICU, SICU, CCU, IICU)
*any Medicine wards we are collection or not collecting on (except contigency beds).
*between [[Site and Location | hospitals]] in the Region
*operating rooms (OR), recovery rooms (RR)
*transfer to other "non medicine physician services" (i.e. Surgical Service)
*ambulatory care (HA, BA, GA, VA etc).
*XE (ER outside city) or YE (ER outside province, country)
*home (ZZ)
** I have seen a few patients in the database, who have admit from ZZ, yet they have a moved date a few days after being accepted to medicine.  Admit from should be HE not ZZ if there is a move.  If I see this then it is being interpreted as a direct to medicine from home but parked in ER.  Does this happen?  Let me know. (as per note from Trish from Dec 10.07)
*** Well I know it's a long time since the above question was asked but occasionally a patient is to be direct to medicine from home but are parked in ER. How would you like this coded?
**** Yes Trish this has happened  to me (just today a pt was a direct for neuro, pt phoned @ home told to come to the ER for admit and was parked in ER till bed availiable) So I coded ZZ parked in ER ? IS THIS WHAT YOU WANT--[[User:PStein|PStein]] 14:14, 7 April 2011 (CDT)
***** moved here from [[Admit From & Discharged To]] since it's really a moves question. [[User:Ttenbergen|Ttenbergen]] 12:35, 27 July 2011 (CDT)
 
==Start and stop date==
*Start Date: September 1, 2007
*Stop Date: June 3, 2011 as Project Moves, continued as Project ERWait ([[ER Wait]]) starting June 4, 2011 (except data doesn't start then...)
 
==Collection Guideline==
=== Where to enter data ===
*[[L_TmpV2]], Temp. Studies tab on the laptop
Follow the [[Temporary study guidelines]] with the following information:
* '''Moves''' project 
* For each patient move, enter the to ward as the '''item''', and the date & time from the unit log or nurses note.
 
== Legacy Data==
* Collection was started September 1, 2007
* Collection of Moves data made tagging of “overflows” in variable slots [[Med Var 3]] & [[Med Var 5]] at the VIC redundant (Nov 1.07 stopped).
 
== Reporting and Analysis ==
As per email from Julie from 11 Sept 09: Haven’t done any analysis on this, just the data checking which had stopped for sometime. 
*[[Statistician]] is currently working on a a request in regards to move data.--[[User:TOstryzniuk|TOstryzniuk]] 16:20, 11 February 2011 (CST)
**'''June 7, 2011'''-The various "moves" that medicine patient make will no longer be collected.  We will only collect [[ER Wait]] times.  Go to [[ER Wait]] article for details.[[User:TOstryzniuk|TOstryzniuk]] 14:28, 13 June 2011 (CDT)
 
== Data Structure ==
We capture medicine ward patient movements (moves) in [[L_TmpV2]].
The data is sent to and stored in [[TmpV2_1.mdb]].
 
{{Data Integrity Check List|}}
 
[[Category: L_TmpV2 Data]]
[[Category:Legacy Overflow]]
}}

Latest revision as of 20:30, 2024 November 16

Projects
Active?: legacy
Program: Med
Requestor: unknown/legacy
Collection start: 2007-09-01
Collection end: 2011-06-03

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

In the Medicine program in each hospital in the Winnipeg Region, we track, by date, time and location, all individual medicine patients who are accepted and cared for by Medicine service physicians, in the emergency department and in "off service" beds within the facility for the period of time until they arrive onto to an available Med Service bed.


Purposes of collecting "Move" data:

  1. To assess the "time delay" from when a patient is first accepted to Medicine Service while in the site's own ER (emergency room) to when the patient actually arrives in a medicine ward bed of the same hospital. (This is done in conjunction with admit time).
  2. To assess how much time an in-service medicine patient spends on off service wards while still under a medicine service physician's care.

Move TO Record is Required

  1. for all patients who are admitted from your own site's emergency department.
  2. admitted to a contingency bed (EXCEPTIONS) if, prior to going to a contingency bed, patient was from site's own emergency department.
    • 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.
  3. Move TO date/time-for patients that "go to" to off-service ward beds but still under Medicine service therefore, followed as a continuous admission on your ward.

Contingency bed exceptions

  • EXCEPTIONS:
    • HSC first move allowed can be to: H7N (contingency beds).
    • VIC first move allowed can be to: S2, N4, N4F (code purple contingency beds)
    • GRA first move allowed can be to: S2, W4, E4 (contingency beds)
    • STB first move can be - A6S

See Admit date and time#Definition for Medicine for how to collect the date/time used in the "admit date/time" field.

Where to Record Data

Where is data sent to

Move Record is NOT Required

If a patient is NOT from a site's own ER, or is NOT a direct admission that is parked in ER or is NOT using a contingency bed (exceptions) then do NOT record a "move".

Do NOT record a "move" for admission or transfers from:

  • any ICU (MICU, SICU, CCU, IICU)
  • any Medicine wards we are collection or not collecting on (except contigency beds).
  • between hospitals in the Region
  • operating rooms (OR), recovery rooms (RR)
  • transfer to other "non medicine physician services" (i.e. Surgical Service)
  • ambulatory care (HA, BA, GA, VA etc).
  • XE (ER outside city) or YE (ER outside province, country)
  • home (ZZ)
    • I have seen a few patients in the database, who have admit from ZZ, yet they have a moved date a few days after being accepted to medicine. Admit from should be HE not ZZ if there is a move. If I see this then it is being interpreted as a direct to medicine from home but parked in ER. Does this happen? Let me know. (as per note from Trish from Dec 10.07)
      • Well I know it's a long time since the above question was asked but occasionally a patient is to be direct to medicine from home but are parked in ER. How would you like this coded?
        • Yes Trish this has happened to me (just today a pt was a direct for neuro, pt phoned @ home told to come to the ER for admit and was parked in ER till bed availiable) So I coded ZZ parked in ER ? IS THIS WHAT YOU WANT--PStein 14:14, 7 April 2011 (CDT)

Start and stop date

  • Start Date: September 1, 2007
  • Stop Date: June 3, 2011 as Project Moves, continued as Project ERWait (ER Wait) starting June 4, 2011 (except data doesn't start then...)

Collection Guideline

Where to enter data

  • L_TmpV2, Temp. Studies tab on the laptop

Follow the Temporary study guidelines with the following information:

  • Moves project
  • For each patient move, enter the to ward as the item, and the date & time from the unit log or nurses note.

Legacy Data

  • Collection was started September 1, 2007
  • Collection of Moves data made tagging of “overflows” in variable slots Med Var 3 & Med Var 5 at the VIC redundant (Nov 1.07 stopped).

Reporting and Analysis

As per email from Julie from 11 Sept 09: Haven’t done any analysis on this, just the data checking which had stopped for sometime.

  • Statistician is currently working on a a request in regards to move data.--TOstryzniuk 16:20, 11 February 2011 (CST)
    • June 7, 2011-The various "moves" that medicine patient make will no longer be collected. We will only collect ER Wait times. Go to ER Wait article for details.TOstryzniuk 14:28, 13 June 2011 (CDT)

Data Structure

We capture medicine ward patient movements (moves) in L_TmpV2. The data is sent to and stored in TmpV2_1.mdb.

Data Integrity Checks (automatic list)

none found