Link suspect dead then alive query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(2 intermediate revisions by 2 users not shown)
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; Guideline for coding organ donation after death
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_coding=query ''Link suspect dead then alive''
|DIC_coding=query ''Link suspect dead then alive''
|DIC_status=implemented
|DIC_status=implemented
|DIC_LProblem=Yes
|DIC_LProblem=no
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
}}
}}
Follow steps in [[Processing errors in patient data]] to fix errors found.
Follow steps in [[Processing errors in patient data]] to fix errors found.



Latest revision as of 14:20, 2022 June 14

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: 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.

Related articles

Related articles: