Query check ICD10 duplicates: Difference between revisions

Revision as of 09:54, 17 March 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

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 11: / Line 11: @@
 == 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