Golden record

FieldValueTaken fromWhyDeciding tier
First nameTimothyEnrollment enrollment:11agency-a-derived/enrollment_clean.csv, row 11Most trusted source (enrollment over CRM)Rules (automatic)
Last nameRussellEnrollment enrollment:11agency-a-derived/enrollment_clean.csv, row 11Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1936-06-10Enrollment enrollment:11agency-a-derived/enrollment_clean.csv, row 11Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******AD37Enrollment enrollment:11agency-a-derived/enrollment_clean.csv, row 11Most trusted source (enrollment over CRM)Rules (automatic)
Street62473 Scott Wall Apt. 080CRM crm:C-00014agency-a-snapshot/clients.csv, row 14Most recent recordRules (automatic)
CityPort MelindaburghCRM crm:C-00014agency-a-snapshot/clients.csv, row 14Most recent recordRules (automatic)
StateKYCRM crm:C-00014agency-a-snapshot/clients.csv, row 14Most recent recordRules (automatic)
ZIP42617CRM crm:C-00014agency-a-snapshot/clients.csv, row 14Most recent recordRules (automatic)
Phone(325) 555-0101CRM crm:C-00014agency-a-snapshot/clients.csv, row 14Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00014Enrollment enrollment:11
First nameTimothyTimothy
Last nameRussellRussell
Birth date1936-06-101936-06-10
MBI (last 4 only)*******AD37*******AD37
Street62473 Scott Wall Apt. 080Missing
CityPort MelindaburghMissing
StateKYMissing
ZIP42617Missing
Phone(325) 555-0101Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 14agency-a-derived/enrollment_clean.csv, row 11
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
12Mergedcrm:C-00014 and enrollment:11Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Timothy Russell

Only this person is in the household.

  • Timothy Russell (this person)