Golden record

FieldValueTaken fromWhyDeciding tier
First nameJeremyEnrollment enrollment:601agency-a-derived/enrollment_clean.csv, row 601Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWilsonEnrollment enrollment:601agency-a-derived/enrollment_clean.csv, row 601Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1949-02-15Enrollment enrollment:601agency-a-derived/enrollment_clean.csv, row 601Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******XE42Enrollment enrollment:601agency-a-derived/enrollment_clean.csv, row 601Most trusted source (enrollment over CRM)Rules (automatic)
Street3380 Michael Green Suite 228CRM crm:C-00683agency-a-snapshot/clients.csv, row 683Most recent recordRules (automatic)
CityPort BrycechesterCRM crm:C-00683agency-a-snapshot/clients.csv, row 683Most recent recordRules (automatic)
StateUTCRM crm:C-00683agency-a-snapshot/clients.csv, row 683Most recent recordRules (automatic)
ZIP84241CRM crm:C-00683agency-a-snapshot/clients.csv, row 683Most recent recordRules (automatic)
Phone(581) 555-0173CRM crm:C-00683agency-a-snapshot/clients.csv, row 683Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00683Enrollment enrollment:600Enrollment enrollment:601
First nameJeremyJeremyJeremy
Last nameWilsonWilsonWilson
Birth date1949-02-151949-02-151949-02-15
MBI (last 4 only)*******XE42*******XE42*******XE42
Street3380 Michael Green Suite 228MissingMissing
CityPort BrycechesterMissingMissing
StateUTMissingMissing
ZIP84241MissingMissing
Phone(581) 555-0173MissingMissing
EmailMissingMissingMissing
Sourceagency-a-snapshot/clients.csv, row 683agency-a-derived/enrollment_clean.csv, row 600agency-a-derived/enrollment_clean.csv, row 601
Active policyYesNoYes

Merge log lines for this person

LineActionPairTierScoreRule
608Mergedcrm:C-00683 and enrollment:600Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
609Mergedcrm:C-00683 and enrollment:601Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
2104Mergedenrollment:600 and enrollment:601Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Jeremy Wilson

Only this person is in the household.

  • Jeremy Wilson (this person)