Query check CCI CXR vs LOS

‎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 day depending on the LOS based on calendar dates (i.e. partial stay is considered as full day)

LOS based on calendar dates =

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.