Golden record

FieldValueTaken fromWhyDeciding tier
First nameRonaldEnrollment enrollment:662agency-a-derived/enrollment_clean.csv, row 662Most trusted source (enrollment over CRM)Rules (automatic)
Last nameRobinsonEnrollment enrollment:662agency-a-derived/enrollment_clean.csv, row 662Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1934-01-14Enrollment enrollment:662agency-a-derived/enrollment_clean.csv, row 662Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******RA53Enrollment enrollment:662agency-a-derived/enrollment_clean.csv, row 662Most trusted source (enrollment over CRM)Rules (automatic)
Street774 Little Turnpike Apt. 333CRM crm:C-00754agency-a-snapshot/clients.csv, row 754Most recent recordRules (automatic)
CityRoyfurtCRM crm:C-00754agency-a-snapshot/clients.csv, row 754Most recent recordRules (automatic)
StateIDCRM crm:C-00754agency-a-snapshot/clients.csv, row 754Most recent recordRules (automatic)
ZIP83431CRM crm:C-00754agency-a-snapshot/clients.csv, row 754Most recent recordRules (automatic)
Phone(683) 555-0162CRM crm:C-00754agency-a-snapshot/clients.csv, row 754Most recent recordRules (automatic)
Emailronald.robinson754@example.comCRM crm:C-00754agency-a-snapshot/clients.csv, row 754Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00754Enrollment enrollment:662
First nameRonaldRonald
Last nameRobinsonRobinson
Birth date1934-01-141934-01-14
MBI (last 4 only)*******RA53*******RA53
Street774 Little Turnpike Apt. 333Missing
CityRoyfurtMissing
StateIDMissing
ZIP83431Missing
Phone(683) 555-0162Missing
Emailronald.robinson754@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 754agency-a-derived/enrollment_clean.csv, row 662
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
673Mergedcrm:C-00754 and enrollment:662Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Ronald Robinson

Only this person is in the household.

  • Ronald Robinson (this person)