PL DiffPhin SameLN FN DOB

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.