Query check CCI each count vs LOS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
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)

Revision as of 15:13, 2024 April 24

Data Integrity Checks
Summary: Confirm that a Category:Labs Imaging count is not unreasonably high
Related: 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
Firmness: soft check
Timing: complete
App: CCMDB.accdb
Coding: query check_CCI_imaging_count_vs_LOS
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:

Imaging codes considered

Discussion

  • Just came across this... the started query includes additional dxs now, as per #CCI collect count each. Does the proposed accepted count make sense for all the dxs? Your validation table was for CXR. Ttenbergen 11:50, 2023 May 3 (CDT)
    • Did some checking on all 13 LAB Imaging from CCI picklist and found counts more than the LOS only in ECHO, AXR and CXR. Emailed Lisa and Pagasa March 14, 2024 to check if correct or not. Waiting for their feedbacks. In the email, I also propose another query (e.g. the counts per calendar day per patient must not be more than one) as alternative to the threshold limits LOS +- 3 STD shown below. --JMojica 10:55, 2024 March 18 (CDT)
      • That query is tighter and would therefore have more false positives. What does Lisa think about that? Ttenbergen 09:51, 2024 March 20 (CDT)
        • I made some limits per LOS group for CXR, AXR, ECHO and Blood gases and emailed the results to Tina and Lisa 3/25/2024 for discussion. ---JMojica 13:28, 2024 March 25 (CDT)
          • Further emails with Julie and Lisa about details. Discussed with Lisa who is reviewing some of the errors and will hold off until she is done. Ttenbergen 12:46, 2024 April 8 (CDT)
  • SMW


  • Cargo


  • Categories

{{DT |

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 = Function LOS() + 1
    • if patient is still in the unit, Dispo DtTm is replaced by today's date
      • check is marked as only running on complete records, if that is so then we don't need to replace with today's 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

CCMDB.accdb cross checks triggering for correct values

If the actual correct data leads to a cross-check error CCMDB.accdb will not allow you to send. In that case, enter a value that is acceptable and then email the Data Processor using the "generate email" button.

Checks

This uses Function LOS() to calculate the LOS.

 Has CCI Collection Mode
Blood gas, venousCCI collect count each
Blood gas, arterialCCI collect count each
CXR (plain film)CCI collect count each
AXR (abdominal plain X-ray)CCI collect count each
Angiogram, aortic (any part of aorta)CCI collect each
Angiogram, pulmonary artery (pulmonary arteriogram)CCI collect each
Angiogram, coronary (diagnostic cardiac catheterization)CCI collect each
Cardiac CT or Cardiac CT angiogram (with or without coronary arteries)CCI collect each
ECHO (echocardiogram of heart)CCI collect each
Cardiac MRICCI collect each
Cardiac nuclear scan (e.g. MUGA)CCI collect each
Angiogram, cerebral (including vertebral arteries)CCI collect each
CT of chest with PE protocol (CT angiogram of pulmonary vessels)CCI collect each
Angiogram, artery NOS (except specifically coded)CCI collect each
Angiogram, veinCCI collect each

CCI collect count each

CCI collect count days

"CCI collect count days" should not be higher than LOS. See query check_CCI_vs_LOS_count_days_component and query check_CCI_vs_LOS_count_days_picklist.

CCI collect count units

Discussed with Julie that this one is likely uncheckable. Ttenbergen 15:47, 2021 September 2 (CDT)

CCI collect each

Discussed with Julie and no specific checks required for this one.

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-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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_each_count_vs_LOS&oldid=161340"