Link suspect dead then alive query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_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.
|DIC_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.
|DIC_related_concepts=PHIN field; Dispo DtTm field
|DIC_related_concepts=PHIN field; Dispo field; Deceased patients
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_coding=query ''Link suspect dead then alive''
|DIC_coding=query ''Link suspect dead then alive''

Revision as of 18:38, 2019 May 21

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
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: true
  • Cargo


  • SMW


  • Categories:  
  • form:

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

Related articles

Related articles: