Reconnect check orphans query
| Data Integrity Checks | |
| Summary: | Record meets following conditions* RecordStatus field is incomplete* the record doesn't have the same SentDtTm field as the newest SentDtTm for that location. |
| Related: | RecordStatus field, SentDtTm field, Service/Location field |
| Firmness: | hard check |
| Timing: | always |
| App: | Centralized data front end.accdb |
| Coding: | query PL_1orphans |
| Uses L Problem table: | no |
| Status: | implemented |
| Implementation Date: | not entered |
| Backlogged: | No |
See Orphans in Centralized data.mdb for more info and how to fix this problem.