Reconnect check orphans query

From CCMDB Wiki
Jump to navigation Jump to search
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
  • Cargo


  • SMW


  • Categories: 
  • form:

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

Related articles

Related articles: