Link suspect not same visitAdmitDtTm query: Difference between revisions
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 | ||