PL SamePhin Diff DOB Sex: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=..
|DIC_summary=Another record exists with the same [[PHIN]] but a different [[Date of Birth]], [[Sex]]
|DIC_related_concepts=PHIN field; LastName field; FirstName field; Date of Birth; Sex field
|DIC_related_concepts=PHIN field; Date of Birth; Sex field
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_coding=query ''PL_SamePhin_Diff_LN_FN_DOB_Sex''
|DIC_coding=query ''PL_SamePhin_Diff_DOB_Sex''
|DIC_status=implemented
|DIC_status=implemented
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
Line 12: Line 12:


[[Category:Registry checks]]
[[Category:Registry checks]]
[[Category:PL queries]]
[[Category:Data Processing]]

Latest revision as of 14:27, 2020 December 17

Data Integrity Checks
Summary: Another record exists with the same PHIN but a different Date of Birth, Sex
Related: PHIN field, Date of Birth, Sex field
Firmness: hard check
Timing: always
App: Centralized data front end.accdb
Coding: query PL_SamePhin_Diff_DOB_Sex
Uses L Problem table: not entered
Status: implemented
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

Related articles

Related articles: