Golden record

FieldValueTaken fromWhyDeciding tier
First nameBarbaraEnrollment enrollment:399agency-a-derived/enrollment_clean.csv, row 399Most trusted source (enrollment over CRM)Rules (automatic)
Last nameCrossEnrollment enrollment:399agency-a-derived/enrollment_clean.csv, row 399Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1952-04-08Enrollment enrollment:399agency-a-derived/enrollment_clean.csv, row 399Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******GQ42Enrollment enrollment:399agency-a-derived/enrollment_clean.csv, row 399Most trusted source (enrollment over CRM)Rules (automatic)
Street157 Tracy SpursCRM crm:C-00461agency-a-snapshot/clients.csv, row 461Most recent recordRules (automatic)
CityNew DawntonCRM crm:C-00461agency-a-snapshot/clients.csv, row 461Most recent recordRules (automatic)
StatePACRM crm:C-00461agency-a-snapshot/clients.csv, row 461Most recent recordRules (automatic)
ZIP18949CRM crm:C-00461agency-a-snapshot/clients.csv, row 461Most recent recordRules (automatic)
Phone(852) 555-0158CRM crm:C-00461agency-a-snapshot/clients.csv, row 461Most recent recordRules (automatic)
Emailbarbara.cross461@example.comCRM crm:C-00461agency-a-snapshot/clients.csv, row 461Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00461Enrollment enrollment:399
First nameBarbaraBarbara
Last nameCrossCross
Birth date1952-04-081952-04-08
MBI (last 4 only)*******GQ42*******GQ42
Street157 Tracy SpursMissing
CityNew DawntonMissing
StatePAMissing
ZIP18949Missing
Phone(852) 555-0158Missing
Emailbarbara.cross461@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 461agency-a-derived/enrollment_clean.csv, row 399
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
402Mergedcrm:C-00461 and enrollment:399Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Christian Cross.same householdBarbara CrossChristian Cross

This person shares a household with Christian Cross.

  • Barbara Cross (this person)
  • Christian Cross: same household