Golden record

FieldValueTaken fromWhyDeciding tier
First nameSeanEnrollment enrollment:468agency-a-derived/enrollment_clean.csv, row 468Most trusted source (enrollment over CRM)Rules (automatic)
Last nameGarciaEnrollment enrollment:468agency-a-derived/enrollment_clean.csv, row 468Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1958-01-03Enrollment enrollment:468agency-a-derived/enrollment_clean.csv, row 468Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******DF89Enrollment enrollment:468agency-a-derived/enrollment_clean.csv, row 468Most trusted source (enrollment over CRM)Rules (automatic)
Street525 Emily VillageCRM crm:C-00538agency-a-snapshot/clients.csv, row 538Most recent recordRules (automatic)
CityNorth RoberthavenCRM crm:C-00538agency-a-snapshot/clients.csv, row 538Most recent recordRules (automatic)
StateCACRM crm:C-00538agency-a-snapshot/clients.csv, row 538Most recent recordRules (automatic)
ZIP94633CRM crm:C-00538agency-a-snapshot/clients.csv, row 538Most recent recordRules (automatic)
Phone(589) 555-0119CRM crm:C-00538agency-a-snapshot/clients.csv, row 538Most recent recordRules (automatic)
Emailsean.garcia538@example.comCRM crm:C-00538agency-a-snapshot/clients.csv, row 538Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00538Enrollment enrollment:468
First nameSeanSean
Last nameGarciaGarcia
Birth date1958-01-031958-01-03
MBI (last 4 only)*******DF89*******DF89
Street525 Emily VillageMissing
CityNorth RoberthavenMissing
StateCAMissing
ZIP94633Missing
Phone(589) 555-0119Missing
Emailsean.garcia538@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 538agency-a-derived/enrollment_clean.csv, row 468
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
473Mergedcrm:C-00538 and enrollment:468Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Sean Garcia

Only this person is in the household.

  • Sean Garcia (this person)