Golden record

FieldValueTaken fromWhyDeciding tier
First nameRileyEnrollment enrollment:1026agency-a-derived/enrollment_clean.csv, row 1026Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBrownEnrollment enrollment:1026agency-a-derived/enrollment_clean.csv, row 1026Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1949-05-06Enrollment enrollment:1026agency-a-derived/enrollment_clean.csv, row 1026Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******AW42Enrollment enrollment:1026agency-a-derived/enrollment_clean.csv, row 1026Most trusted source (enrollment over CRM)Rules (automatic)
Street5557 Coleman LockCRM crm:C-01128agency-a-snapshot/clients.csv, row 1128Most recent recordRules (automatic)
CitySmithfurtCRM crm:C-01128agency-a-snapshot/clients.csv, row 1128Most recent recordRules (automatic)
StateSDCRM crm:C-01128agency-a-snapshot/clients.csv, row 1128Most recent recordRules (automatic)
ZIP57121CRM crm:C-01128agency-a-snapshot/clients.csv, row 1128Most recent recordRules (automatic)
Phone(852) 555-0156CRM crm:C-01128agency-a-snapshot/clients.csv, row 1128Most recent recordRules (automatic)
Emailriley.brown1128@example.comCRM crm:C-01128agency-a-snapshot/clients.csv, row 1128Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01128Enrollment enrollment:1026
First nameRileyRiley
Last nameBrownBrown
Birth date1949-05-061949-05-06
MBI (last 4 only)*******AW42*******AW42
Street5557 Coleman LockMissing
CitySmithfurtMissing
StateSDMissing
ZIP57121Missing
Phone(852) 555-0156Missing
Emailriley.brown1128@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1128agency-a-derived/enrollment_clean.csv, row 1026
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1041Mergedcrm:C-01128 and enrollment:1026Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Debbie Brown.same householdRiley BrownDebbie Brown

This person shares a household with Debbie Brown.