Golden record

FieldValueTaken fromWhyDeciding tier
First nameRobertEnrollment enrollment:1606agency-a-derived/enrollment_clean.csv, row 1606Most trusted source (enrollment over CRM)Rules (automatic)
Last nameSmithEnrollment enrollment:1606agency-a-derived/enrollment_clean.csv, row 1606Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1953-03-14Enrollment enrollment:1606agency-a-derived/enrollment_clean.csv, row 1606Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******ET62Enrollment enrollment:1606agency-a-derived/enrollment_clean.csv, row 1606Most trusted source (enrollment over CRM)Rules (automatic)
Street7644 Marsh HavenCRM crm:C-01750agency-a-snapshot/clients.csv, row 1750Most recent recordRules (automatic)
CitySmithtonCRM crm:C-01750agency-a-snapshot/clients.csv, row 1750Most recent recordRules (automatic)
StateVACRM crm:C-01750agency-a-snapshot/clients.csv, row 1750Most recent recordRules (automatic)
ZIP23035CRM crm:C-01750agency-a-snapshot/clients.csv, row 1750Most recent recordRules (automatic)
Phone(781) 555-0162CRM crm:C-01750agency-a-snapshot/clients.csv, row 1750Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01750Enrollment enrollment:1606
First nameRobertRobert
Last nameSmithSmith
Birth date1953-03-141953-03-14
MBI (last 4 only)*******ET62*******ET62
Street7644 Marsh HavenMissing
CitySmithtonMissing
StateVAMissing
ZIP23035Missing
Phone(781) 555-0162Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1750agency-a-derived/enrollment_clean.csv, row 1606
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1633Mergedcrm:C-01750 and enrollment:1606Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Robert Smith

Only this person is in the household.

  • Robert Smith (this person)