Golden record

FieldValueTaken fromWhyDeciding tier
First nameShawnEnrollment enrollment:981agency-a-derived/enrollment_clean.csv, row 981Most trusted source (enrollment over CRM)Rules (automatic)
Last nameCruzEnrollment enrollment:981agency-a-derived/enrollment_clean.csv, row 981Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1942-09-07Enrollment enrollment:981agency-a-derived/enrollment_clean.csv, row 981Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******CA09Enrollment enrollment:981agency-a-derived/enrollment_clean.csv, row 981Most trusted source (enrollment over CRM)Rules (automatic)
Street26817 Michael Street Apt. 602CRM crm:C-01083agency-a-snapshot/clients.csv, row 1083Most recent recordRules (automatic)
CityDavidhavenCRM crm:C-01083agency-a-snapshot/clients.csv, row 1083Most recent recordRules (automatic)
StateVACRM crm:C-01083agency-a-snapshot/clients.csv, row 1083Most recent recordRules (automatic)
ZIP22666CRM crm:C-01083agency-a-snapshot/clients.csv, row 1083Most recent recordRules (automatic)
Phone(432) 555-0134CRM crm:C-01083agency-a-snapshot/clients.csv, row 1083Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01083Enrollment enrollment:981
First nameShawnShawn
Last nameCruzCruz
Birth date1942-09-071942-09-07
MBI (last 4 only)*******CA09*******CA09
Street26817 Michael Street Apt. 602Missing
CityDavidhavenMissing
StateVAMissing
ZIP22666Missing
Phone(432) 555-0134Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1083agency-a-derived/enrollment_clean.csv, row 981
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
996Mergedcrm:C-01083 and enrollment:981Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Shawn Cruz

Only this person is in the household.

  • Shawn Cruz (this person)