Golden record

FieldValueTaken fromWhyDeciding tier
First nameJeremyEnrollment enrollment:1229agency-a-derived/enrollment_clean.csv, row 1229Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBaxterEnrollment enrollment:1229agency-a-derived/enrollment_clean.csv, row 1229Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1946-03-26Enrollment enrollment:1229agency-a-derived/enrollment_clean.csv, row 1229Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******WX39Enrollment enrollment:1229agency-a-derived/enrollment_clean.csv, row 1229Most trusted source (enrollment over CRM)Rules (automatic)
Street769 Taylor Course Suite 588CRM crm:C-01334agency-a-snapshot/clients.csv, row 1334Most recent recordRules (automatic)
CityWest CrystalviewCRM crm:C-01334agency-a-snapshot/clients.csv, row 1334Most recent recordRules (automatic)
StateTXCRM crm:C-01334agency-a-snapshot/clients.csv, row 1334Most recent recordRules (automatic)
ZIP77696CRM crm:C-01334agency-a-snapshot/clients.csv, row 1334Most recent recordRules (automatic)
Phone(423) 555-0164CRM crm:C-01334agency-a-snapshot/clients.csv, row 1334Most recent recordRules (automatic)
Emailjeremy.baxter1334@example.comCRM crm:C-01334agency-a-snapshot/clients.csv, row 1334Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01334Enrollment enrollment:1229
First nameJeremyJeremy
Last nameBaxterBaxter
Birth date1946-03-261946-03-26
MBI (last 4 only)*******WX39*******WX39
Street769 Taylor Course Suite 588Missing
CityWest CrystalviewMissing
StateTXMissing
ZIP77696Missing
Phone(423) 555-0164Missing
Emailjeremy.baxter1334@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1334agency-a-derived/enrollment_clean.csv, row 1229
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1249Mergedcrm:C-01334 and enrollment:1229Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Brooke Bater.same householdJeremy BaxterBrooke Bater

This person shares a household with Brooke Bater.

  • Brooke Bater: same household
  • Jeremy Baxter (this person)