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 Service/Location.
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-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