Golden record

FieldValueTaken fromWhyDeciding tier
First nameCarolEnrollment enrollment:1436agency-a-derived/enrollment_clean.csv, row 1436Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBrownEnrollment enrollment:1436agency-a-derived/enrollment_clean.csv, row 1436Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1943-08-15Enrollment enrollment:1436agency-a-derived/enrollment_clean.csv, row 1436Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******CV71Enrollment enrollment:1436agency-a-derived/enrollment_clean.csv, row 1436Most trusted source (enrollment over CRM)Rules (automatic)
Street27061 Mendez NeckCRM crm:C-01568agency-a-snapshot/clients.csv, row 1568Most recent recordRules (automatic)
CityNew TroyCRM crm:C-01568agency-a-snapshot/clients.csv, row 1568Most recent recordRules (automatic)
StateUTCRM crm:C-01568agency-a-snapshot/clients.csv, row 1568Most recent recordRules (automatic)
ZIP84653CRM crm:C-01568agency-a-snapshot/clients.csv, row 1568Most recent recordRules (automatic)
Phone(771) 555-0186CRM crm:C-01568agency-a-snapshot/clients.csv, row 1568Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01568Enrollment enrollment:1436
First nameCarolCarol
Last nameBrownBrown
Birth date1943-08-151943-08-15
MBI (last 4 only)*******CV71*******CV71
Street27061 Mendez NeckMissing
CityNew TroyMissing
StateUTMissing
ZIP84653Missing
Phone(771) 555-0186Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1568agency-a-derived/enrollment_clean.csv, row 1436
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1458Mergedcrm:C-01568 and enrollment:1436Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Carol Brown

Only this person is in the household.

  • Carol Brown (this person)