CCMDB Wiki

Query check CCI each count vs LOS: Difference between revisions

← Older edit
mNo edit summary
No edit summary
 
(51 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = Confirm that a [[:Category:Labs Imaging]] count is not unreasonably high
|DIC_summary=Confirm that a [[:Category:Labs Imaging]] count is not unreasonably high
| DIC_related_concepts = CXR (plain film); LOS; Arrive DtTm; Dispo DtTm
|DIC_related_concepts=Blood gas, venous; Blood gas, arterial; CXR (plain film); Angiogram, aortic (any part of aorta); Angiogram, coronary (diagnostic cardiac catheterization); ECHO (echocardiogram of heart); Cardiac CT or Cardiac CT angiogram (with or without coronary arteries); Cardiac MRI; Cardiac nuclear scan (e.g. MUGA); Angiogram, cerebral (including vertebral arteries); CT of chest with PE protocol (CT angiogram of pulmonary vessels); Angiogram, artery NOS (except specifically coded); Angiogram, vein; Angiogram, pulmonary artery (pulmonary arteriogram); AXR (abdominal plain X-ray); LOS
| DIC_firmness = hard check
|DIC_firmness=soft check
| DIC_timing = complete
|DIC_timing=complete
| DIC_app = CCMDB.mdb
|DIC_coding=query ''check_CCI_each_count_vs_LOS''
| DIC_coding =  
|DIC_status=needs review
| DIC_status = ready to implement
|DIC_app=CCMDB.accdb
| DIC_implementation_date =  
|DIC_backlogged=No
}}
}}
We have had some CCI count entries that are so high that they are likely errors.


{{Discuss | who = Tina | question = needs to be implemented but not strictly needed for go-live }}
=== CCI codes considered ===
{{#ask: [[Has CCI Picklist Code::2.ZZ.13.RA||2.ZZ.13.RE||3.GY.10.VA||3.ID.10.V^||3.IP.10.V^||3.IP.30||3.IP.20||3.IP.40||3.IP.70||3.JM.10.V^||3.JY.20||3.KV.10.VX||3.KX.10.VC||3.IM.10.V^||3.OT.10.VA]]
|?Has CCI Picklist Code=Code
|?Has CCI Collection Mode=Collection mode
|sort=Has CCI Collection Mode,Has CCI Picklist Code
|order=asc,asc
}}


We have had some medical [[:Category:Labs Imaging]] count entries that are so high that they are likely errors.  
== Checks ==
This uses [[Function LOS()]] to calculate the [[LOS]].  


=== What are likely maximum entries? ===
=== [[Template:CCI collect count each|CCI collect count each]] and [[Template:CCI collect each|CCI collect each]] ===
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.  
These should be checked.  


*LOS based on calendar dates = Dispo Date - Arrival Date + 1
=== [[Template:CCI collect count days|CCI collect count days]] ===
** if patient is still in the unit,  Dispo Date is replaced by Today date
Implemented by [[query check_CCI_vs_LOS_count_days_component]] and [[query check_CCI_vs_LOS_count_days_picklist]].
*Chest X-ray (CXR) per patient day = Number of chest X-rays / LOS Based on calendar dates


{| class="wikitable sortable"
=== [[Template:CCI collect count units|CCI collect count units]] ===
! 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
Discussed with Julie that this one is likely uncheckable. [[User:Ttenbergen|Ttenbergen]] 15:47, 2021 September 2 (CDT)
|-
||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
|-
|}


{{CCMDB.mdb cross checks triggering for correct values}}
== Log ==
* 2024-04-24 -
** implemented LOS <7 and count >10 (i.e. double digits, because that's a likely fumble finger mistake)
** initially this was supposed to be for CXR, then general imaging, now all sorts of CCI entries
* 2022-02-10 - confirmed that this would not be affected by the change of including a time in the [[Px Date]]
* 2022-01-19 - Julie confirmed that we don't need to check this per [[Boarding Loc]] - per profile is enough (especially since it's a soft check)


== Related articles ==
== Related articles ==
Line 51: Line 43:
[[Category:Labs]]
[[Category:Labs]]
[[Category:Length of stay]]
[[Category:Length of stay]]
[[Category:CCI Px check]]
[[Category:Data Integrity Checks]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_each_count_vs_LOS"