Query check CCI each count vs LOS: Difference between revisions

What are likely maximum entries?: deleted standard deviation info since we won't be using that now
Line 47: Line 47:




=== What are likely maximum entries? ===
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 = [[Function LOS()|Function LOS()]] + 1
** 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
{| class="wikitable sortable"
! LOS_days !! N !! Mean !! Std Dev !! Minimum !! Median !! 75th Pctl !! 90th Pctl !! 95th Pctl !! 99th Pctl !! Maximum !! mean + 3 Std Dev !! Limits of CXR per patient day
|-
||1    ||4021||1.16||0.42||1||1||1||2||2||3||5||2.42||5
|-
||2    ||23910||0.83||0.31||0.5||1||1||1||1.5||2||4||1.76||4
|-
||3-10  ||52600||0.64||0.34||0.1||0.67||0.88||1||1.25||1.6||3||1.66||3
|-
||11-20||7784||0.7||0.31||0.05||0.71||0.92||1.09||1.19||1.42||2.47||1.63||2
|-
||21-30||1870||0.68||0.3||0.03||0.69||0.9||1.05||1.14||1.36||2.57||1.58||2
|-
||31-40||660||0.62||0.3||0.03||0.64||0.84||1||1.09||1.32||1.67||1.52||2
|-
||41-50||311||0.54||0.29||0.02||0.53||0.73||0.93||1.02||1.21||1.58||1.41||2
|-
||51-100||347||0.41||0.26||0.02||0.38||0.6||0.76||0.85||1.12||1.2||1.19||1
|-
||> 100||101||0.19||0.21||0.01||0.11||0.2||0.48||0.73||0.88||1.09||0.82||1
|-
|}


{{CCMDB.accdb cross checks triggering for correct values}}
{{CCMDB.accdb cross checks triggering for correct values}}