CCMDB Wiki

Query check CCI each count vs LOS: Difference between revisions

← Older edit
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,815 edits
No edit summary
 
(64 intermediate revisions by 2 users not shown)
Line 1: Line 1:
‎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.
{{Data Integrity Check
|DIC_summary=Confirm that a [[:Category:Labs Imaging]] count is not unreasonably high
|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=soft check
|DIC_timing=complete
|DIC_coding=query ''check_CCI_each_count_vs_LOS''
|DIC_status=needs review
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
}}
We have had some CCI count entries that are so high that they are likely errors.


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


The count per patient stay is related to the [[LOS]].  
== Checks ==
This uses [[Function LOS()]] to calculate 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)
=== [[Template:CCI collect count each|CCI collect count each]] and [[Template:CCI collect each|CCI collect each]] ===
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, replace Dispo Date 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
|-
|}


=== How the checks will work===
== 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)


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.
== Related articles ==
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.
{{Related Articles}}


 
[[Category:Labs]]
[[category:Labs]]
[[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"