Query check ICD10 duplicates: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(35 intermediate revisions by 4 users not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = [[ICD10 Diagnoses]] can't be entered in duplicate.
|DIC_summary=[[Admit Diagnosis|Admit]] and [[Comorbid Diagnosis|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.
| DIC_related_concepts = ICD10 Diagnosis
|DIC_related_concepts=Admit Diagnosis; Comorbid Diagnosis  
| DIC_firmness = hard check  
|DIC_firmness=hard check
| DIC_timing = complete
|DIC_timing=complete
| DIC_app = CCMDB.mdb
|DIC_coding=query ''check_ICD10_duplicates''
| DIC_coding = query ''check ICD10 duplicates''
|DIC_implementation_date=2022-02-10
| DIC_status = needs review
|DIC_status=declined
| DIC_implementation_date = 2018-10-01
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
}}
}}
Decided at Task meeting 2022-04-20 to no longer run this check since it has too many exceptions.


* [[Comorbid Diagnosis]], [[Admit Diagnosis]]: there can be no duplicates
== Log ==
* [[Acquired_Diagnosis_/_Complication#repeating_complications]]: no repeat with exceptions
* 2022-04-20 - declined and deleted check
 
* 2022-03-17 - added [[Neoplasm of uncertain behavior (i.e. not clear if benign or malignant), NOS]] to allowed duplicates
{{Discuss | who = Tina | question = 1
* 2022-03-09 - added [[Iatrogenic problem NOS, related to a surgery or procedure, NOS]]
* need to tweak this to allow for second infection with different bug as per [[Acquired_Diagnosis_/_Complication#repeating_complications]]; however, would that not be true for [[Admit Diagnosis]] as well, eg. a skin infection on one foot with one pathogen and on the other with a different pathogen}}
* 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]]


== Related articles ==
== Related articles ==
{{Related Articles}}
{{Related Articles}}


[[Category: ICD10]]
[[Category:ICD10]]
[[Category: ICD10 Dx check‎]]
[[Category:ICD10 Dx check‎]]

Latest revision as of 10:55, 30 July 2025

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: declined
Implementation Date: 2022-02-10
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:

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

Log

Related articles

Related articles: