Golden record

FieldValueTaken fromWhyDeciding tier
First nameWilliamEnrollment enrollment:1322agency-a-derived/enrollment_clean.csv, row 1322Most trusted source (enrollment over CRM)Rules (automatic)
Last nameOdonnellEnrollment enrollment:1322agency-a-derived/enrollment_clean.csv, row 1322Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1949-03-13Enrollment enrollment:1322agency-a-derived/enrollment_clean.csv, row 1322Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******WQ97Enrollment enrollment:1322agency-a-derived/enrollment_clean.csv, row 1322Most trusted source (enrollment over CRM)Rules (automatic)
Street91203 Ann Locks Apt. 082CRM crm:C-01443agency-a-snapshot/clients.csv, row 1443Most recent recordRules (automatic)
CityPort DavidCRM crm:C-01443agency-a-snapshot/clients.csv, row 1443Most recent recordRules (automatic)
StateILCRM crm:C-01443agency-a-snapshot/clients.csv, row 1443Most recent recordRules (automatic)
ZIP60516CRM crm:C-01443agency-a-snapshot/clients.csv, row 1443Most recent recordRules (automatic)
Phone(269) 555-0175CRM crm:C-01443agency-a-snapshot/clients.csv, row 1443Most recent recordRules (automatic)
Emailwilliam.odonnell1443@example.comCRM crm:C-01443agency-a-snapshot/clients.csv, row 1443Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01443Enrollment enrollment:1322
First nameWilliamWilliam
Last nameOdonnellOdonnell
Birth date1949-03-131949-03-13
MBI (last 4 only)*******WQ97*******WQ97
Street91203 Ann Locks Apt. 082Missing
CityPort DavidMissing
StateILMissing
ZIP60516Missing
Phone(269) 555-0175Missing
Emailwilliam.odonnell1443@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1443agency-a-derived/enrollment_clean.csv, row 1322
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1342Mergedcrm:C-01443 and enrollment:1322Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Catherine Odonnell.same householdWilliam OdonnellCatherine Odonnell

This person shares a household with Catherine Odonnell.