Golden record

FieldValueTaken fromWhyDeciding tier
First nameJamesEnrollment enrollment:142agency-a-derived/enrollment_clean.csv, row 142Most trusted source (enrollment over CRM)Rules (automatic)
Last nameHudsonEnrollment enrollment:142agency-a-derived/enrollment_clean.csv, row 142Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1954-07-27Enrollment enrollment:142agency-a-derived/enrollment_clean.csv, row 142Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******EC89Enrollment enrollment:142agency-a-derived/enrollment_clean.csv, row 142Most trusted source (enrollment over CRM)Rules (automatic)
Street9748 Melanie Meadows Apt. 456CRM crm:C-00163agency-a-snapshot/clients.csv, row 163Most recent recordRules (automatic)
CityBrandontonCRM crm:C-00163agency-a-snapshot/clients.csv, row 163Most recent recordRules (automatic)
StateDECRM crm:C-00163agency-a-snapshot/clients.csv, row 163Most recent recordRules (automatic)
ZIP19716CRM crm:C-00163agency-a-snapshot/clients.csv, row 163Most recent recordRules (automatic)
Phone(636) 555-0188CRM crm:C-00163agency-a-snapshot/clients.csv, row 163Most recent recordRules (automatic)
Emailjames.hudson163@example.comCRM crm:C-00163agency-a-snapshot/clients.csv, row 163Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00163Enrollment enrollment:142
First nameJimJames
Last nameHudsonHudson
Birth date1954-07-271954-07-27
MBI (last 4 only)*******EC89*******EC89
Street9748 Melanie Meadows Apt. 456Missing
CityBrandontonMissing
StateDEMissing
ZIP19716Missing
Phone(636) 555-0188Missing
Emailjames.hudson163@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 163agency-a-derived/enrollment_clean.csv, row 142
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
146Mergedcrm:C-00163 and enrollment:142Rules (automatic)0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.James Hudson

Only this person is in the household.

  • James Hudson (this person)