Query check ICD10 Comorbids Dx present: Difference between revisions

(5 intermediate revisions by the same user not shown)

Line 1:

{{Data Integrity Check

| DIC_summary = ~~check that required ICD10 dxs are preesnt:~~

| DIC_summary = All complete patients must have at least one ICD10 entry for [[Dx Type]] [[Comorbid Diagnosis]], which might be [[No Comorbidities (ICD10 code)]].

* must have a Comorbid Diagnosis; which might be [[No Comorbidities (ICD10 code)]]

~~| DIC_related_concepts = Admit Diagnosis; Comorbid Diagnosis; No Comorbidities (ICD10 code)~~

| DIC_firmness = hard check

| DIC_timing = complete

| DIC_app = CCMDB.~~mdb~~

| DIC_app = CCMDB.accdb

| DIC_coding = query ''check_ICD10_Comorbids_Dx_present''

| DIC_status = implemented

Line 11:

Line 9:

}}

~~== why~~ does ~~this~~ not also check for presence of [[Admit Diagnosis]] ==

This does not also check for presence of [[Admit Diagnosis]] because [[query check_dx_primary_not_exactly_one]] already takes care of it.

[[query check_dx_primary_not_exactly_one]] already takes care of this.

== Log ==

* 2020-07-23 - query was not triggering on missing comos because the two tables were an inner join, not an outer join; can't imaging when this would have changed, so might not ever have worked

* 2019-10-27 - changed to only check if recordstatus complete and incomplete

== Related articles ==

[[Category: ICD10]]

[[Category:ICD10]]

[[Category: ICD10 Dx check‎]]

[[Category:ICD10 Dx check‎]]

@@ Line 1: / Line 1: @@
 {{Data Integrity Check
-| DIC_summary = check that required ICD10 dxs are preesnt:
+| DIC_summary = All complete patients must have at least one ICD10 entry for [[Dx Type]] [[Comorbid Diagnosis]], which might be [[No Comorbidities (ICD10 code)]].
-* must have a Comorbid Diagnosis;  which might be [[No Comorbidities (ICD10 code)]]
-| DIC_related_concepts = Admit Diagnosis;  Comorbid Diagnosis;  No Comorbidities (ICD10 code)
 | DIC_firmness = hard check
 | DIC_timing = complete
-| DIC_app = CCMDB.mdb
+| DIC_app = CCMDB.accdb
 | DIC_coding = query ''check_ICD10_Comorbids_Dx_present''
 | DIC_status = implemented
@@ Line 11: / Line 9: @@
 }}
-== why does this not also check for presence of [[Admit Diagnosis]] ==
+This does not also check for presence of [[Admit Diagnosis]] because [[query check_dx_primary_not_exactly_one]] already takes care of it.
-[[query check_dx_primary_not_exactly_one]] already takes care of this.
+== Log ==
+* 2020-07-23 - query was not triggering on missing comos because the two tables were an inner join, not an outer join; can't imaging when this would have changed, so might not ever have worked
+* 2019-10-27 - changed to only check if recordstatus complete and incomplete
 == Related articles ==
 {{Related Articles}}
-[[Category: ICD10]]
+[[Category:ICD10]]
-[[Category: ICD10 Dx check‎]]
+[[Category:ICD10 Dx check‎]]