Golden record

FieldValueTaken fromWhyDeciding tier
First nameTammyEnrollment enrollment:281agency-a-derived/enrollment_clean.csv, row 281Most trusted source (enrollment over CRM)Rules (automatic)
Last namePowellEnrollment enrollment:281agency-a-derived/enrollment_clean.csv, row 281Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1947-04-13Enrollment enrollment:281agency-a-derived/enrollment_clean.csv, row 281Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******XA73Enrollment enrollment:281agency-a-derived/enrollment_clean.csv, row 281Most trusted source (enrollment over CRM)Rules (automatic)
Street007 Clark Trail Apt. 927CRM crm:C-00330agency-a-snapshot/clients.csv, row 330Most recent recordRules (automatic)
CityEast ChristinachesterCRM crm:C-00330agency-a-snapshot/clients.csv, row 330Most recent recordRules (automatic)
StateMTCRM crm:C-00330agency-a-snapshot/clients.csv, row 330Most recent recordRules (automatic)
ZIP59558CRM crm:C-00330agency-a-snapshot/clients.csv, row 330Most recent recordRules (automatic)
Phone(346) 555-0101CRM crm:C-00330agency-a-snapshot/clients.csv, row 330Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00330Enrollment enrollment:281
First nameTammyTammy
Last namePowellPowell
Birth date1947-04-131947-04-13
MBI (last 4 only)*******XA73*******XA73
Street007 Clark Trail Apt. 927Missing
CityEast ChristinachesterMissing
StateMTMissing
ZIP59558Missing
Phone(346) 555-0101Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 330agency-a-derived/enrollment_clean.csv, row 281
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
283Mergedcrm:C-00330 and enrollment:281Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Tammy Powell

Only this person is in the household.

  • Tammy Powell (this person)