Golden record

FieldValueTaken fromWhyDeciding tier
First nameCynthiaEnrollment enrollment:1670agency-a-derived/enrollment_clean.csv, row 1670Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWagnerEnrollment enrollment:1670agency-a-derived/enrollment_clean.csv, row 1670Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1935-10-24Enrollment enrollment:1670agency-a-derived/enrollment_clean.csv, row 1670Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******FF32Enrollment enrollment:1670agency-a-derived/enrollment_clean.csv, row 1670Most trusted source (enrollment over CRM)Rules (automatic)
Street83896 Jason OrchardCRM crm:C-01809agency-a-snapshot/clients.csv, row 1809Most recent recordRules (automatic)
CityMcculloughlandCRM crm:C-01809agency-a-snapshot/clients.csv, row 1809Most recent recordRules (automatic)
StateFLCRM crm:C-01809agency-a-snapshot/clients.csv, row 1809Most recent recordRules (automatic)
ZIP33297CRM crm:C-01809agency-a-snapshot/clients.csv, row 1809Most recent recordRules (automatic)
Phone(294) 555-0138CRM crm:C-01809agency-a-snapshot/clients.csv, row 1809Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01809Enrollment enrollment:1670
First nameCynthiaCynthia
Last nameWgnerWagner
Birth date1935-10-241935-10-24
MBI (last 4 only)*******FF32*******FF32
Street83896 Jason OrchardMissing
CityMcculloughlandMissing
StateFLMissing
ZIP33297Missing
Phone(294) 555-0138Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1809agency-a-derived/enrollment_clean.csv, row 1670
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1697Mergedcrm:C-01809 and enrollment:1670Rules (automatic)0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Cynthia Wagner

Only this person is in the household.

  • Cynthia Wagner (this person)