Golden record

FieldValueTaken fromWhyDeciding tier
First nameDeborahEnrollment enrollment:1509agency-a-derived/enrollment_clean.csv, row 1509Most trusted source (enrollment over CRM)Rules (automatic)
Last nameSmithEnrollment enrollment:1509agency-a-derived/enrollment_clean.csv, row 1509Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1960-05-22Enrollment enrollment:1509agency-a-derived/enrollment_clean.csv, row 1509Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******MT07Enrollment enrollment:1509agency-a-derived/enrollment_clean.csv, row 1509Most trusted source (enrollment over CRM)Rules (automatic)
Street9671 Smith Spurs Apt. 666CRM crm:C-01647agency-a-snapshot/clients.csv, row 1647Most recent recordRules (automatic)
CityAdamslandCRM crm:C-01647agency-a-snapshot/clients.csv, row 1647Most recent recordRules (automatic)
StateILCRM crm:C-01647agency-a-snapshot/clients.csv, row 1647Most recent recordRules (automatic)
ZIP61003CRM crm:C-01647agency-a-snapshot/clients.csv, row 1647Most recent recordRules (automatic)
Phone(826) 555-0192CRM crm:C-01647agency-a-snapshot/clients.csv, row 1647Most recent recordRules (automatic)
Emaildeborah.smith1647@example.comCRM crm:C-01647agency-a-snapshot/clients.csv, row 1647Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01647Enrollment enrollment:1509
First nameDeborahDeborah
Last nameSmithSmith
Birth date1960-05-221960-05-22
MBI (last 4 only)*******MT07*******MT07
Street9671 Smith Spurs Apt. 666Missing
CityAdamslandMissing
StateILMissing
ZIP61003Missing
Phone(826) 555-0192Missing
Emaildeborah.smith1647@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1647agency-a-derived/enrollment_clean.csv, row 1509
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1532Mergedcrm:C-01647 and enrollment:1509Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Deborah Smith

Only this person is in the household.

  • Deborah Smith (this person)