Golden record

FieldValueTaken fromWhyDeciding tier
First nameKatelynEnrollment enrollment:603agency-a-derived/enrollment_clean.csv, row 603Most trusted source (enrollment over CRM)Rules (automatic)
Last nameLloydEnrollment enrollment:603agency-a-derived/enrollment_clean.csv, row 603Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1935-02-08Enrollment enrollment:603agency-a-derived/enrollment_clean.csv, row 603Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******AV65Enrollment enrollment:603agency-a-derived/enrollment_clean.csv, row 603Most trusted source (enrollment over CRM)Rules (automatic)
Street4550 Kemp WalkCRM crm:C-00685agency-a-snapshot/clients.csv, row 685Most recent recordRules (automatic)
CityLake BrentmouthCRM crm:C-00685agency-a-snapshot/clients.csv, row 685Most recent recordRules (automatic)
StateKSCRM crm:C-00685agency-a-snapshot/clients.csv, row 685Most recent recordRules (automatic)
ZIP66157CRM crm:C-00685agency-a-snapshot/clients.csv, row 685Most recent recordRules (automatic)
Phone(781) 555-0152CRM crm:C-00685agency-a-snapshot/clients.csv, row 685Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00685Enrollment enrollment:603
First nameKatelynKatelyn
Last nameLloydLloyd
Birth date1935-02-081935-02-08
MBI (last 4 only)*******AV65*******AV65
Street4550 Kemp WalkMissing
CityLake BrentmouthMissing
StateKSMissing
ZIP66157Missing
Phone(781) 555-0152Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 685agency-a-derived/enrollment_clean.csv, row 603
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
611Mergedcrm:C-00685 and enrollment:603Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Sydney Lloyd.same householdKatelyn LloydSydney Lloyd

This person shares a household with Sydney Lloyd.