Golden record

FieldValueTaken fromWhyDeciding tier
First nameJamesEnrollment enrollment:1173agency-a-derived/enrollment_clean.csv, row 1173Most trusted source (enrollment over CRM)Rules (automatic)
Last nameEvansEnrollment enrollment:1173agency-a-derived/enrollment_clean.csv, row 1173Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1950-09-16Enrollment enrollment:1173agency-a-derived/enrollment_clean.csv, row 1173Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******UF76Enrollment enrollment:1173agency-a-derived/enrollment_clean.csv, row 1173Most trusted source (enrollment over CRM)Rules (automatic)
Street0388 Wright LaneCRM crm:C-01277agency-a-snapshot/clients.csv, row 1277Most recent recordRules (automatic)
CityHaynestownCRM crm:C-01277agency-a-snapshot/clients.csv, row 1277Most recent recordRules (automatic)
StateIDCRM crm:C-01277agency-a-snapshot/clients.csv, row 1277Most recent recordRules (automatic)
ZIP83219CRM crm:C-01277agency-a-snapshot/clients.csv, row 1277Most recent recordRules (automatic)
Phone(662) 555-0155CRM crm:C-01277agency-a-snapshot/clients.csv, row 1277Most recent recordRules (automatic)
Emailjames.evans1277@example.comCRM crm:C-01277agency-a-snapshot/clients.csv, row 1277Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01277Enrollment enrollment:1173
First nameJamesJames
Last nameEvansEvans
Birth date1950-09-161950-09-16
MBI (last 4 only)*******UF76*******UF76
Street0388 Wright LaneMissing
CityHaynestownMissing
StateIDMissing
ZIP83219Missing
Phone(662) 555-0155Missing
Emailjames.evans1277@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1277agency-a-derived/enrollment_clean.csv, row 1173
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1193Mergedcrm:C-01277 and enrollment:1173Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Kenneth Evans.same householdJames EvansKenneth Evans

This person shares a household with Kenneth Evans.