Golden record

FieldValueTaken fromWhyDeciding tier
First nameKevinEnrollment enrollment:525agency-a-derived/enrollment_clean.csv, row 525Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWalkerEnrollment enrollment:525agency-a-derived/enrollment_clean.csv, row 525Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1949-01-08Enrollment enrollment:525agency-a-derived/enrollment_clean.csv, row 525Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******MR20Enrollment enrollment:525agency-a-derived/enrollment_clean.csv, row 525Most trusted source (enrollment over CRM)Rules (automatic)
Street923 Marisa Highway Suite 049CRM crm:C-00596agency-a-snapshot/clients.csv, row 596Most recent recordRules (automatic)
CityTroymouthCRM crm:C-00596agency-a-snapshot/clients.csv, row 596Most recent recordRules (automatic)
StateTXCRM crm:C-00596agency-a-snapshot/clients.csv, row 596Most recent recordRules (automatic)
ZIP79996CRM crm:C-00596agency-a-snapshot/clients.csv, row 596Most recent recordRules (automatic)
Phone(661) 555-0168CRM crm:C-00596agency-a-snapshot/clients.csv, row 596Most recent recordRules (automatic)
Emailkevin.walker596@example.comCRM crm:C-00596agency-a-snapshot/clients.csv, row 596Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00596Enrollment enrollment:524Enrollment enrollment:525
First nameKevinKevinKevin
Last nameWalkerWalkerWalker
Birth date1949-01-081949-01-081949-01-08
MBI (last 4 only)*******MR20*******MR20*******MR20
Street923 Marisa Highway Suite 049MissingMissing
CityTroymouthMissingMissing
StateTXMissingMissing
ZIP79996MissingMissing
Phone(661) 555-0168MissingMissing
Emailkevin.walker596@example.comMissingMissing
Sourceagency-a-snapshot/clients.csv, row 596agency-a-derived/enrollment_clean.csv, row 524agency-a-derived/enrollment_clean.csv, row 525
Active policyYesNoYes

Merge log lines for this person

LineActionPairTierScoreRule
531Mergedcrm:C-00596 and enrollment:524Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
532Mergedcrm:C-00596 and enrollment:525Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
2090Mergedenrollment:524 and enrollment:525Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Kylie Walker, Eric Walker.same householdsame householdKevin WalkerKylie WalkerEric Walker

This person shares a household with Kylie Walker, Eric Walker.