Query check CCI each count vs LOS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) deferring until we know how this will work in CCI |
||
| Line 5: | Line 5: | ||
| DIC_timing = complete | | DIC_timing = complete | ||
| DIC_app = CCMDB.mdb | | DIC_app = CCMDB.mdb | ||
| DIC_coding = | | DIC_coding = | ||
| DIC_status = | | DIC_status = needs review | ||
| DIC_implementation_date = | | DIC_implementation_date = | ||
}} | }} | ||
{{Discuss | who = Tina | question = * [[CXR]] will become [[CCI]] [[CXR (plain film)]], which will change how this check would work. It is not yet clear how exactly [[CXR (plain film)]] will be entered in CCI, so deferring check for now. }} | |||
We have had some medical [[:Category:Labs Imaging]] count entries that are so high that they are likely errors. | We have had some medical [[:Category:Labs Imaging]] count entries that are so high that they are likely errors. | ||
Revision as of 17:52, 24 November 2018
| Data Integrity Checks | |
| Summary: | Confirm that a Category:Labs Imaging count is not unreasonably high |
| Related: | CXR, LOS, Arrive DtTm, Dispo DtTm |
| Firmness: | hard check |
| Timing: | complete |
| App: | CCMDB.mdb |
| Coding: | |
| Uses L Problem table: | not relevant for this app |
| Status: | needs review |
| Implementation Date: | |
| Backlogged: | true |
|
|
We have had some medical Category:Labs Imaging count entries that are so high that they are likely errors.
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 |
Template:CCMDB.mdb cross checks triggering for correct values