Link suspect dead then alive query: Difference between revisions

Revision as of 01:25, 27 October 2018

Data Integrity Checks
Summary:	Used in Correcting suspect links to find records where an earlier record with that PHIN was listed as dispo field deceased, but a later entry then shows up.
Related:	PHIN field, Dispo DtTm field
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	query Link suspect dead then alive
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 an earlier record with that [[PHIN]] was listed as [[dispo field]] deceased, but a later entry then shows up.
-One of the queries used in [[Correcting suspect links]].
+|DIC_related_concepts=PHIN field; Dispo DtTm field
+|DIC_firmness=hard check
-This one lists patients where an earlier record with that PHIN was listed as [[dispo field]] deceased, but a later entry then shows up.
+|DIC_coding=query ''Link suspect dead then alive''
+|DIC_status=implemented
+|DIC_app=Centralized data front end.accdb
+}}
 Follow steps in [[Processing errors in patient data]] to fix errors found.
@@ Line 10: / Line 13: @@
 [[Category:Multiple Encounter linking]]
 [[Category:Multiple encounter longitudinal consistency check]]
+[[Category:Registry checks]]