Query check ICD10 duplicates: Difference between revisions

(34 intermediate revisions by 4 users not shown)

Line 1:

{{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.

~~{{DT | 1~~ not ~~strictly necessary for go-live~~, ~~but if at all this should happen soon. }}~~

== Log ==

* 2022-04-20 - declined and deleted check

~~{{DiscussTask | 1~~

* 2022-03-17 - added [[Neoplasm of uncertain behavior (i.e. not clear if benign or malignant), NOS]] to allowed duplicates

* ~~need~~ to ~~tweak this to allow for second infection with different bug (eg.~~ a ~~skin~~ infection ~~on one foot with one pathogen~~ and ~~on the other with a different pathogen~~) ~~or even simply the same pathogen for two~~ infections~~. Same would be true for mechanism of injury~~, ~~it needs~~ to ~~be applicable repeatedly. The only way we would be able to do this at all is to change instructions on how to combine these~~, ~~I think~~, ~~e.g. everything with same pathogen has~~ to ~~be combined and pathogen only coded once, but that might make it look like things that are not related are~~. ~~I actually think this is messy enough to take~~ to ~~task~~, ~~so putting on list.~~

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

== 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]] 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.
-{{DT | 1 not strictly necessary for go-live, but if at all this should happen soon. }}
+== Log ==
+* 2022-04-20 - declined and deleted check
-{{DiscussTask | 1
+* 2022-03-17 - added [[Neoplasm of uncertain behavior (i.e. not clear if benign or malignant), NOS]] to allowed duplicates
-* need to tweak this to allow for second infection with different bug (eg. a skin infection on one foot with one pathogen and on the other with a different pathogen) or even simply the same pathogen for two infections. Same would be true for mechanism of injury, it needs to be applicable repeatedly. The only way we would be able to do this at all is to change instructions on how to combine these, I think, e.g. everything with same pathogen has to be combined and pathogen only coded once, but that might make it look like things that are not related are. I actually think this is messy enough to take to task, so putting on list.
+* 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]]
 == Related articles ==
 {{Related Articles}}
-[[Category: ICD10]]
+[[Category:ICD10]]
-[[Category: ICD10 Dx check‎]]
+[[Category:ICD10 Dx check‎]]