Golden record

FieldValueTaken fromWhyDeciding tier
First nameMatthewEnrollment enrollment:1371agency-a-derived/enrollment_clean.csv, row 1371Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBishopEnrollment enrollment:1371agency-a-derived/enrollment_clean.csv, row 1371Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1951-08-11Enrollment enrollment:1371agency-a-derived/enrollment_clean.csv, row 1371Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******HT63Enrollment enrollment:1371agency-a-derived/enrollment_clean.csv, row 1371Most trusted source (enrollment over CRM)Rules (automatic)
Street804 Phyllis LodgeCRM crm:C-01489agency-a-snapshot/clients.csv, row 1489Most recent recordRules (automatic)
CityEast RachelshireCRM crm:C-01489agency-a-snapshot/clients.csv, row 1489Most recent recordRules (automatic)
StateKYCRM crm:C-01489agency-a-snapshot/clients.csv, row 1489Most recent recordRules (automatic)
ZIP40279CRM crm:C-01489agency-a-snapshot/clients.csv, row 1489Most recent recordRules (automatic)
Phone(557) 555-0186CRM crm:C-01489agency-a-snapshot/clients.csv, row 1489Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01489Enrollment enrollment:1371
First nameMatthewMatthew
Last nameBishopBishop
Birth date1951-08-111951-08-11
MBI (last 4 only)*******HT63*******HT63
Street804 Phyllis LodgeMissing
CityEast RachelshireMissing
StateKYMissing
ZIP40279Missing
Phone(557) 555-0186Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1489agency-a-derived/enrollment_clean.csv, row 1371
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1393Mergedcrm:C-01489 and enrollment:1371Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Matthew Bishop

Only this person is in the household.

  • Matthew Bishop (this person)