Query check ICD10 duplicates: Difference between revisions

Revision as of 10:55, 13 April 2022

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)

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

@@ Line 8: / Line 8: @@
 | DIC_status = implemented
 | DIC_implementation_date = 2022-02-10
+}}
+{{DiscussTask |
+* We keep having to add exceptions to this. Is there a better way to do this check? [[User:Ttenbergen|Ttenbergen]] 11:55, 2022 April 13 (CDT)
 }}