Link suspect mismatch from ours incomplete query

From CCMDB Wiki
Revision as of 02:19, 27 October 2018 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
Data Integrity Checks
Summary: not entered
Related:
Firmness: not entered
Timing: always
App: not entered
Coding: not entered
Uses L Problem table: not relevant for this app
Status: not entered
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW


  • Categories:

[[Category:{{{DIC_app}}}]] 

  • form:

One of the queries used in Correcting suspect links.

This one lists patients where a later record with that PHIN has a Previous Location entry corresponding to one of our sites as per the s_dispo table.real_collection table, but an earlier corresponding entry doesn't exist for that location.

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