Golden record

FieldValueTaken fromWhyDeciding tier
First nameAmyEnrollment enrollment:1462agency-a-derived/enrollment_clean.csv, row 1462Most trusted source (enrollment over CRM)Rules (automatic)
Last nameHillEnrollment enrollment:1462agency-a-derived/enrollment_clean.csv, row 1462Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1941-05-29Enrollment enrollment:1462agency-a-derived/enrollment_clean.csv, row 1462Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******YD70Enrollment enrollment:1462agency-a-derived/enrollment_clean.csv, row 1462Most trusted source (enrollment over CRM)Rules (automatic)
Street516 Ernest KnollsCRM crm:C-01597agency-a-snapshot/clients.csv, row 1597Most recent recordRules (automatic)
CityPort CrystalCRM crm:C-01597agency-a-snapshot/clients.csv, row 1597Most recent recordRules (automatic)
StateSDCRM crm:C-01597agency-a-snapshot/clients.csv, row 1597Most recent recordRules (automatic)
ZIP57113CRM crm:C-01597agency-a-snapshot/clients.csv, row 1597Most recent recordRules (automatic)
Phone(805) 555-0142CRM crm:C-01597agency-a-snapshot/clients.csv, row 1597Most recent recordRules (automatic)
Emailamy.hill1597@example.comCRM crm:C-01597agency-a-snapshot/clients.csv, row 1597Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01597Enrollment enrollment:1462
First nameAmyAmy
Last nameHillHill
Birth date1941-05-291941-05-29
MBI (last 4 only)*******YD70*******YD70
Street516 Ernest KnollsMissing
CityPort CrystalMissing
StateSDMissing
ZIP57113Missing
Phone(805) 555-0142Missing
Emailamy.hill1597@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1597agency-a-derived/enrollment_clean.csv, row 1462
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1486Mergedcrm:C-01597 and enrollment:1462Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Amy Hill

Only this person is in the household.

  • Amy Hill (this person)