Golden record

FieldValueTaken fromWhyDeciding tier
First nameRichardEnrollment enrollment:1240agency-a-derived/enrollment_clean.csv, row 1240Most trusted source (enrollment over CRM)Rules (automatic)
Last nameClarkEnrollment enrollment:1240agency-a-derived/enrollment_clean.csv, row 1240Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1950-09-17Enrollment enrollment:1240agency-a-derived/enrollment_clean.csv, row 1240Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******PK42Enrollment enrollment:1240agency-a-derived/enrollment_clean.csv, row 1240Most trusted source (enrollment over CRM)Rules (automatic)
Street0789 Massey Rest Apt. 521CRM crm:C-01347agency-a-snapshot/clients.csv, row 1347Most recent recordRules (automatic)
CityJacksonfurtCRM crm:C-01347agency-a-snapshot/clients.csv, row 1347Most recent recordRules (automatic)
StateNYCRM crm:C-01347agency-a-snapshot/clients.csv, row 1347Most recent recordRules (automatic)
ZIP12467CRM crm:C-01347agency-a-snapshot/clients.csv, row 1347Most recent recordRules (automatic)
Phone(708) 555-0140CRM crm:C-01347agency-a-snapshot/clients.csv, row 1347Most recent recordRules (automatic)
Emailrichard.clark1347@example.comCRM crm:C-01347agency-a-snapshot/clients.csv, row 1347Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01347Enrollment enrollment:1240
First nameRichardRichard
Last nameClarkClark
Birth date1950-09-171950-09-17
MBI (last 4 only)*******PK42*******PK42
Street0789 Massey Rest Apt. 521Missing
CityJacksonfurtMissing
StateNYMissing
ZIP12467Missing
Phone(708) 555-0140Missing
Emailrichard.clark1347@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1347agency-a-derived/enrollment_clean.csv, row 1240
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1260Mergedcrm:C-01347 and enrollment:1240Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Leon Clark.same householdRichard ClarkLeon Clark

This person shares a household with Leon Clark.

  • Leon Clark: same household
  • Richard Clark (this person)