Golden record

FieldValueTaken fromWhyDeciding tier
First nameStephenEnrollment enrollment:871agency-a-derived/enrollment_clean.csv, row 871Most trusted source (enrollment over CRM)Rules (automatic)
Last nameRiosEnrollment enrollment:871agency-a-derived/enrollment_clean.csv, row 871Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1953-07-15Enrollment enrollment:871agency-a-derived/enrollment_clean.csv, row 871Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******YM32Enrollment enrollment:871agency-a-derived/enrollment_clean.csv, row 871Most trusted source (enrollment over CRM)Rules (automatic)
Street52774 Tina Knolls Apt. 586CRM crm:C-00970agency-a-snapshot/clients.csv, row 970Most recent recordRules (automatic)
CityEast DianastadCRM crm:C-00970agency-a-snapshot/clients.csv, row 970Most recent recordRules (automatic)
StateSDCRM crm:C-00970agency-a-snapshot/clients.csv, row 970Most recent recordRules (automatic)
ZIP57471CRM crm:C-00970agency-a-snapshot/clients.csv, row 970Most recent recordRules (automatic)
Phone(960) 555-0129CRM crm:C-00970agency-a-snapshot/clients.csv, row 970Most recent recordRules (automatic)
Emailstephen.rios970@example.comCRM crm:C-00970agency-a-snapshot/clients.csv, row 970Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00970Enrollment enrollment:871
First nameStephenStephen
Last nameRiosRios
Birth date1953-07-151953-07-15
MBI (last 4 only)*******YM32*******YM32
Street52774 Tina Knolls Apt. 586Missing
CityEast DianastadMissing
StateSDMissing
ZIP57471Missing
Phone(960) 555-0129Missing
Emailstephen.rios970@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 970agency-a-derived/enrollment_clean.csv, row 871
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
887Mergedcrm:C-00970 and enrollment:871Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Anna Rios.same householdStephen RiosAnna Rios

This person shares a household with Anna Rios.

  • Anna Rios: same household
  • Stephen Rios (this person)