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

• Cargo

• SMW

• Categories:  

• form:

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

Organ donor inconsistencies

We have Guideline for coding organ donation after death which might lead to some cross checks flagging an error for patient transfers. This situation is somewhat complex, so instead of changing queries to exclude these cases, just add them to L Problem table as usual after confirming that transfer info was indeed as entered.

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; also changed query to only compare up to 2018