Link suspect dead then alive query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "One of the queries used in Correcting suspect links. This one lists patients where an earlier record with that PHIN was listed as dispo field deceased, but a later e..."
 
mNo edit summary
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
One of the queries used in [[Correcting suspect links]].  
{{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_related_concepts=PHIN field; Dispo field; Deceased patients; Guideline for coding organ donation after death
|DIC_firmness=hard check
|DIC_coding=query ''Link suspect dead then alive''
|DIC_status=implemented
|DIC_LProblem=no
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
}}
Follow steps in [[Processing errors in patient data]] to fix errors found.


This one lists patients where an earlier record with that PHIN was listed as [[dispo field]] deceased, but a later entry then shows up.
== Related articles ==
{{Related Articles}}


[[Category: Data Processing]]
[[Category: Data Processing]]
[[Category:Multiple Encounter linking]]
[[Category:Multiple encounter longitudinal consistency check]]
[[Category:Registry checks]]

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: