Golden record

FieldValueTaken fromWhyDeciding tier
First nameGregoryEnrollment enrollment:477agency-a-derived/enrollment_clean.csv, row 477Most trusted source (enrollment over CRM)Rules (automatic)
Last nameHollandEnrollment enrollment:477agency-a-derived/enrollment_clean.csv, row 477Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1936-02-27Enrollment enrollment:477agency-a-derived/enrollment_clean.csv, row 477Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******EQ79Enrollment enrollment:477agency-a-derived/enrollment_clean.csv, row 477Most trusted source (enrollment over CRM)Rules (automatic)
Street98554 Brown Rue Apt. 585CRM crm:C-00546agency-a-snapshot/clients.csv, row 546Most recent recordRules (automatic)
CityPort SteveportCRM crm:C-00546agency-a-snapshot/clients.csv, row 546Most recent recordRules (automatic)
StateLACRM crm:C-00546agency-a-snapshot/clients.csv, row 546Most recent recordRules (automatic)
ZIP70061CRM crm:C-00546agency-a-snapshot/clients.csv, row 546Most recent recordRules (automatic)
Phone(399) 555-0123CRM crm:C-00546agency-a-snapshot/clients.csv, row 546Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00546Enrollment enrollment:477
First nameGregoryGregory
Last nameHollandHolland
Birth date1936-02-271936-02-27
MBI (last 4 only)*******EQ79*******EQ79
Street98554 Brown Rue Apt. 585Missing
CityPort SteveportMissing
StateLAMissing
ZIP70061Missing
Phone(399) 555-0123Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 546agency-a-derived/enrollment_clean.csv, row 477
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
482Mergedcrm:C-00546 and enrollment:477Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Benjamin Holland.same householdGregory HollandBenjamin Holland

This person shares a household with Benjamin Holland.