Query check ICD10 duplicates: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(21 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = [[ICD10 Diagnoses]] (except for [[:Category:Pathogens]] or [[:Category:Antibiotic resistance]] and [[:Category:Mechanism]]) 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 = {{#ask: [[Category:Pathogens]]|format=plainlist|link=none|limit=2000|sep=;}}; {{#ask: [[Category:Antibiotic resistance]]|format=plainlist|link=none|limit=2000|sep=;}}; Combined ICD10 codes; Infections in ICD10
|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 = ready to implement
|DIC_status=declined
| DIC_implementation_date = 2018-10-01
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
}}
}}
{{TT | _Dev_CCMDB
Decided at Task meeting 2022-04-20 to no longer run this check since it has too many exceptions.  
* the count is wrong, there wasn't a quick fix, so disabling the query for now. Ttenbergen 15:56, 2019 March 27 (CDT)}}


Putting here so it lists in query listings, there really is nothing do discuss, I just need to fix this. [[User:Ttenbergen|Ttenbergen]] 17:29, 2021 October 7 (CDT)
{{Discuss |
* the count is wrong, there wasn't a quick fix, so disabling the query for now. Ttenbergen 15:56, 2019 March 27 (CDT)
}}
== 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-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]]
* 2019-03-25 - excluded dxs in [[:Category:Pathogens]], [[:Category:Antibiotic resistance]] and [[:Category:Mechanism]]



Latest revision as of 21:04, 2022 April 20

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: