Golden record

FieldValueTaken fromWhyDeciding tier
First nameMadisonEnrollment enrollment:1262agency-a-derived/enrollment_clean.csv, row 1262Most trusted source (enrollment over CRM)Rules (automatic)
Last nameClarkeEnrollment enrollment:1262agency-a-derived/enrollment_clean.csv, row 1262Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1947-01-28Enrollment enrollment:1262agency-a-derived/enrollment_clean.csv, row 1262Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******DY09Enrollment enrollment:1262agency-a-derived/enrollment_clean.csv, row 1262Most trusted source (enrollment over CRM)Rules (automatic)
Street910 Patricia Isle Apt. 091CRM crm:C-01380agency-a-snapshot/clients.csv, row 1380Most recent recordRules (automatic)
CityNew AaronboroughCRM crm:C-01380agency-a-snapshot/clients.csv, row 1380Most recent recordRules (automatic)
StateORCRM crm:C-01380agency-a-snapshot/clients.csv, row 1380Most recent recordRules (automatic)
ZIP97818CRM crm:C-01380agency-a-snapshot/clients.csv, row 1380Most recent recordRules (automatic)
Phone(535) 555-0187CRM crm:C-01380agency-a-snapshot/clients.csv, row 1380Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01380Enrollment enrollment:1262
First nameMadisonMadison
Last nameClarkeClarke
Birth date1947-01-281947-01-28
MBI (last 4 only)*******DY09*******DY09
Street910 Patricia Isle Apt. 091Missing
CityNew AaronboroughMissing
StateORMissing
ZIP97818Missing
Phone(535) 555-0187Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1380agency-a-derived/enrollment_clean.csv, row 1262
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1282Mergedcrm:C-01380 and enrollment:1262Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Penny Clarke.same householdMadison ClarkePenny Clarke

This person shares a household with Penny Clarke.