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 5: Line 5:
|DIC_coding=query ''Link suspect dead then alive''
|DIC_coding=query ''Link suspect dead then alive''
|DIC_status=implemented
|DIC_status=implemented
|DIC_LProblem=false
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
}}
}}

Revision as of 19:13, 2018 October 29

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 DtTm field
Firmness: hard check
Timing: always
App: Centralized data front end.accdb
Coding: query Link suspect dead then alive
Uses L Problem table: false
Status: implemented
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

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