Link suspect not same visitAdmitDtTm query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 8: | Line 8: | ||
|DIC_app=Centralized data front end.accdb | |DIC_app=Centralized data front end.accdb | ||
}} | }} | ||
== What does this actually check? == | |||
As of 2022-02-16 the query looks for records that: | |||
* have different [[Visit Admit DtTm]] | |||
* the earlier is not [[Dispo]] to "Home" or "AMA (left against medical advice)" | |||
* the earlier [[Dispo_DtTm]] is less than 2 years ago (to reduce query size) | |||
* have a difference of less than 1 day between the dispo at the first location and the Arrive at the second. | |||
* have a difference of less than 7 days between the dispo at the first location and the Arrive at the second '''and''' (first [[dispo]] and second [[service/location]] match '''OR''' first [[service/location]] and second [[Pre-admit Inpatient Institution]] match '''OR''' first [[service/location]] and second [[Previous Location]] match | |||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category:Registry checks]] | [[Category:Registry checks]] | ||
Revision as of 14:33, 2022 February 16
| Data Integrity Checks | |
| Summary: | Checks for records that are likely part of the same admission but have different Visit Admit DtTm field. |
| Related: | Visit Admit DtTm field |
| Firmness: | soft check |
| Timing: | always |
| App: | Centralized data front end.accdb |
| Coding: | query Link_suspect_not_same_visitAdmitDtTm |
| Uses L Problem table: | No |
| Status: | implemented |
| Implementation Date: | not entered |
| Backlogged: | true |
What does this actually check?
As of 2022-02-16 the query looks for records that:
- have different Visit Admit DtTm
- the earlier is not Dispo to "Home" or "AMA (left against medical advice)"
- the earlier Dispo_DtTm is less than 2 years ago (to reduce query size)
- have a difference of less than 1 day between the dispo at the first location and the Arrive at the second.
* have a difference of less than 7 days between the dispo at the first location and the Arrive at the second and (first dispo and second service/location match OR first service/location and second Pre-admit Inpatient Institution match OR first service/location and second Previous Location match