Golden record

FieldValueTaken fromWhyDeciding tier
First nameJonEnrollment enrollment:1739agency-a-derived/enrollment_clean.csv, row 1739Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBrockEnrollment enrollment:1739agency-a-derived/enrollment_clean.csv, row 1739Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1950-12-04Enrollment enrollment:1739agency-a-derived/enrollment_clean.csv, row 1739Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******JE88Enrollment enrollment:1739agency-a-derived/enrollment_clean.csv, row 1739Most trusted source (enrollment over CRM)Rules (automatic)
Street21138 Knight Summit Suite 167CRM crm:C-01890agency-a-snapshot/clients.csv, row 1890Most recent recordRules (automatic)
CityEast DavidCRM crm:C-01890agency-a-snapshot/clients.csv, row 1890Most recent recordRules (automatic)
StateNECRM crm:C-01890agency-a-snapshot/clients.csv, row 1890Most recent recordRules (automatic)
ZIP69256CRM crm:C-01890agency-a-snapshot/clients.csv, row 1890Most recent recordRules (automatic)
Phone(861) 555-0128CRM crm:C-01890agency-a-snapshot/clients.csv, row 1890Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01890Enrollment enrollment:1739
First nameJonJon
Last nameBrockBrock
Birth date1950-12-041950-12-04
MBI (last 4 only)*******JE88*******JE88
Street21138 Knight Summit Suite 167Missing
CityEast DavidMissing
StateNEMissing
ZIP69256Missing
Phone(861) 555-0128Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1890agency-a-derived/enrollment_clean.csv, row 1739
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1769Mergedcrm:C-01890 and enrollment:1739Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Jon Brock

Only this person is in the household.

  • Jon Brock (this person)