Link suspect negative transit time query
| 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: | not entered |
| Status: | implemented |
| Implementation Date: | not entered |
| Backlogged: | true |
Follow steps in Processing errors in patient data to fix errors found.
If after correcting the query and if still showing the negative query click the "populate linking_pairs" again and it will update the linking error.