Link suspect mismatch from ours incomplete query

From CCMDB Wiki
Revision as of 10:24, 2016 October 13 by Ttenbergen (talk | contribs) (m)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.