Golden record

FieldValueTaken fromWhyDeciding tier
First nameAliciaEnrollment enrollment:661agency-a-derived/enrollment_clean.csv, row 661Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWhiteEnrollment enrollment:661agency-a-derived/enrollment_clean.csv, row 661Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1941-09-01Enrollment enrollment:661agency-a-derived/enrollment_clean.csv, row 661Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******DN66Enrollment enrollment:661agency-a-derived/enrollment_clean.csv, row 661Most trusted source (enrollment over CRM)Rules (automatic)
Street179 Gary LoafCRM crm:C-00753agency-a-snapshot/clients.csv, row 753Most recent recordRules (automatic)
CityVictormouthCRM crm:C-00753agency-a-snapshot/clients.csv, row 753Most recent recordRules (automatic)
StateCACRM crm:C-00753agency-a-snapshot/clients.csv, row 753Most recent recordRules (automatic)
ZIP95943CRM crm:C-00753agency-a-snapshot/clients.csv, row 753Most recent recordRules (automatic)
Phone(842) 555-0142CRM crm:C-00753agency-a-snapshot/clients.csv, row 753Most recent recordRules (automatic)
Emailalicia.white753@example.comCRM crm:C-00753agency-a-snapshot/clients.csv, row 753Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00753Enrollment enrollment:661
First nameAliciaAlicia
Last nameWhiteWhite
Birth date1941-09-011941-09-01
MBI (last 4 only)*******DN66*******DN66
Street179 Gary LoafMissing
CityVictormouthMissing
StateCAMissing
ZIP95943Missing
Phone(842) 555-0142Missing
Emailalicia.white753@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 753agency-a-derived/enrollment_clean.csv, row 661
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
672Mergedcrm:C-00753 and enrollment:661Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Jennifer White.same householdAlicia WhiteJennifer White

This person shares a household with Jennifer White.

  • Jennifer White: same household
  • Alicia White (this person)