Query check ICD10 duplicates: Difference between revisions

Revision as of 17:14, 10 February 2022

Data Integrity Checks
Summary:	ICD10 Diagnoses (except for Category:Pathogens or Category:Antibiotic resistance and Category:Mechanism) can't be entered in duplicate.
Related:
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

This would include almost all ICD10 diagnoses in related concepts, which would not be helpful to list, so excluded them.

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:
Admit Diagnosis (← links) Comorbid Diagnosis (← links) CCMDB.mdb Change Log 2018 (← links) Data Integrity Checks (← links) CCMDB.accdb Change Log 2019 (← links) CCMDB.accdb Change Log 2022 (← links) Task Team Meeting - Rolling Agenda and Minutes 2022 (← links)

@@ Line 1: / Line 1: @@
 {{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_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 =
 | DIC_firmness = hard check
 | DIC_timing = complete
 | DIC_app = CCMDB.accdb
 | DIC_coding = query ''check_ICD10_duplicates''
-| DIC_status = ready to implement
+| DIC_status = implemented
-| DIC_implementation_date =
+| DIC_implementation_date = 2022-02-10
 }}
-{{TT | _Dev_CCMDB
-* 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. REmoved original implementation date since query has been disabled for over a year. [[User:Ttenbergen|Ttenbergen]] 17:29, 2021 October 7 (CDT)
+This would include almost all ICD10 diagnoses in related concepts, which would not be helpful to list, so excluded them.
-{{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 ==