Link suspect mismatch to ours incomplete query

From CCMDB Wiki
Jump to navigation Jump to search
Data Integrity Checks
Summary: Used in Correcting suspect links to find records where an earlier record with that PHIN has a dispo entry corresponding to one of our sites as per the s_dispo table.real_collection, but a later corresponding entry doesn't exist for that location.
Related: PHIN field, Dispo field, Guideline for coding organ donation after death
Firmness: hard check
Timing: always
App: Centralized data front end.accdb
Coding: query Link suspect mismatch to ours incomplete
Uses L Problem table: no
Status: implemented
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

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

Organ donor inconsistencies

We have Guideline for coding organ donation after death which might lead to some cross checks flagging an error for patient transfers. This situation is somewhat complex, so instead of changing queries to exclude these cases, just add them to L Problem table as usual after confirming that transfer info was indeed as entered.

Related articles

Related articles: