Link suspect mismatch from ours incomplete query

From CCMDB Wiki
Revision as of 19:12, 24 November 2016 by Ttenbergen (talk | contribs) (m)
Jump to navigation Jump to search

One of the queries used in Correcting suspect links.

This one lists patients 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.

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