Off ward field: Difference between revisions

Line 13:

{{DJ |

* Any reason we would want to keep the data in this field? [[User:Ttenbergen|Ttenbergen]] 13:48, 2022 August 10 (CDT)

** 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) }}

** 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)

}}

Use of this field is likely inconsistent after 2019-09; we started [[Boarding Loc]] which implies the content of this field but failed to properly phase out this field at the time.

Line 26:

Line 36:

|created_raw=Raw

|data_element_start_date=2016-07-01

|data_element_end_date=2020/01/29

|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 Laptop Admission]] or [[Definition of a Critical Care Laptop 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.

@@ Line 13: / Line 13: @@
 {{DJ |
 * Any reason we would want to keep the data in this field? [[User:Ttenbergen|Ttenbergen]] 13:48, 2022 August 10 (CDT)
-** 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)  }}
+** 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)
+}}
 Use of this field is likely inconsistent after 2019-09; we started [[Boarding Loc]] which implies the content of this field but failed to properly phase out this field at the time.
@@ Line 26: / Line 36: @@
 |created_raw=Raw
 |data_element_start_date=2016-07-01
-|data_element_end_date=2020/01/29
+|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 Laptop Admission]] or [[Definition of a Critical Care Laptop 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.