Query check CCI each count vs LOS

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:

We have had some CCI count entries that are so high that they are likely errors.

Imaging codes considered

• Blood gas, venous (2.ZZ.13.RA)
• Blood gas, arterial (2.ZZ.13.RE)
• CXR (plain film) (3.GY.10.VA)
• Angiogram, aortic (any part of aorta) (3.ID.10.V^)
• Angiogram, coronary (diagnostic cardiac catheterization) (3.IP.10.V^)
• ECHO (echocardiogram of heart) (3.IP.30)
• Cardiac CT or Cardiac CT angiogram (with or without coronary arteries) (3.IP.20)
• Cardiac MRI (3.IP.40)
• Cardiac nuclear scan (e.g. MUGA) (3.IP.70)
• Angiogram, cerebral (including vertebral arteries) (3.JM.10.V^)
• CT of chest with PE protocol (CT angiogram of pulmonary vessels) (3.JY.20)
• Angiogram, artery NOS (except specifically coded) (3.KV.10.VX)
• Angiogram, vein (3.KX.10.VC)
• Angiogram, pulmonary artery (pulmonary arteriogram) (3.IM.10.V^)
• AXR (abdominal plain X-ray) (3.OT.10.VA)

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.

List of codes, pages and collection modes

	Code	Collection mode
Blood gas, venous	2.ZZ.13.RA	CCI collect count each
Blood gas, arterial	2.ZZ.13.RE	CCI collect count each
CXR (plain film)	3.GY.10.VA	CCI collect count each
AXR (abdominal plain X-ray)	3.OT.10.VA	CCI collect count each
Angiogram, aortic (any part of aorta)	3.ID.10.V^	CCI collect each
Angiogram, pulmonary artery (pulmonary arteriogram)	3.IM.10.V^	CCI collect each
Angiogram, coronary (diagnostic cardiac catheterization)	3.IP.10.V^	CCI collect each
Cardiac CT or Cardiac CT angiogram (with or without coronary arteries)	3.IP.20	CCI collect each
ECHO (echocardiogram of heart)	3.IP.30	CCI collect each
Cardiac MRI	3.IP.40	CCI collect each
Cardiac nuclear scan (e.g. MUGA)	3.IP.70	CCI collect each
Angiogram, cerebral (including vertebral arteries)	3.JM.10.V^	CCI collect each
CT of chest with PE protocol (CT angiogram of pulmonary vessels)	3.JY.20	CCI collect each
Angiogram, artery NOS (except specifically coded)	3.KV.10.VX	CCI collect each
Angiogram, vein	3.KX.10.VC	CCI collect each

CCI collect count each

These should be checked.

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.

except now a bunch of these are collect each ones...

• SMW

• Cargo

• Categories

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)