Golden record

FieldValueTaken fromWhyDeciding tier
First nameSydneyEnrollment enrollment:602agency-a-derived/enrollment_clean.csv, row 602Most trusted source (enrollment over CRM)Rules (automatic)
Last nameLloydEnrollment enrollment:602agency-a-derived/enrollment_clean.csv, row 602Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1953-08-09Enrollment enrollment:602agency-a-derived/enrollment_clean.csv, row 602Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******DP87Enrollment enrollment:602agency-a-derived/enrollment_clean.csv, row 602Most trusted source (enrollment over CRM)Rules (automatic)
Street4550 Kemp WalkCRM crm:C-00684agency-a-snapshot/clients.csv, row 684Most recent recordRules (automatic)
CityLake BrentmouthCRM crm:C-00684agency-a-snapshot/clients.csv, row 684Most recent recordRules (automatic)
StateKSCRM crm:C-00684agency-a-snapshot/clients.csv, row 684Most recent recordRules (automatic)
ZIP66157CRM crm:C-00684agency-a-snapshot/clients.csv, row 684Most recent recordRules (automatic)
Phone(898) 555-0102CRM crm:C-00684agency-a-snapshot/clients.csv, row 684Most recent recordRules (automatic)
Emailsydney.lloyd684@example.comCRM crm:C-00684agency-a-snapshot/clients.csv, row 684Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00684Enrollment enrollment:602
First nameSydneySydney
Last nameLloydLloyd
Birth date1953-08-091953-08-09
MBI (last 4 only)*******DP87*******DP87
Street4550 Kemp WalkMissing
CityLake BrentmouthMissing
StateKSMissing
ZIP66157Missing
Phone(898) 555-0102Missing
Emailsydney.lloyd684@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 684agency-a-derived/enrollment_clean.csv, row 602
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
610Mergedcrm:C-00684 and enrollment:602Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Katelyn Lloyd.same householdSydney LloydKatelyn Lloyd

This person shares a household with Katelyn Lloyd.