Query check ICD10 duplicates: Difference between revisions

(31 intermediate revisions by 3 users not shown)

Line 1:

{{Data Integrity Check

| DIC_summary = [[ICD10 Diagnoses]] (except for [[:Category:Pathogens]] or [[:Category:Antibiotic resistance]]) 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=list|link=none|limit=2000|sep=;}}; {{#ask: [[Category:Antibiotic resistance]]|format=list|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.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.

~~{{DA | 1~~

== Log ==

* ~~we discussed this with Julie in your office~~. ~~My paper notes said we decided~~ to ~~not allow~~ duplicates, ~~but my notes on the wiki say~~ to ~~exclude from duplicate check. What did we actually decide?~~

* 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

* ~~How about~~ [[~~:Category:Mechanism~~]] ~~- does it need~~ to ~~be excluded from this duplicate check as well?~~

* 2022-03-09 - added [[Iatrogenic problem NOS, related to a surgery or procedure, NOS]]

*~~AG REPLY~~ -- ~~there ARE some things that CAN be legally duplicated.~~

* 2022-03-02 - added [[Past history, removal of organ NOS]], [[Nosocomial infection, NOS]] and [[Sexually transmitted (venereal) infections, NOS]] to allowed duplicates

**e.g. a st. aur pneumonia and a st. aur UTI --- the ~~st. aur bug CAN/SHOULD be listed separately~~ for each ~~of these 2 infections. Ditto for resistances~~.

* 2022-02-17 - added [[Past history, cancer (any type), believed cured]] to allowed duplicates

**also see [[~~Template~~:~~ICD10 Guideline Trauma w mechanism~~]]

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

[[Category: ICD10]]

[[Category:ICD10]]

[[Category: ICD10 Dx check‎]]

[[Category:ICD10 Dx check‎]]

@@ Line 1: / Line 1: @@
 {{Data Integrity Check
-| DIC_summary = [[ICD10 Diagnoses]] (except for [[:Category:Pathogens]] or [[:Category:Antibiotic resistance]]) 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=list|link=none|limit=2000|sep=;}}; {{#ask: [[Category:Antibiotic resistance]]|format=list|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.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.
-{{DA | 1
+== Log ==
-* we discussed this with Julie in your office. My paper notes said we decided to not allow duplicates, but my notes on the wiki say to exclude from duplicate check. What did we actually decide?
+* 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
-* How about [[:Category:Mechanism]] - does it need to be excluded from this duplicate check as well?
+* 2022-03-09 - added [[Iatrogenic problem NOS, related to a surgery or procedure, NOS]]
-*AG REPLY -- there ARE some things that CAN be legally duplicated.
+* 2022-03-02 - added [[Past history, removal of organ NOS]], [[Nosocomial infection, NOS]] and [[Sexually transmitted (venereal) infections, NOS]] to allowed duplicates
-**e.g. a st. aur pneumonia and a st. aur UTI --- the st. aur bug CAN/SHOULD be listed separately for each of these 2 infections.  Ditto for resistances.
+* 2022-02-17 - added [[Past history, cancer (any type), believed cured]] to allowed duplicates
-**also see [[Template:ICD10 Guideline Trauma w mechanism]]
+* 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}}
-[[Category: ICD10]]
+[[Category:ICD10]]
-[[Category: ICD10 Dx check‎]]
+[[Category:ICD10 Dx check‎]]