Golden record

FieldValueTaken fromWhyDeciding tier
First nameReginaldEnrollment enrollment:1084agency-a-derived/enrollment_clean.csv, row 1084Most trusted source (enrollment over CRM)Rules (automatic)
Last nameStoneEnrollment enrollment:1084agency-a-derived/enrollment_clean.csv, row 1084Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1936-03-15Enrollment enrollment:1084agency-a-derived/enrollment_clean.csv, row 1084Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******FJ16Enrollment enrollment:1084agency-a-derived/enrollment_clean.csv, row 1084Most trusted source (enrollment over CRM)Rules (automatic)
Street04309 Massey MallCRM crm:C-01187agency-a-snapshot/clients.csv, row 1187Most recent recordRules (automatic)
CitySouth JacobCRM crm:C-01187agency-a-snapshot/clients.csv, row 1187Most recent recordRules (automatic)
StateNECRM crm:C-01187agency-a-snapshot/clients.csv, row 1187Most recent recordRules (automatic)
ZIP68703CRM crm:C-01187agency-a-snapshot/clients.csv, row 1187Most recent recordRules (automatic)
Phone(705) 555-0109CRM crm:C-01187agency-a-snapshot/clients.csv, row 1187Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01187Enrollment enrollment:1084
First nameReginaldReginald
Last nameStoneStone
Birth date1936-03-151936-03-15
MBI (last 4 only)*******FJ16*******FJ16
Street04309 Massey MallMissing
CitySouth JacobMissing
StateNEMissing
ZIP68703Missing
Phone(705) 555-0109Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1187agency-a-derived/enrollment_clean.csv, row 1084
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1103Mergedcrm:C-01187 and enrollment:1084Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Barbara Stone.same householdReginald StoneBarbara Stone

This person shares a household with Barbara Stone.