Link suspect negative transit time query

Revision as of 08:58, 30 January 2019 by Ttenbergen (talk | contribs)
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
  • Cargo


  • SMW


  • Categories:  
  • form:

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

  • 08:58, 2019 January 30 (CST): fixed problem with field name in query

Related articles

Related articles: