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 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 Date - Arrival Date + 1
  • if patient is still in the unit, Dispo Date is replaced by Today date
• Chest X-ray (CXR) per patient day = Number of chest X-rays / 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 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

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.