Off ward field: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) link |
|||
(49 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
{{ | 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 | |CCMDB_label=Off Ward | ||
|CCMDB_tab=Dispo | |||
|in_table=L_Log table | |||
|data_type=number | |||
|datafield_length=long integer | |||
|program_collecting=Med and CC | |||
|created_raw=Raw | |||
|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. | |||
}} | }} | ||
== | == 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 | |||
** I | 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) | |||
---- | |||
= 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 | [[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 | ===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: | [[Category: Legacy 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.