Link suspect mismatch from ours incomplete query

From CCMDB Wiki
Revision as of 10:29, 2016 October 13 by Ttenbergen (talk | contribs) (link fix)
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 ad