Query check ICD10 duplicates: Difference between revisions

Revision as of 10:04, 9 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-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 17: / Line 17: @@
 * 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]]
-{{Discuss|
-*Encountered a scenario in comorb dx list whereby [[Past history, removal of organ NOS]] combined with 1) [[Disorder of spleen, NOS]] then a separate entry combined with 2) [[Postpartum hemorrhage]] for the removal of two different organs triggered the duplicate ICD error. Should this code be added to the exclusion list or coded differently? Thanks!
-*Encountered a scenario whereby a direct admit patient from another facility with both [[Nosocomial infection, NOS]] uti AND [[Nosocomial infection, NOS]] pneumonia triggered the ICD 10 duplicate dx error.
-* Feb. 25, 2022-continue to encounter a dx duplication error for [[Past history, cancer (any type), believed cured]]
-** All dxs in this discussion have been added to the exception list. If three are still problems after ver 2022-03-02, please let me know, otherwise this discussion can be deleted. [[User:Ttenbergen|Ttenbergen]] 09:31, 2022 March 2 (CST)
-}}
 == Related articles ==