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:	query Link_suspect_mismatch_from_ours__incomplete
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.

Related articles