Link suspect mismatch from ours incomplete query: Difference between revisions

← Older edit Newer edit →

@@ Line 1: / Line 1: @@
-{{Data Integrity Check}}
+{{Data Integrity Check
+|DIC_summary=Used in [[Correcting suspect links]] to find records 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.
+|DIC_related_concepts=PHIN field; Previous Location field
+|DIC_firmness=hard check
+|DIC_coding=query ''Link suspect mismatch from 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 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.
+== Related articles ==
+{{Related Articles}}
-Follow steps in [[Processing errors in patient data]] to fix errors found.
 [[Category: Data Processing]]
 [[Category:Multiple Encounter linking]]
 [[Category:Multiple encounter longitudinal consistency check]]
+[[Category:Registry checks]]