Golden record

FieldValueTaken fromWhyDeciding tier
First nameAnnEnrollment enrollment:829agency-a-derived/enrollment_clean.csv, row 829Most trusted source (enrollment over CRM)Rules (automatic)
Last nameRobinsonEnrollment enrollment:829agency-a-derived/enrollment_clean.csv, row 829Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1936-05-12Enrollment enrollment:829agency-a-derived/enrollment_clean.csv, row 829Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******MP28Enrollment enrollment:829agency-a-derived/enrollment_clean.csv, row 829Most trusted source (enrollment over CRM)Rules (automatic)
Street05053 Bradley Islands Apt. 816CRM crm:C-00924agency-a-snapshot/clients.csv, row 924Most recent recordRules (automatic)
CityCarolynhavenCRM crm:C-00924agency-a-snapshot/clients.csv, row 924Most recent recordRules (automatic)
StateSCCRM crm:C-00924agency-a-snapshot/clients.csv, row 924Most recent recordRules (automatic)
ZIP29575CRM crm:C-00924agency-a-snapshot/clients.csv, row 924Most recent recordRules (automatic)
Phone(786) 555-0139CRM crm:C-00924agency-a-snapshot/clients.csv, row 924Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00924Enrollment enrollment:829
First nameAnnAnn
Last nameRobinsonRobinson
Birth date1936-05-121936-05-12
MBI (last 4 only)*******MP28*******MP28
Street05053 Bradley Islands Apt. 816Missing
CityCarolynhavenMissing
StateSCMissing
ZIP29575Missing
Phone(786) 555-0139Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 924agency-a-derived/enrollment_clean.csv, row 829
Active policyNoNo

Merge log lines for this person

LineActionPairTierScoreRule
844Mergedcrm:C-00924 and enrollment:829Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Ann Robinson

Only this person is in the household.

  • Ann Robinson (this person)