PL DiffPhin SameLN FN DOB

From CCMDB Wiki
Revision as of 22:13, 22 July 2025 by Ttenbergen (talk | contribs) (Text replacement - "|DIC_LProblem=no" to "|DIC_LProblem=No")
Jump to navigation Jump to search
Data Integrity Checks
Summary: Checks that there are no likely matches of this patient with a different PHIN (ie typos)
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:

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: