Golden record

FieldValueTaken fromWhyDeciding tier
First nameKevinEnrollment enrollment:1479agency-a-derived/enrollment_clean.csv, row 1479Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWheelerEnrollment enrollment:1479agency-a-derived/enrollment_clean.csv, row 1479Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1947-02-27Enrollment enrollment:1479agency-a-derived/enrollment_clean.csv, row 1479Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******YM35Enrollment enrollment:1479agency-a-derived/enrollment_clean.csv, row 1479Most trusted source (enrollment over CRM)Rules (automatic)
Street945 Greene LightCRM crm:C-01614agency-a-snapshot/clients.csv, row 1614Most recent recordRules (automatic)
CitySmithtownCRM crm:C-01614agency-a-snapshot/clients.csv, row 1614Most recent recordRules (automatic)
StateILCRM crm:C-01614agency-a-snapshot/clients.csv, row 1614Most recent recordRules (automatic)
ZIP62342CRM crm:C-01614agency-a-snapshot/clients.csv, row 1614Most recent recordRules (automatic)
Phone(754) 555-0103CRM crm:C-01614agency-a-snapshot/clients.csv, row 1614Most recent recordRules (automatic)
Emailkevin.wheeler1614@example.comCRM crm:C-01614agency-a-snapshot/clients.csv, row 1614Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01614Enrollment enrollment:1479
First nameKevinKevin
Last nameWheelerWheeler
Birth date1947-02-271947-02-27
MBI (last 4 only)*******YM35*******YM35
Street945 Greene LightMissing
CitySmithtownMissing
StateILMissing
ZIP62342Missing
Phone(754) 555-0103Missing
Emailkevin.wheeler1614@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1614agency-a-derived/enrollment_clean.csv, row 1479
Active policyNoNo

Merge log lines for this person

LineActionPairTierScoreRule
1502Mergedcrm:C-01614 and enrollment:1479Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Denise Wheeler.same householdKevin WheelerDenise Wheeler

This person shares a household with Denise Wheeler.