Golden record

FieldValueTaken fromWhyDeciding tier
First nameTroyEnrollment enrollment:1231agency-a-derived/enrollment_clean.csv, row 1231Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBurnettEnrollment enrollment:1231agency-a-derived/enrollment_clean.csv, row 1231Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1952-06-28Enrollment enrollment:1231agency-a-derived/enrollment_clean.csv, row 1231Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******KM07Enrollment enrollment:1231agency-a-derived/enrollment_clean.csv, row 1231Most trusted source (enrollment over CRM)Rules (automatic)
Street785 Jonathan Cliffs Suite 168CRM crm:C-01338agency-a-snapshot/clients.csv, row 1338Most recent recordRules (automatic)
CitySmithboroughCRM crm:C-01338agency-a-snapshot/clients.csv, row 1338Most recent recordRules (automatic)
StateILCRM crm:C-01338agency-a-snapshot/clients.csv, row 1338Most recent recordRules (automatic)
ZIP60784CRM crm:C-01338agency-a-snapshot/clients.csv, row 1338Most recent recordRules (automatic)
Phone(601) 555-0192CRM crm:C-01338agency-a-snapshot/clients.csv, row 1338Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01338Enrollment enrollment:1231
First nameTroyTroy
Last nameBurnettBurnett
Birth date1952-06-281952-06-28
MBI (last 4 only)*******KM07*******KM07
Street785 Jonathan Cliffs Suite 168Missing
CitySmithboroughMissing
StateILMissing
ZIP60784Missing
Phone(601) 555-0192Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1338agency-a-derived/enrollment_clean.csv, row 1231
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1251Mergedcrm:C-01338 and enrollment:1231Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Jonathan Burnett.same householdTroy BurnettJonathan Burnett

This person shares a household with Jonathan Burnett.