Off ward field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
link
 
(44 intermediate revisions by 4 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 table
|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 ==
* 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 2016.  CC started tmp Boarding July 2018 while Med on Sept2019.  since 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) 


** Here is a query with counts by send time:
TRANSFORM Count(L_Log.D_ID) AS CountOfD_ID
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 ====
*Off service ward:
**A6.
==== HSC ====
*off service wards:
**RR5 - [[#Medicine_Overflow_HSC_RR5_.26_RR6]]
**RR6
**B5- [[#Medicine_Overflow_HSC_B5]]
==== GRA====
*Off service ward:
*what units are sometimes used off service wards: {{Discussion}}


----
= 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 75: 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 108: Line 84:
* [[Bed borrow]]
* [[Bed borrow]]


=={{CCMDB Data Integrity Checks|implemented}}==
==Cross Checks ==
see [[ACCU_borrow#If_ACCU_entry_then_off-ward_should_be_checked]]
Legacy but still implemented: [[ACCU_borrow#If_ACCU_entry_then_off-ward_should_be_checked]]


== Legacy ==
== Legacy ==
Line 127: Line 103:


[[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.