CCMDB Wiki

Query check CCI each count vs LOS: Difference between revisions

← Older edit
No edit summary
 
(68 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]].  


({{discussion}} Julie, can you enter the way we derived the thresholds, and the values, here?)
=== [[Template:CCI collect count each|CCI collect count each]] and [[Template:CCI collect each|CCI collect each]] ===
These should be checked.


=== How the checks will work===
=== [[Template:CCI collect count days|CCI collect count days]] ===
Implemented by [[query check_CCI_vs_LOS_count_days_component]] and [[query check_CCI_vs_LOS_count_days_picklist]].


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


== 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)


[[category:Labs]]
== Related articles ==
{{Related Articles}}
 
[[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"