Query check CCI each count vs LOS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
mNo edit summary
mNo edit summary
Line 1: Line 1:
‎We have had some medical [[:Category:Labs Imaging]] count entries that are so high that they are likely errors. This check is supposed to do that.
‎{{Data Integrity Check
| DIC_summary = Confirm that a [[:Category:Labs Imaging]] count is not unreasonably high
| DIC_related_concepts = [[:Category:Labs Imaging]], [[LOS]], [[ArriveDtTm]], [[DispoDtTm]]
| DIC_firmness = hard check
| DIC_timing = complete
| DIC_app = CCMDB.mdb
| DIC_coding = how to find this in containing program, eg. SAS file, function name, query name...
| DIC_status = ready to implement
| DIC_implementation_date =
}}
 
We have had some medical [[:Category:Labs Imaging]] count entries that are so high that they are likely errors.  


=== What are likely maximum entries? ===
=== 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.  
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.  


Line 32: Line 42:
|}
|}


=== How the checks will work===
{{CCMDB.mdb cross checks triggering for correct values}}
 
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.


{{CCMDB Data Integrity Checks| ready to implement}}


[[category:Labs]]
[[category:Labs]]

Revision as of 12:37, 25 September 2018

‎

Data Integrity Checks
Summary: Confirm that a Category:Labs Imaging count is not unreasonably high
Related: [[Category:Labs Imaging, LOS, ArriveDtTm, DispoDtTm]]
Firmness: hard check
Timing: complete
App: CCMDB.mdb
Coding: how to find this in containing program, eg. SAS file, function name, query name...
Uses L Problem table: not relevant for this app
Status: ready to implement
Implementation Date:
Backlogged: true
  • Cargo


  • SMW
"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "Category:Labs Imaging]], LOS, ArriveDtTm, [[DispoDtTm" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.
  • Categories:  
  • form:

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

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_each_count_vs_LOS&oldid=120129"