Golden record

FieldValueTaken fromWhyDeciding tier
First nameWendyEnrollment enrollment:1242agency-a-derived/enrollment_clean.csv, row 1242Most trusted source (enrollment over CRM)Rules (automatic)
Last nameRichardsonEnrollment enrollment:1242agency-a-derived/enrollment_clean.csv, row 1242Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1952-09-19Enrollment enrollment:1242agency-a-derived/enrollment_clean.csv, row 1242Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******DR09Enrollment enrollment:1242agency-a-derived/enrollment_clean.csv, row 1242Most trusted source (enrollment over CRM)Rules (automatic)
Street556 Travis Stream Suite 616CRM crm:C-01349agency-a-snapshot/clients.csv, row 1349Most recent recordRules (automatic)
CityMichaelviewCRM crm:C-01349agency-a-snapshot/clients.csv, row 1349Most recent recordRules (automatic)
StateILCRM crm:C-01349agency-a-snapshot/clients.csv, row 1349Most recent recordRules (automatic)
ZIP60074CRM crm:C-01349agency-a-snapshot/clients.csv, row 1349Most recent recordRules (automatic)
Phone(304) 555-0117CRM crm:C-01349agency-a-snapshot/clients.csv, row 1349Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01349Enrollment enrollment:1242
First nameWendyWendy
Last nameRichardsonRichardson
Birth date1952-09-191952-09-19
MBI (last 4 only)*******DR09*******DR09
Street556 Travis Stream Suite 616Missing
CityMichaelviewMissing
StateILMissing
ZIP60074Missing
Phone(304) 555-0117Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1349agency-a-derived/enrollment_clean.csv, row 1242
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1262Mergedcrm:C-01349 and enrollment:1242Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Wendy Richardson

Only this person is in the household.

  • Wendy Richardson (this person)