Reconnect check orphans query

Data Integrity Checks
Summary:	* RecordStatus field is incomplete the record doesn't have the same SentDtTm field as the newest SentDtTm for that location.
Related:	RecordStatus field, SentDtTm field, Service/Location field
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	query PL_1orphans
Uses L Problem table:	not entered
Status:	implemented
Implementation Date:	not entered
Backlogged:	true

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

Related articles