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

 Property "DICRelatedConcepts" (as page type) with input value "Admit Diagnosis]], [[Comorbid Diagnosis" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

Log

• 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