Query check CCI CXR vs LOS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 10: Line 10:
! LOS_days !! N !! Mean !! Std Dev !! Minimum !! Median !! 75th Pctl !! 90th Pctl !! 95th Pctl !! 99th Pctl !! Maximum !! mean + 3 Std Dev !! Limits
! LOS_days !! N !! Mean !! Std Dev !! Minimum !! Median !! 75th Pctl !! 90th Pctl !! 95th Pctl !! 99th Pctl !! Maximum !! mean + 3 Std Dev !! Limits
|-
|-
1||4021||1.16||0.42||1||1||1||2||2||3||5||2.42||5
||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
||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
||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
||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
||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
||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
||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
||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
||> 100||101||0.19||0.21||0.01||0.11||0.2||0.48||0.73||0.88||1.09||0.82||1
|-
|-
|}
|}

Revision as of 16:27, 2017 July 10

‎We have had some medical imaging lab count entries that are so high that they are likely errors. This check is supposed to do that.

What are likely maximum entries?

The count per patient stay is related to the LOS.

The threshold will be combination of Mean + 3 Standard Deviation or Maximum value of Chest X-ray count per patient days depending on the LOS based on calendar dates (i.e. partial stay is considered as full day)

LOS_days N Mean Std Dev Minimum Median 75th Pctl 90th Pctl 95th Pctl 99th Pctl Maximum mean + 3 Std Dev Limits
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

How the checks will work

At the time you set the patient to complete a check will run to find out if any of the ‎imaging counts are out of range. If none are you won't see this. If a check is out of range you will get an error, and then a list showing the out of range value. Confirm if the value is correct. If it is wrong, fix it. If it is correct and the count was in fact unusually high, then enter a lower number and sent Pagasa an email with the correct count.