Golden record

FieldValueTaken fromWhyDeciding tier
First nameCameronEnrollment enrollment:1105agency-a-derived/enrollment_clean.csv, row 1105Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBarnettEnrollment enrollment:1105agency-a-derived/enrollment_clean.csv, row 1105Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1955-02-20Enrollment enrollment:1105agency-a-derived/enrollment_clean.csv, row 1105Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******PG57Enrollment enrollment:1105agency-a-derived/enrollment_clean.csv, row 1105Most trusted source (enrollment over CRM)Rules (automatic)
Street73929 Pace ShoalsCRM crm:C-01208agency-a-snapshot/clients.csv, row 1208Most recent recordRules (automatic)
CityBowersvilleCRM crm:C-01208agency-a-snapshot/clients.csv, row 1208Most recent recordRules (automatic)
StateDECRM crm:C-01208agency-a-snapshot/clients.csv, row 1208Most recent recordRules (automatic)
ZIP19739CRM crm:C-01208agency-a-snapshot/clients.csv, row 1208Most recent recordRules (automatic)
Phone(607) 555-0178CRM crm:C-01208agency-a-snapshot/clients.csv, row 1208Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01208Enrollment enrollment:1105
First nameCameronCameron
Last nameBarnettBarnett
Birth date1955-02-201955-02-20
MBI (last 4 only)*******PG57*******PG57
Street73929 Pace ShoalsMissing
CityBowersvilleMissing
StateDEMissing
ZIP19739Missing
Phone(607) 555-0178Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1208agency-a-derived/enrollment_clean.csv, row 1105
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1124Mergedcrm:C-01208 and enrollment:1105Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Cameron Barnett

Only this person is in the household.

  • Cameron Barnett (this person)