Off ward field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Ppiche (talk | contribs)
link
 
(49 intermediate revisions by 5 users not shown)
Line 1: Line 1:
{{Data_element
Are now collected as part of [[Using Cognos2 to keep track of patients]] / [[Boarding Loc]]
| field_name = off_ward
 
| CCMDB_label = Off Ward
{{Data element
| CCMDB_tab = Dispo
|field_name=off_ward
| element_description = Checked/true if the patient who meets the [[Definition of a Medicine Service admission]] or [[Definition of an ICU admission]] spent '''any''' time in a bed that is not at their actual collection location between [[Arrive DtTm]] and [[Dispo DtTm]]. The patient must be covered by the attending of the service of the home unit that is credited with the "off ward" designation. --[[User:LKolesar|LKolesar]] 07:22, 2017 October 12 (CDT)
|CCMDB_label=Off Ward
| in_table = L_Log
|CCMDB_tab=Dispo
| data_type = number
|in_table=L_Log table
| datafield_length = long integer
|data_type=number
| program_collecting = Med and CC
|datafield_length=long integer
| created_raw = Raw
|program_collecting=Med and CC
| data_element_start_date = 2016-07-01
|created_raw=Raw
| data_element_sort_index = 39
|data_element_start_date=2016-07-01
|data_element_end_date=2020-01-29
|data_element_sort_index=39
|element_description=Checked/true if the patient who meets the [[Definition of a Medicine Program Admission]] or [[Definition of a Critical Care Program Admission]] spent '''any''' time in a bed that is not at their actual collection location between "Arrive DtTm" and [[Dispo DtTm]]. The patient must be covered by the attending of the service of the home unit that is credited with the "off ward" designation.
}}
}}


This includes patients who spend part or all of their admission located on an off service ward, but not [[#EMIP]]s.


== Collection Instructions ==
== Legacy ==
moved from [[Overstay Predictor Project Collection Instructions]]:
* Allan suggested this OFFWARD field for some reasons related to outcome. you are right  the tmp  Boarding  will indicate  patients staying in offward locations.  Offward started July 2016CC started tmp Boarding July 2018 while Med on Sept2019since offward start date was before any of these BL dates, we need to keep  those data in prior dates. --[[User:JMojica|JMojica]] 16:18, 2022 August 12 (CDT)
'''May 13, 2013''' - HSC medicine data collection will follow all OVERFLOW patient that are going to RR5 & RR6. These are patients that are under a medicine attending service while on '''RR5''' or '''RR6'''They are sent there from medicine wards we are collecting on at HSC. They are also admitted there under Internal medicine service attending physicians from the ER department.[[User:TOstryzniuk|Trish Ostryzniuk]] 16:20, 2013 June 14 (EDT)
{{discussion}}
*Does the note above belong here? Are these patients a special category that does not meet the definition for "off ward"?  Trish, you wrote this, please let me know if I can delete this? Trying to clean up this article.--[[User:LKolesar|LKolesar]] 07:06, 2017 October 12 (CDT)


Medical records will auto print patient list for RR5 & RR6 directly to the printer in GF216HSC collector should now have access to ADT (Admit/Transfer/Discharge) for patient wards list via [[EPR]] alsoIf not, please contact '''Denise Felbel''' (she is in global address in your email).
** Here is a query with counts by send time:
* is this info in any way special for the overstay project? If not it should be stored on a more appropriate page on the wiki. Ttenbergen 17:56, 2013 August 8 (CDT) {{discussion}}
TRANSFORM Count(L_Log.D_ID) AS CountOfD_ID
** I would like to delete the complete section above, as I do not think it should be here. Trish please assess this and let me know, thanks!--[[User:LKolesar|LKolesar]] 07:28, 2017 October 12 (CDT)
  SELECT Format([SentDtTm],"yy-mm") AS send_month
FROM L_Log
GROUP BY Format([SentDtTm],"yy-mm")
ORDER BY Format([SentDtTm],"yy-mm"), L_Log.off_ward
  PIVOT L_Log.off_ward;
::: It actually looks like we used this from 2014 onward, even if the data definition on this page says from 2016. 
There is a weird spike in Jan 2018, other than that numbers in a similar range between 16-07 and 20-03. So from when until when would we consider this data reliable? We should likely clean up values outside that range so no one thinks records are reliably tagged outside that range. [[User:Ttenbergen|Ttenbergen]] 11:23, 2022 August 23 (CDT)
** For the  pre2016 profiles, the OFFWARD field is pre-populated by the old VAR3, [[ICU Var 4 - Parked in ER]] , VAR5 (see below) and therefore they are reliable.  Actually Var3 to Var5 specify the units  they are overflowing (similar with tmp Boarding but only with location and no start dates). If I remember right, when Allan introduced OFFWARD, he was thinking of the specific location but the idea was not received well and so decided just to be binary code YES/NO.  For research project needing historical data, I think binary data would  still be useful. we can either keep it AS IS  or be saved  as tmp project.   --[[User:JMojica|JMojica]] 15:38, 2022 August 29 (CDT)  


=== How to identify off-ward patients ===
<details needed>
{{discussion}} Current way of checking through transfer list from ER will miss [[off ward]] patients who arrived at off-ward locations from elsewhere than emerg. Laura and Tina discussed, did not find solution yet, should be rare, though. 13:41, 2017 March 1 (CST)
see also [[EPR Reports]], [[Discharge Register]], [[Transfer Register]]
We collect data on some patients who never arrive on one of our units, e.g. [[EMIP]]s{{discussion}} any other scenarios?)
{{Discussion}}
=== Process for identifying Off ward Patients ===
# Go to Citrix Apps on Desktop
# Click on EPR Reports
# Log in with username and password  (same as your initial log into your computer)
# Click on “Patient List Reports”
# Click on “Transfer Register”
# Fill in Facility (hospital you are checking)
# Put in a time frame that you wish to search.  Do not use the current date as you want it to reflect full days, not a partial day.
# Fill in unit as "emergency" of the correct facility 
# Under “unit filters on”, select “from or to”.  All other fields remain unchanged.
# Click on "View Report" button.
# Scroll though the list to look for only internal medicine patients that went to off-service wards.  (Do not count patients that go to the ICU). 
***Note:  occasionally, when reveiwing this generated list you will also notice some patients that are actually EMIP patients that ended up going to other wards after leaving ER. These would not be off ward patients but, instead would be entered as EMIP's.  For example,  the pt, while in ER was accepted by medicine, then, before leaving ER, they changed service to ICU or Surgery or Palliative, etc.  These are actually captured as EMIP's.  So if the pt went to ICU the [[Pre-admit Inpatient Institution]] and the [[Previous Location]] would be EMIP. --[[User:LKolesar|LKolesar]] 12:46, 2017 March 2 (CST)
==== Vic ====
*  Example of a VIC OFF WARD scenario: Patient on a collection unit transferred to Urgent Care for assessment then returned to collection Unit and the bed was held for patient
==== STB ====
common off ward location A6.


----
= Old instructions =
This includes patients who spend part or all of their admission located on an off service ward, but not [[#EMIP]]s.
== How to enter patient into CCMDB ==
== How to enter patient into CCMDB ==
=== Collection Instructions - '''current''' ward ===
=== Collection Instructions - '''current''' ward ===
Line 71: Line 51:


=== EMIP ===
=== EMIP ===
[[EMIP]]s are in their collection location, e.g. GRA_EMIP, so they are not off ward. Don't check the field.  
[[EMIP]]s are in their collection location, e.g. [[GRA_EMIP]], so they are not off ward. Don't check the field.  


=== Parked in ER ===
=== Parked in ER ===
[[Parked in ER]] is before [[Arrive DtTm]], so they are not "off ward".  Don't check the field.
[[Parked in ER]] is before ''Arrive DtTm'', so they are not "off ward".  Don't check the field.
# find patients as per [[off ward field]] article
# find patients as per [[off ward field]] article
# Write down a list of these patients with their chart numbers on a paper.
# Write down a list of these patients with their chart numbers on a paper.
Line 84: Line 64:
*This patient list can be posted on the bulletin board of the medicine office.  If they are admitted to one of the medicine wards, then that data collector will cross that person off the list.  Once a week check if the pt is still in the hospital, if they have left and were never admitted to one of the medicine wards, then a designated data collector will enter them on her laptop. --[[User:LKolesar|LKolesar]] 12:54, 2017 March 2 (CST)
*This patient list can be posted on the bulletin board of the medicine office.  If they are admitted to one of the medicine wards, then that data collector will cross that person off the list.  Once a week check if the pt is still in the hospital, if they have left and were never admitted to one of the medicine wards, then a designated data collector will enter them on her laptop. --[[User:LKolesar|LKolesar]] 12:54, 2017 March 2 (CST)


===Patients who are on off service wards part of their stay only===
===Patients who are on a off wards for part of their stay only===
*When a pt comes to one of the medicine wards from an off-service ward, the data collector must go to the original presentation of the pt to see if this pt was accepted to medicine on the off-service ward prior to their arrival on their own ward.  If you see that the pt was looked after by internal medicine prior to their arrival from the other ward, make sure you start your profile on the original date that medicine accepted them (usually in ER).   
*When a pt comes to one of the medicine wards from an off-service ward, the data collector must go to the original presentation of the pt to see if this pt was accepted to medicine on the off-service ward prior to their arrival on their own ward.  If you see that the pt was looked after by internal medicine prior to their arrival from the other ward, make sure you start your profile on the original date that medicine accepted them (usually in ER).   
*On occasion, medicine patients are transferred to off service wards, but are still admitted under the internal medicine service.  ie. patient transferred from a medical ward to a surgical ward but still are admitted under internal medicine service.  The attending may be different than the admitting service but it is still an internal medicine attending.  Please continue to follow these patients (new profile is '''not''' required) until they are discharged or transferred to an off service ward under family medicine or any other service other than internal med.  Please note the location in the RECORD box to indicate where the pt is currently located. --[[User:LKolesar|LKolesar]] 13:05, 2017 March 2 (CST)
*On occasion, medicine patients are transferred to off service wards, but are still admitted under the internal medicine service.  ie. patient transferred from a medical ward to a surgical ward but still are admitted under internal medicine service.  The attending may be different than the admitting service but it is still an internal medicine attending.  Please continue to follow these patients (new profile is '''not''' required) until they are discharged or transferred to an off service ward under family medicine or any other service other than internal med.  Please note the location in the RECORD box to indicate where the pt is currently located. --[[User:LKolesar|LKolesar]] 13:05, 2017 March 2 (CST)
Line 103: Line 83:
== See also ==
== See also ==
* [[Bed borrow]]
* [[Bed borrow]]
==Cross Checks ==
Legacy but still implemented: [[ACCU_borrow#If_ACCU_entry_then_off-ward_should_be_checked]]


== Legacy ==
== Legacy ==
Line 115: Line 98:


Old data would be transferred to new fields where the translation is not ambiguous. We can keep a snapshot of Centralized with the data pre-translation in case we ever want to go back to it.  
Old data would be transferred to new fields where the translation is not ambiguous. We can keep a snapshot of Centralized with the data pre-translation in case we ever want to go back to it.  
== Related Articles ==
{{Related Articles}}


[[Category: 2016 Time and Place changes]]
[[Category: 2016 Time and Place changes]]
[[Category: Data Collection Guide]]
[[Category: Legacy Overflow]]
[[Category: Registry Data]]
 
[[Category: Overflow]]

Latest revision as of 18:49, 13 March 2025

Are now collected as part of Using Cognos2 to keep track of patients / Boarding Loc


 
 
 
 

Legacy Content

This page contains Legacy Content.

  • Explanation: This is a legacy data field, its DataElementEndDate is in the past.
  • Successor: No successor was entered

Click Expand to show legacy content.