Query check CCI each count vs LOS: Difference between revisions

Line 14:

The count per patient stay is related to the [[LOS]]. The threshold limits are either Mean + 3 Standard Deviation or Maximum value of Chest X-ray count per patient day for various LOS category listed in the table below. They are derived from July 1988 to June 2017 Lab data. The LOS is based on calendar dates where partial stay is considered as full day.

*LOS based on calendar dates = [[Dispo DtTm]] - ~~[[Arrive DtTm]] + 1~~

*LOS based on calendar dates = [[Dispo DtTm]] - ([[Accept DtTm]]/first [[Service tmp entry]]) + 1

~~{{Discuss | who=Julie | question= would we not use~~ [[Accept DtTm]] ~~here? Because we could have CXRs on days before arrival...~~

* we can use [[~~Accept DtTm]] but with the Tmp~~ Service~~, use the the first service start dttm instead. --[[User:JMojica|JMojica~~]] ~~09:18, 2021 September 2 (CDT~~)}}

** if patient is still in the unit, [[Dispo DtTm]] is replaced by today's date

*** check is marked as only running on complete records, if that is so then we don't need to replace with today's date

*Chest X-ray (CXR) per patient day = Number of chest X-rays / LOS Based on calendar dates

Line 47:

Line 46:

{{DJ |

* is there a function we can use for the threshold? That would be easier to implement than a list like that. If SAS as a way to generate functions (like excel does for its trendlines) then could you run that? [[User:Ttenbergen|Ttenbergen]] 09:02, 2021 September 2 (CDT)

* looks like from the list above, the mean plus 3 std of 2 per day is common except when LOS <1. we can use the function twice of LOS. the CXR should not exceed twice of LOS. when LOS <1, should not exceed 5. When LOS is 51 or more, should not exceed LOS. --[[User:JMojica|JMojica]] 09:18, 2021 September 2 (CDT) }}

** looks like from the list above, the mean plus 3 std of 2 per day is common except when LOS <1. we can use the function twice of LOS. the CXR should not exceed twice of LOS. when LOS <1, should not exceed 5. When LOS is 51 or more, should not exceed LOS. --[[User:JMojica|JMojica]] 09:18, 2021 September 2 (CDT)

*** this cross check is not just for CXR, but any CCI. Do those numbers still make sense? Or does the same check for all CCI not make sense? I am OK if we only want to check for CXR. [[User:Ttenbergen|Ttenbergen]] 14:11, 2021 September 2 (CDT) }}

== Related articles ==

@@ Line 14: / Line 14: @@
 The count per patient stay is related to the [[LOS]]. The threshold limits are either Mean + 3 Standard Deviation or Maximum value of Chest X-ray count per patient day for various LOS category listed in the table below.  They are derived from July 1988 to June 2017 Lab data. The LOS is based on calendar dates where partial stay is considered as  full day.
-*LOS based on calendar dates = [[Dispo DtTm]] - [[Arrive DtTm]] + 1
+*LOS based on calendar dates = [[Dispo DtTm]] - ([[Accept DtTm]]/first [[Service tmp entry]]) + 1
-{{Discuss | who=Julie | question= would we not use [[Accept DtTm]] here? Because we could have CXRs on days before arrival...
-* we can use [[Accept DtTm]]  but with the Tmp Service, use the the first service start dttm instead. --[[User:JMojica|JMojica]] 09:18, 2021 September 2 (CDT)}}
 ** if patient is still in the unit,  [[Dispo DtTm]] is replaced by today's date
+*** check is marked as only running on complete records, if that is so then we don't need to replace with today's date
 *Chest X-ray (CXR) per patient day = Number of chest X-rays / LOS Based on calendar dates
@@ Line 47: / Line 46: @@
 {{DJ |
 * is there a function we can use for the threshold? That would be easier to implement than a list like that. If SAS as a way to generate functions (like excel does for its trendlines) then could you run that? [[User:Ttenbergen|Ttenbergen]] 09:02, 2021 September 2 (CDT)
-* looks like from the list above,  the mean plus 3 std of 2 per day is common except when LOS <1.  we can use the function twice of LOS.  the CXR should not exceed  twice of LOS.  when LOS <1, should not exceed 5. When LOS is 51 or more, should not exceed LOS.  --[[User:JMojica|JMojica]] 09:18, 2021 September 2 (CDT) }}
+** looks like from the list above,  the mean plus 3 std of 2 per day is common except when LOS <1.  we can use the function twice of LOS.  the CXR should not exceed  twice of LOS.  when LOS <1, should not exceed 5. When LOS is 51 or more, should not exceed LOS.  --[[User:JMojica|JMojica]] 09:18, 2021 September 2 (CDT)
+*** this cross check is not just for CXR, but any CCI. Do those numbers still make sense? Or does the same check for all CCI not make sense? I am OK if we only want to check for CXR. [[User:Ttenbergen|Ttenbergen]] 14:11, 2021 September 2 (CDT) }}
 == Related articles ==