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

• Cargo

• SMW

• Categories:  

• form:

See Orphans in Centralized data.mdb for more info and how to fix this problem.