Link suspect mismatch from ours incomplete query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(m)
 
m (link fix)
Line 1: Line 1:
One of the queries used in [[Correcting suspect links]].  
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.  
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


[[Category: Data Processing]]
[[Category: Data Processing]]

Revision as of 11:29, 2016 October 13

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