Query check ICD10 Comorbids Dx present

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

• Cargo

• SMW

• Categories:  

• form:

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