Link suspect negative transit time query

From CCMDB Wiki
Jump to navigationJump to search
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 relevant for this app
Status: implemented
Implementation Date: not entered
Backlogged: true

  • Cargo

  • SMW

  • Categories: 

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

Still shows records after errors are fixed

If after correcting the errors in this query it still shows entries, re-do Populate linking pairs and it will update the linking error.


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

Related articles

Related articles: