Query check ICD10 duplicates

Data Integrity Checks
Summary:	ICD10 Diagnoses can't be entered in duplicate.
Related:	ICD10 Diagnosis
Firmness:	hard check
Timing:	complete
App:	CCMDB.mdb
Coding:	query check ICD10 duplicates
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	2018-10-01
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 

• Categories:  

• form:

• Comorbid Diagnosis, Admit Diagnosis: there can be no duplicates
• Acquired_Diagnosis_/_Complication#repeating_complications: no repeat with exceptions

1 need to tweak this to allow for second infection with different bug as per Acquired_Diagnosis_/_Complication#repeating_complications; however, would that not be true for Admit Diagnosis as well, eg. a skin infection on one foot with one pathogen and on the other with a different pathogen

• SMW

• Cargo

• Categories