Golden record

FieldValueTaken fromWhyDeciding tier
First nameWilliamEnrollment enrollment:918agency-a-derived/enrollment_clean.csv, row 918Most trusted source (enrollment over CRM)Rules (automatic)
Last nameArnoldEnrollment enrollment:918agency-a-derived/enrollment_clean.csv, row 918Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1959-04-03Enrollment enrollment:918agency-a-derived/enrollment_clean.csv, row 918Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******TJ38Enrollment enrollment:918agency-a-derived/enrollment_clean.csv, row 918Most trusted source (enrollment over CRM)Rules (automatic)
Street14477 Nicole Heights Suite 913CRM crm:C-01023agency-a-snapshot/clients.csv, row 1023Most recent recordRules (automatic)
CityDonaldboroughCRM crm:C-01023agency-a-snapshot/clients.csv, row 1023Most recent recordRules (automatic)
StateCACRM crm:C-01023agency-a-snapshot/clients.csv, row 1023Most recent recordRules (automatic)
ZIP94168CRM crm:C-01023agency-a-snapshot/clients.csv, row 1023Most recent recordRules (automatic)
Phone(633) 555-0122CRM crm:C-01023agency-a-snapshot/clients.csv, row 1023Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01023Enrollment enrollment:918
First nameWilliamWilliam
Last nameArnoldArnold
Birth date1959-04-031959-04-03
MBI (last 4 only)*******TJ38*******TJ38
Street14477 Nicole Heights Suite 913Missing
CityDonaldboroughMissing
StateCAMissing
ZIP94168Missing
Phone(633) 555-0122Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1023agency-a-derived/enrollment_clean.csv, row 918
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
933Mergedcrm:C-01023 and enrollment:918Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.William Arnold

Only this person is in the household.

  • William Arnold (this person)