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

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

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