Golden record

FieldValueTaken fromWhyDeciding tier
First nameJulieEnrollment enrollment:64agency-a-derived/enrollment_clean.csv, row 64Most trusted source (enrollment over CRM)Rules (automatic)
Last nameLeeEnrollment enrollment:64agency-a-derived/enrollment_clean.csv, row 64Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1946-03-09Enrollment enrollment:64agency-a-derived/enrollment_clean.csv, row 64Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******NE84Enrollment enrollment:64agency-a-derived/enrollment_clean.csv, row 64Most trusted source (enrollment over CRM)Rules (automatic)
Street4846 Baird GardensCRM crm:C-00072agency-a-snapshot/clients.csv, row 72Most recent recordRules (automatic)
CityArnoldfurtCRM crm:C-00072agency-a-snapshot/clients.csv, row 72Most recent recordRules (automatic)
StateARCRM crm:C-00072agency-a-snapshot/clients.csv, row 72Most recent recordRules (automatic)
ZIP71811CRM crm:C-00072agency-a-snapshot/clients.csv, row 72Most recent recordRules (automatic)
Phone(483) 555-0199CRM crm:C-00072agency-a-snapshot/clients.csv, row 72Most recent recordRules (automatic)
Emailjulie.lee72@example.comCRM crm:C-00072agency-a-snapshot/clients.csv, row 72Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00072Enrollment enrollment:64
First nameJulieJulie
Last nameLeeLee
Birth date1946-09-031946-03-09
MBI (last 4 only)*******NE84*******NE84
Street4846 Baird GardensMissing
CityArnoldfurtMissing
StateARMissing
ZIP71811Missing
Phone(483) 555-0199Missing
Emailjulie.lee72@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 72agency-a-derived/enrollment_clean.csv, row 64
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
68Mergedcrm:C-00072 and enrollment:64Rules (automatic)0.9998AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Carol Lee.same householdJulie LeeCarol Lee

This person shares a household with Carol Lee.

  • Carol Lee: same household
  • Julie Lee (this person)