Golden record

FieldValueTaken fromWhyDeciding tier
First nameJoshuaEnrollment enrollment:520agency-a-derived/enrollment_clean.csv, row 520Most trusted source (enrollment over CRM)Rules (automatic)
Last nameFowlerEnrollment enrollment:520agency-a-derived/enrollment_clean.csv, row 520Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1957-06-13Enrollment enrollment:520agency-a-derived/enrollment_clean.csv, row 520Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******TN00Enrollment enrollment:520agency-a-derived/enrollment_clean.csv, row 520Most trusted source (enrollment over CRM)Rules (automatic)
Street34785 Sarah RampCRM crm:C-00592agency-a-snapshot/clients.csv, row 592Most recent recordRules (automatic)
CityDavischesterCRM crm:C-00592agency-a-snapshot/clients.csv, row 592Most recent recordRules (automatic)
StateKSCRM crm:C-00592agency-a-snapshot/clients.csv, row 592Most recent recordRules (automatic)
ZIP67137CRM crm:C-00592agency-a-snapshot/clients.csv, row 592Most recent recordRules (automatic)
Phone(575) 555-0179CRM crm:C-00592agency-a-snapshot/clients.csv, row 592Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00592Enrollment enrollment:520
First nameJoshuaJoshua
Last nameFowlerFowler
Birth date1957-06-131957-06-13
MBI (last 4 only)*******TN00*******TN00
Street34785 Sarah RampMissing
CityDavischesterMissing
StateKSMissing
ZIP67137Missing
Phone(575) 555-0179Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 592agency-a-derived/enrollment_clean.csv, row 520
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
527Mergedcrm:C-00592 and enrollment:520Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Gregory Fowler.same householdJoshua FowlerGregory Fowler

This person shares a household with Gregory Fowler.