Query check ICD10 duplicates: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Ppiche (talk | contribs)
m Text replacement - "[[Category: " to "[[Category:"
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| 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_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 = Admit Diagnosis; Comorbid Diagnosis <!--This would include almost all ICD10 diagnoses in related concepts, which would not be helpful to list, so excluded them. -->
|DIC_related_concepts=Admit Diagnosis; Comorbid Diagnosis  
| DIC_firmness = hard check  
|DIC_firmness=hard check
| DIC_timing = complete
|DIC_timing=complete
| DIC_app = CCMDB.accdb
|DIC_coding=query ''check_ICD10_duplicates''
| DIC_coding = query ''check_ICD10_duplicates''
|DIC_implementation_date=2022-02-10
| DIC_status = implemented
|DIC_status=declined
| DIC_implementation_date = 2022-02-10
|DIC_app=CCMDB.accdb
}}
|DIC_backlogged=No
 
{{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)
}}
}}
Decided at Task meeting 2022-04-20 to no longer run this check since it has too many exceptions.


== Log ==
== Log ==
* 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
* 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-09 - added [[Iatrogenic problem NOS, related to a surgery or procedure, NOS]]
Line 22: Line 21:
* 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
* 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]]
* 2019-03-25 - excluded dxs in [[:Category:Pathogens]], [[:Category:Antibiotic resistance]] and [[:Category:Mechanism]]
{{Discuss| 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. }}


== 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: