Golden record

FieldValueTaken fromWhyDeciding tier
First nameMarkEnrollment enrollment:440agency-a-derived/enrollment_clean.csv, row 440Most trusted source (enrollment over CRM)Rules (automatic)
Last nameCollinsEnrollment enrollment:440agency-a-derived/enrollment_clean.csv, row 440Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1954-05-24Enrollment enrollment:440agency-a-derived/enrollment_clean.csv, row 440Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******RU91Enrollment enrollment:440agency-a-derived/enrollment_clean.csv, row 440Most trusted source (enrollment over CRM)Rules (automatic)
Street15031 Hunter Union Suite 823CRM crm:C-00507agency-a-snapshot/clients.csv, row 507Most recent recordRules (automatic)
CitySandrahavenCRM crm:C-00507agency-a-snapshot/clients.csv, row 507Most recent recordRules (automatic)
StateILCRM crm:C-00507agency-a-snapshot/clients.csv, row 507Most recent recordRules (automatic)
ZIP60815CRM crm:C-00507agency-a-snapshot/clients.csv, row 507Most recent recordRules (automatic)
Phone(666) 555-0170CRM crm:C-00507agency-a-snapshot/clients.csv, row 507Most recent recordRules (automatic)
Emailmark.collins507@example.comCRM crm:C-00507agency-a-snapshot/clients.csv, row 507Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00507Enrollment enrollment:440
First nameMarkMark
Last nameCollinsCollins
Birth date1954-05-241954-05-24
MBI (last 4 only)*******RU91*******RU91
Street15031 Hunter Union Suite 823Missing
CitySandrahavenMissing
StateILMissing
ZIP60815Missing
Phone(666) 555-0170Missing
Emailmark.collins507@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 507agency-a-derived/enrollment_clean.csv, row 440
Active policyNoNo

Merge log lines for this person

LineActionPairTierScoreRule
444Mergedcrm:C-00507 and enrollment:440Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Mark Collins

Only this person is in the household.

  • Mark Collins (this person)