Link suspect mismatch to ours incomplete query: Difference between revisions

mNo edit summary
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check}}
{{Data Integrity Check
|DIC_summary=Used in [[Correcting suspect links]] to find records where an earlier record with that [[PHIN]] has a [[dispo]] entry corresponding to one of our sites as per the [[s_dispo table]].real_collection, but a later corresponding entry doesn't exist for that location.
|DIC_related_concepts=PHIN field; Dispo field
|DIC_firmness=hard check
|DIC_coding=query ''Link suspect mismatch to ours incomplete ''
|DIC_status=implemented
|DIC_app=Centralized data front end.accdb
}}


One of the queries used in [[Correcting suspect links]].  
Follow steps in [[Processing errors in patient data]] to fix errors found.


This one lists patients where an earlier record with that PHIN has a [[dispo]] entry corresponding to one of our sites as per the [[s_dispo table]].real_collection, but a later corresponding entry doesn't exist for that location.
== Related articles ==
 
{{Related Articles}}
Follow steps in [[Processing errors in patient data]] to fix errors found.


[[Category: Data Processing]]
[[Category: Data Processing]]
[[Category:Multiple Encounter linking]]
[[Category:Multiple Encounter linking]]
[[Category:Multiple encounter longitudinal consistency check]]
[[Category:Multiple encounter longitudinal consistency check]]
[[Category:Registry checks]]