Link suspect negative transit time query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
No edit summary |
||
| Line 10: | Line 10: | ||
Follow steps in [[Processing errors in patient data]] to fix errors found. | Follow steps in [[Processing errors in patient data]] to fix errors found. | ||
If after correcting the query | == Still shows records after errors are fixed == | ||
If after correcting the errors in this query it still shows entries, re-do [[Populate linking pairs]] and it will update the linking error. | |||
== log == | == log == | ||
Revision as of 11:34, 7 February 2019
| Data Integrity Checks | |
| Summary: | Used in Correcting suspect links to find records where an earlier record for a patient with that PHIN has a Dispo DtTm that is later than the next record's Arrive DtTm. |
| Related: | PHIN, Arrive DtTm field, Dispo DtTm field |
| Firmness: | hard check |
| Timing: | always |
| App: | Centralized data front end.accdb |
| Coding: | query link_suspect_negative_transit_time |
| Uses L Problem table: | Yes |
| Status: | implemented |
| Implementation Date: | not entered |
| Backlogged: | true |
Follow steps in Processing errors in patient data to fix errors found.
Still shows records after errors are fixed
If after correcting the errors in this query it still shows entries, re-do Populate linking pairs and it will update the linking error.
log
- 08:58, 2019 January 30 (CST): fixed problem with field name in query