Link suspect negative transit time query

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:	Yes
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.

log