Link suspect negative transit time query: Difference between revisions

Revision as of 02:22, 27 October 2018

Data Integrity Checks
Summary:	Used in Correcting suspect links to find records where an earlier record for a patient with that PHIN has a Dispo DtTm that is later than the next record's Arrive DtTm.
Related:	PHIN, Arrive DtTm field, Dispo DtTm field
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	query Link suspect negative transit time
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.

If after correcting the query and if still showing the negative query click the "populate linking_pairs" again and it will update the linking error.

@@ Line 1: / Line 1: @@
-{{Data Integrity Check}}
+{{Data Integrity Check
+|DIC_summary=Used in [[Correcting suspect links]] to find records where an earlier record for a patient with that [[PHIN]] has a [[Dispo DtTm]] that is later than the next record's [[Arrive DtTm]].
-One of the queries used in [[Correcting suspect links]].
+|DIC_related_concepts=PHIN; Arrive DtTm field; Dispo DtTm field
+|DIC_firmness=hard check
-This one lists patients where an earlier record for a patient with that PHIN has a [[Dispo DtTm]] that is later than the next record's [[Arrive DtTm]].
+|DIC_coding=query ''Link suspect negative transit time ''
+|DIC_status=implemented
+|DIC_app=Centralized data front end.accdb
+}}
+Follow steps in [[Processing errors in patient data]] to fix errors found.
-Follow steps in [[Processing errors in patient data]] to fix errors found.
+If after correcting the query and if still showing the negative query click the "populate linking_pairs" again and it will update the linking error.