Golden record

FieldValueTaken fromWhyDeciding tier
First nameChristopherEnrollment enrollment:458agency-a-derived/enrollment_clean.csv, row 458Most trusted source (enrollment over CRM)Rules (automatic)
Last nameCarpenterEnrollment enrollment:458agency-a-derived/enrollment_clean.csv, row 458Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1946-07-17Enrollment enrollment:458agency-a-derived/enrollment_clean.csv, row 458Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******MN59Enrollment enrollment:458agency-a-derived/enrollment_clean.csv, row 458Most trusted source (enrollment over CRM)Rules (automatic)
Street384 House Ports Suite 009CRM crm:C-00528agency-a-snapshot/clients.csv, row 528Most recent recordRules (automatic)
CityBushvilleCRM crm:C-00528agency-a-snapshot/clients.csv, row 528Most recent recordRules (automatic)
StateILCRM crm:C-00528agency-a-snapshot/clients.csv, row 528Most recent recordRules (automatic)
ZIP62778CRM crm:C-00528agency-a-snapshot/clients.csv, row 528Most recent recordRules (automatic)
Phone(238) 555-0110CRM crm:C-00528agency-a-snapshot/clients.csv, row 528Most recent recordRules (automatic)
Emailchristopher.carpenter528@example.comCRM crm:C-00528agency-a-snapshot/clients.csv, row 528Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00528Enrollment enrollment:458
First nameChristopherChristopher
Last nameCarpenterCarpenter
Birth date1946-07-171946-07-17
MBI (last 4 only)*******MN59*******MN59
Street384 House Ports Suite 009Missing
CityBushvilleMissing
StateILMissing
ZIP62778Missing
Phone(238) 555-0110Missing
Emailchristopher.carpenter528@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 528agency-a-derived/enrollment_clean.csv, row 458
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
463Mergedcrm:C-00528 and enrollment:458Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Suzanne Carpenter.same householdChristopher CarpenterSuzanne Carpenter

This person shares a household with Suzanne Carpenter.