Golden record

FieldValueTaken fromWhyDeciding tier
First nameScottEnrollment enrollment:1461agency-a-derived/enrollment_clean.csv, row 1461Most trusted source (enrollment over CRM)Rules (automatic)
Last nameHernandezEnrollment enrollment:1461agency-a-derived/enrollment_clean.csv, row 1461Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1949-02-25Enrollment enrollment:1461agency-a-derived/enrollment_clean.csv, row 1461Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******QR67Enrollment enrollment:1461agency-a-derived/enrollment_clean.csv, row 1461Most trusted source (enrollment over CRM)Rules (automatic)
Street40964 Reyes Gateway Suite 960CRM crm:C-01596agency-a-snapshot/clients.csv, row 1596Most recent recordRules (automatic)
CityShawnportCRM crm:C-01596agency-a-snapshot/clients.csv, row 1596Most recent recordRules (automatic)
StateNYCRM crm:C-01596agency-a-snapshot/clients.csv, row 1596Most recent recordRules (automatic)
ZIP13162CRM crm:C-01596agency-a-snapshot/clients.csv, row 1596Most recent recordRules (automatic)
Phone(303) 555-0141CRM crm:C-01596agency-a-snapshot/clients.csv, row 1596Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01596Enrollment enrollment:1461
First nameScottScott
Last nameHernandezHernandez
Birth date1949-02-251949-02-25
MBI (last 4 only)*******QR67*******QR67
Street40964 Reyes Gateway Suite 960Missing
CityShawnportMissing
StateNYMissing
ZIP13162Missing
Phone(303) 555-0141Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1596agency-a-derived/enrollment_clean.csv, row 1461
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1485Mergedcrm:C-01596 and enrollment:1461Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Scott Hernandez

Only this person is in the household.

  • Scott Hernandez (this person)