Golden record

FieldValueTaken fromWhyDeciding tier
First nameHollyEnrollment enrollment:1367agency-a-derived/enrollment_clean.csv, row 1367Most trusted source (enrollment over CRM)Rules (automatic)
Last nameRussellEnrollment enrollment:1367agency-a-derived/enrollment_clean.csv, row 1367Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1950-05-15Enrollment enrollment:1367agency-a-derived/enrollment_clean.csv, row 1367Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******XR78Enrollment enrollment:1367agency-a-derived/enrollment_clean.csv, row 1367Most trusted source (enrollment over CRM)Rules (automatic)
Street31234 Kimberly MeadowsCRM crm:C-01485agency-a-snapshot/clients.csv, row 1485Most recent recordRules (automatic)
CityElliotttonCRM crm:C-01485agency-a-snapshot/clients.csv, row 1485Most recent recordRules (automatic)
StateNCCRM crm:C-01485agency-a-snapshot/clients.csv, row 1485Most recent recordRules (automatic)
ZIP27879CRM crm:C-01485agency-a-snapshot/clients.csv, row 1485Most recent recordRules (automatic)
Phone(407) 555-0186CRM crm:C-01485agency-a-snapshot/clients.csv, row 1485Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01485Enrollment enrollment:1367
First nameHollyHolly
Last nameRussellRussell
Birth date1950-05-151950-05-15
MBI (last 4 only)*******XR78*******XR78
Street31234 Kimberly MeadowsMissing
CityElliotttonMissing
StateNCMissing
ZIP27879Missing
Phone(407) 555-0186Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1485agency-a-derived/enrollment_clean.csv, row 1367
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1389Mergedcrm:C-01485 and enrollment:1367Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Veronica Russell.same householdHolly RussellVeronica Russell

This person shares a household with Veronica Russell.