Query check ICD10 Comorbids Dx present: Difference between revisions
Ttenbergen (talk | contribs) Created page with "* must have an Admit Diagnosis * must have a Comorbid Diagnosis, which might be No Comorbidities (ICD10 code)" |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (12 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check | |||
| DIC_summary = All complete patients must have at least one ICD10 entry for [[Dx Type]] [[Comorbid Diagnosis]], which might be [[No Comorbidities (ICD10 code)]]. | |||
| DIC_firmness = hard check | |||
| DIC_timing = complete | |||
| DIC_app = CCMDB.accdb | |||
| DIC_coding = query ''check_ICD10_Comorbids_Dx_present'' | |||
| DIC_status = implemented | |||
| DIC_implementation_date = 2018-11-12 | |||
}} | |||
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 Dx check]] | |||