Off ward field: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) link |
||
(44 intermediate revisions by 4 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 | |||
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 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 | [[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]] | ||
== | ==Cross Checks == | ||
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: | [[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.