Link suspect not same visitAdmitDtTm query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
| Line 11: | Line 11: | ||
As of 2022-02-16 the query looks for records that: | As of 2022-02-16 the query looks for records that: | ||
* have different [[Visit Admit DtTm]] | * have different [[Visit Admit DtTm]] | ||
* the both [[Visit Admit DtTm]]s are less than 2 years ago (to reduce query size) | |||
* the earlier is not [[Dispo]] to "Home" or "AMA (left against medical advice)" | * the earlier is not [[Dispo]] to "Home" or "AMA (left against medical advice)" | ||
* the | * both profiles are at the same site | ||
* 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 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 | * 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 | ||
Revision as of 16:32, 16 February 2022
| 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, Dispo, Service/Location, Previous Location, Pre-admit Inpatient Institution |
| 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 both Visit Admit DtTms are less than 2 years ago (to reduce query size)
- the earlier is not Dispo to "Home" or "AMA (left against medical advice)"
- both profiles are at the same site
- 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: |