Query check CCI each count vs LOS: Difference between revisions

m Ttenbergen moved page Query check CCI CXR vs LOS to Query check CCI imaging count vs LOS without leaving a redirect: Text replacement - "Query check CCI CXR vs LOS" to "Query check_CCI_imaging_count_vs_LOS"
mNo edit summary
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; Service tmp entry; 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=soft check
|DIC_firmness=soft check
|DIC_timing=complete
|DIC_timing=complete
Line 9: Line 24:
|DIC_backlogged=No
|DIC_backlogged=No
}}
}}
* Not currently implemented; starting point for the query exists but doesn't yet include Julie's values. Also, isn't being called from anywhere.  
 
=== Imaging codes considered ===
* {{CCIPick ByCode|2.ZZ.13.RA}}
* {{CCIPick ByCode|2.ZZ.13.RE}}
* {{CCIPick ByCode|3.GY.10.VA}}
* {{CCIPick ByCode|3.ID.10.V^}}
* {{CCIPick ByCode|3.IP.10.V^}}
* {{CCIPick ByCode|3.IP.30}}
* {{CCIPick ByCode|3.IP.20}}
* {{CCIPick ByCode|3.IP.40}}
* {{CCIPick ByCode|3.IP.70}}
* {{CCIPick ByCode|3.JM.10.V^}}
* {{CCIPick ByCode|3.JY.20}}
* {{CCIPick ByCode|3.KV.10.VX}}
* {{CCIPick ByCode|3.KX.10.VC}}
* {{CCIPick ByCode|3.IM.10.V^}}
* {{CCIPick ByCode|3.OT.10.VA}}


=== Discussion ===
=== Discussion ===
Line 21: Line 52:


{{DT |
{{DT |
* We will set up a query that checks LOS <7 and count >10 (i.e. double digits)
*  
* Julie will provide the list of checks for which this should trigger by email to Lisa and Tina
* this check will change names because it's for more than one test 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.
Line 63: Line 91:
== Checks ==
== Checks ==
This uses [[Function LOS()]] to calculate the [[LOS]].  
This uses [[Function LOS()]] to calculate the [[LOS]].  
{{#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 Collection Mode
|sort=Has CCI Collection Mode,Has CCI Picklist Code
|order=asc,asc
}}


=== CCI collect count each ===
=== CCI collect count each ===
* [[AXR (abdominal plain X-ray)]] 3.OT.10.VA
* [[Blood gas, arterial]] 2.ZZ.13.RE
* [[Blood gas, venous]] 2.ZZ.13.RA
* [[CXR (plain film)]] 3.GY.10.VA
"CCI collect count each" count should not be higher than:
* if LOS < 1, 5
* if LOS 1-50, LOS * 2
* if LOS > 50, LOS


=== CCI collect count days ===
=== CCI collect count days ===
Line 85: Line 110:


== Log ==
== Log ==
* 2024-04-24 - implemented LOS <7 and count >10 (i.e. double digits, because that's a likely fumble finger mistake)
* 2022-02-10 - confirmed that this would not be affected by the change of including a time in the [[Px Date]]
* 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)
* 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)