Query check ICD10 duplicates

Data Integrity Checks
Summary:	Admit and Comorbid ICD10 Diagnoses (except for Category:Pathogens or Category:Antibiotic resistance and Category:Mechanism and Colonized with organism (not infected)) can't be entered in duplicate.
Related:	Admit Diagnosis, Comorbid Diagnosis
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_ICD10_duplicates
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2022-02-10
Backlogged:	true

• Cargo

• SMW

• Categories:  

• form:

We keep having to add exceptions to this. Is there a better way to do this check? Ttenbergen 11:55, 2022 April 13 (CDT)

• SMW

• Cargo

• Categories

Log

• 2022-03-17 - added Neoplasm of uncertain behavior (i.e. not clear if benign or malignant), NOS to allowed duplicates
• 2022-03-09 - added Iatrogenic problem NOS, related to a surgery or procedure, NOS
• 2022-03-02 - added Past history, removal of organ NOS, Nosocomial infection, NOS and Sexually transmitted (venereal) infections, NOS to allowed duplicates
• 2022-02-17 - added Past history, cancer (any type), believed cured to allowed duplicates
• 2022-02-16 - excluded additional allowed duplication scenarios
• 2022-02-10 - the list to count had included lines for each category so there was much duplication. Broke out query to generate unique values first, now count works
• 2019-03-25 - excluded dxs in Category:Pathogens, Category:Antibiotic resistance and Category:Mechanism

Should Past history of radiation therapy be included in exclusion list for patients with extensive past histories of differing primary cancers and who received radiation treatment at different times for the various different primary cancers.

• SMW

• Cargo

• Categories