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.
Instructions
The temporary solution is to still vet all patients, but not with the "Vet all sent" button. If Pagasa gets the orphans error at this point that would be expected. Instead of clearing the records in the error the records would need to be reviewed. As long as all are from H6, and only one other send dttm is in there, they aren't really orphans, they are as expected with two sends from same laptop. If that is the case and no other errors are thrown by the "Vet all sent" button, then just run the query "vet_all_sent" directly and manually, and Julie would get the data she expects.
| background |
|
Change to having each collector collect both programs on the same laptop will always put patients who meet the criteria of "orphans" for H6. So we stopped implementing it further, but H6 will continue to cause 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