Link suspect mismatch from ours incomplete query: Difference between revisions

Revision as of 01:27, 2018 October 27

Data Integrity Checks
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.
Related:	PHIN field, Previous Location field
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	query Link suspect mismatch from ours incomplete
Uses L Problem table:	not entered
Status:	implemented
Implementation Date:	not entered
Backlogged:	true

Follow steps in Processing errors in patient data to fix errors found.

@@ 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]]