Golden record

FieldValueTaken fromWhyDeciding tier
First nameLisaEnrollment enrollment:642agency-a-derived/enrollment_clean.csv, row 642Most trusted source (enrollment over CRM)Rules (automatic)
Last nameLeeEnrollment enrollment:642agency-a-derived/enrollment_clean.csv, row 642Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1947-10-23Enrollment enrollment:642agency-a-derived/enrollment_clean.csv, row 642Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******QG67Enrollment enrollment:642agency-a-derived/enrollment_clean.csv, row 642Most trusted source (enrollment over CRM)Rules (automatic)
Street75370 Julia TraceCRM crm:C-00724agency-a-snapshot/clients.csv, row 724Most recent recordRules (automatic)
CityErinstadCRM crm:C-00724agency-a-snapshot/clients.csv, row 724Most recent recordRules (automatic)
StateFLCRM crm:C-00724agency-a-snapshot/clients.csv, row 724Most recent recordRules (automatic)
ZIP32571CRM crm:C-00724agency-a-snapshot/clients.csv, row 724Most recent recordRules (automatic)
Phone(409) 555-0127CRM crm:C-00724agency-a-snapshot/clients.csv, row 724Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00724Enrollment enrollment:642
First nameLisaLisa
Last nameLeeLee
Birth date1947-10-231947-10-23
MBI (last 4 only)*******QG67*******QG67
Street75370 Julia TraceMissing
CityErinstadMissing
StateFLMissing
ZIP32571Missing
Phone(409) 555-0127Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 724agency-a-derived/enrollment_clean.csv, row 642
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
653Mergedcrm:C-00724 and enrollment:642Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Lisa Lee

Only this person is in the household.

  • Lisa Lee (this person)