Query check ICD10 Comorbids Dx present: Difference between revisions

(10 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 an [[~~Admit Diagnosis~~]]

* 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_unfilled~~''

| DIC_coding = query ''check_ICD10_Comorbids_Dx_present''

| DIC_status = ~~ready to implement~~

| DIC_status = implemented

| DIC_implementation_date =

| DIC_implementation_date = 2018-11-12

}}

This can't ~~be implemented until collection becomes mandatory~~

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

== 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 an [[Admit Diagnosis]]
-* 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_unfilled''
+| DIC_coding = query ''check_ICD10_Comorbids_Dx_present''
-| DIC_status = ready to implement
+| DIC_status = implemented
-| DIC_implementation_date =
+| DIC_implementation_date = 2018-11-12
 }}
-This can't be implemented until collection becomes mandatory
+This does not also check for presence of [[Admit Diagnosis]] because [[query check_dx_primary_not_exactly_one]] already takes care of it.
+== 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‎]]