PL DiffPhin SameLN FN DOB: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Ttenbergen moved page PL Diff Phin SameLN FN DOB to PL DiffPhin SameLN FN DOB without leaving a redirect: Text replacement - "PL Diff Phin SameLN FN DOB" to "PL DiffPhin SameLN FN DOB"
No edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=Checks that there are no likely matches of this patient with a different [[PHIN]] (ie typos)
|DIC_summary=Checks that there are no likely matches of this patient with a different [[PHIN]] (ie typos) as per [[PHIN field#Multiple PHINs or PHIN changes over time]]
|DIC_related_concepts=PHIN field; LastName field; FirstName field; Date of Birth
|DIC_related_concepts=PHIN field; LastName field; FirstName field; Date of Birth
|DIC_firmness=soft check
|DIC_firmness=soft check
|DIC_coding=query ''PL Diff Phin SameLN FN DOB''
|DIC_coding=query ''PL Diff Phin SameLN FN DOB''
|DIC_status=implemented
|DIC_status=implemented
|DIC_LProblem=no
|DIC_LProblem=No
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
|DIC_backlogged=No
}}
}}
This query validates that our data follows what is described in [[PHIN field#Multiple PHINs or PHIN changes over time]].
If names are different (as they can be as of 2020-12-17) this query just won't catch them, it won't give a false positive, so we can continue to run it.
If names are different (as they can be as of 2020-12-17) this query just won't catch them, it won't give a false positive, so we can continue to run it.



Latest revision as of 14:13, 7 August 2025

Data Integrity Checks
Summary: Checks that there are no likely matches of this patient with a different PHIN (ie typos) as per PHIN field#Multiple PHINs or PHIN changes over time
Related: PHIN field, LastName field, FirstName field, Date of Birth
Firmness: soft check
Timing: always
App: Centralized data front end.accdb
Coding: query PL Diff Phin SameLN FN DOB
Uses L Problem table: No
Status: implemented
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:

This query validates that our data follows what is described in PHIN field#Multiple PHINs or PHIN changes over time.

If names are different (as they can be as of 2020-12-17) this query just won't catch them, it won't give a false positive, so we can continue to run it.

Related articles

Related articles: