Query check ICD10 Comorbids Dx present: Difference between revisions

Latest revision as of 10:56, 30 July 2025

Data Integrity Checks
Summary:	All complete patients must have at least one ICD10 entry for Dx Type Comorbid Diagnosis, which might be No Comorbidities (ICD10 code).
Related:
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_ICD10_Comorbids_Dx_present
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2018-11-12
Backlogged:	true

This does not also check for presence of Admit Diagnosis because query check_dx_primary_not_exactly_one already takes care of it.

2020-07-23 - query was not triggering on missing comos because the two tables were an inner join, not an outer join; can't imaging when this would have changed, so might not ever have worked
2019-10-27 - changed to only check if recordstatus complete and incomplete

@@ Line 1: / Line 1: @@
-* must have an [[Admit Diagnosis]]
+{{Data Integrity Check
-* must have a [[Comorbid Diagnosis]], which might be [[No Comorbidities (ICD10 code)]]
+| DIC_summary = All complete patients must have at least one ICD10 entry for [[Dx Type]] [[Comorbid Diagnosis]], which might be [[No Comorbidities (ICD10 code)]].
+| DIC_firmness = hard check
+| DIC_timing = complete
+| DIC_app = CCMDB.accdb
+| DIC_coding = query ''check_ICD10_Comorbids_Dx_present''
+| DIC_status = implemented
+| DIC_implementation_date = 2018-11-12
+}}
+This does not also check for presence of [[Admit Diagnosis]] because [[query check_dx_primary_not_exactly_one]] already takes care of it.
+== Log ==
+* 2020-07-23 - query was not triggering on missing comos because the two tables were an inner join, not an outer join; can't imaging when this would have changed, so might not ever have worked
+* 2019-10-27 - changed to only check if recordstatus complete and incomplete
+== Related articles ==
+{{Related Articles}}
+[[Category:ICD10]]
+[[Category:ICD10 Dx check‎]]