Link suspect dead then alive query

From CCMDB Wiki
Revision as of 11:34, 30 July 2025 by Ttenbergen (talk | contribs) (Text replacement - "[[Category: " to "[[Category:")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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 was listed as dispo field deceased, but a later entry then shows up.
Related: PHIN field, Dispo field, Deceased patients, Guideline for coding organ donation after death
Firmness: hard check
Timing: always
App: Centralized data front end.accdb
Coding: query Link suspect dead then alive
Uses L Problem table: Yes
Status: implemented
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:

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

Related articles: