Golden record

FieldValueTaken fromWhyDeciding tier
First namePaulEnrollment enrollment:1562agency-a-derived/enrollment_clean.csv, row 1562Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBradfordEnrollment enrollment:1562agency-a-derived/enrollment_clean.csv, row 1562Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1948-09-13Enrollment enrollment:1562agency-a-derived/enrollment_clean.csv, row 1562Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******WA63Enrollment enrollment:1562agency-a-derived/enrollment_clean.csv, row 1562Most trusted source (enrollment over CRM)Rules (automatic)
Street3493 Ashley Key Apt. 496CRM crm:C-01706agency-a-snapshot/clients.csv, row 1706Most recent recordRules (automatic)
CitySouth JamesCRM crm:C-01706agency-a-snapshot/clients.csv, row 1706Most recent recordRules (automatic)
StateORCRM crm:C-01706agency-a-snapshot/clients.csv, row 1706Most recent recordRules (automatic)
ZIP97678CRM crm:C-01706agency-a-snapshot/clients.csv, row 1706Most recent recordRules (automatic)
Phone(708) 555-0118CRM crm:C-01706agency-a-snapshot/clients.csv, row 1706Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01706Enrollment enrollment:1562
First namePaulPaul
Last nameBradfordBradford
Birth date1948-09-131948-09-13
MBI (last 4 only)*******WA63*******WA63
Street3493 Ashley Key Apt. 496Missing
CitySouth JamesMissing
StateORMissing
ZIP97678Missing
Phone(708) 555-0118Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1706agency-a-derived/enrollment_clean.csv, row 1562
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1587Mergedcrm:C-01706 and enrollment:1562Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Paul Bradford

Only this person is in the household.

  • Paul Bradford (this person)