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 &lt, !--This would include almost all ICD10 diagnoses in related concepts, which would not be helpful to list, so excluded them. --&gt
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_ICD10_duplicates
Uses L Problem table:	not relevant for this app
Status:	declined
Implementation Date:	2022-02-10
Backlogged:	No

Decided at Task meeting 2022-04-20 to no longer run this check since it has too many exceptions.

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.

- yes, this was discussed at TASK to allow for multiple previous cancers, so I would think it would follow to allow for duplicate entries of past history of radiation and chemo Lisa Kaita 12:06, 2022 April 13 (CDT)

Query check ICD10 duplicates

Log

Related articles