Link suspect mismatch from ours incomplete query

Data Integrity Checks
Summary:	Used in Correcting suspect links to find records where a later record with that PHIN has a Previous Location entry corresponding to one of our sites as per the s_dispo table.real_collection table, but an earlier corresponding entry doesn't exist for that location.
Related:	PHIN field, Previous Location field
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	Link_suspect_mismatch_from_ours__incomplete query
Uses L Problem table:	no
Status:	implemented
Implementation Date:	not entered
Backlogged:	No

Follow steps in Processing errors in patient data to fix errors found.

Log

2022-05-26 - changed the linking from previous to next to use <>s_dispoIDs and [s_dispo_early_location].[real_collection]<>[s_dispo_late_previous].[location_name]; without these, the a change we had made that turned “STB_SICU” into “STB_SICU (Legacy)” would result in false positives