Reconnect check orphans query
| Data Integrity Checks | |
| Summary: | Record meets following conditions
|
| Related: | RecordStatus field, SentDtTm field, Service/Location field |
| Firmness: | hard check |
| Timing: | always |
| App: | Centralized data front end.accdb |
| Coding: | Reconnect_check_orphans query |
| 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.
Log
- 2023-08-29 - After starting to implement Change to having each collector collect both programs on the same laptop the query is giving a false positive for the earlier of any two batches sent from the combined H6 laptop. We are not implementing that change further until after SF is implemented, which will make this check obsolete. For now Pagasa will need to eyeball this check.
- 2023-08-15 - reformatted to remove * data and only show D_ID and send_dttm and filter fields to make this easier to read. This was as part of validating the query when it started to show false positives after Change to having each collector collect both programs on the same laptop. The query will need further review as we move this to other laptops - for now Pagasa can eyeball that the only ones on there are same-sentDtTm for H6