Golden record

FieldValueTaken fromWhyDeciding tier
First nameRonaldEnrollment enrollment:516agency-a-derived/enrollment_clean.csv, row 516Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBaldwinEnrollment enrollment:516agency-a-derived/enrollment_clean.csv, row 516Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1936-12-11Enrollment enrollment:516agency-a-derived/enrollment_clean.csv, row 516Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******GK15Enrollment enrollment:516agency-a-derived/enrollment_clean.csv, row 516Most trusted source (enrollment over CRM)Rules (automatic)
Street637 Morrison PassCRM crm:C-00589agency-a-snapshot/clients.csv, row 589Most recent recordRules (automatic)
CityLake MichaelbergCRM crm:C-00589agency-a-snapshot/clients.csv, row 589Most recent recordRules (automatic)
StateRICRM crm:C-00589agency-a-snapshot/clients.csv, row 589Most recent recordRules (automatic)
ZIP02881CRM crm:C-00589agency-a-snapshot/clients.csv, row 589Most recent recordRules (automatic)
Phone(601) 555-0128CRM crm:C-00589agency-a-snapshot/clients.csv, row 589Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00589Enrollment enrollment:516
First nameRonaldRonald
Last nameBaldwinBaldwin
Birth date1936-12-111936-12-11
MBI (last 4 only)*******GK15*******GK15
Street637 Morrison PassMissing
CityLake MichaelbergMissing
StateRIMissing
ZIP02881Missing
Phone(601) 555-0128Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 589agency-a-derived/enrollment_clean.csv, row 516
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
523Mergedcrm:C-00589 and enrollment:516Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Ronald Baldwin

Only this person is in the household.

  • Ronald Baldwin (this person)