Golden record

FieldValueTaken fromWhyDeciding tier
First nameReneeEnrollment enrollment:1130agency-a-derived/enrollment_clean.csv, row 1130Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBanksEnrollment enrollment:1130agency-a-derived/enrollment_clean.csv, row 1130Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1937-12-20Enrollment enrollment:1130agency-a-derived/enrollment_clean.csv, row 1130Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******UE40Enrollment enrollment:1130agency-a-derived/enrollment_clean.csv, row 1130Most trusted source (enrollment over CRM)Rules (automatic)
Street069 Melody TrackCRM crm:C-01231agency-a-snapshot/clients.csv, row 1231Most recent recordRules (automatic)
CityNew AmytownCRM crm:C-01231agency-a-snapshot/clients.csv, row 1231Most recent recordRules (automatic)
StateWICRM crm:C-01231agency-a-snapshot/clients.csv, row 1231Most recent recordRules (automatic)
ZIP53066CRM crm:C-01231agency-a-snapshot/clients.csv, row 1231Most recent recordRules (automatic)
Phone(460) 555-0132CRM crm:C-01231agency-a-snapshot/clients.csv, row 1231Most recent recordRules (automatic)
Emailrenee.banks1231@example.comCRM crm:C-01231agency-a-snapshot/clients.csv, row 1231Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01231Enrollment enrollment:1130
First nameReneeRenee
Last nameBanksBanks
Birth date1937-12-201937-12-20
MBI (last 4 only)*******UE40*******UE40
Street069 Melody TrackMissing
CityNew AmytownMissing
StateWIMissing
ZIP53066Missing
Phone(460) 555-0132Missing
Emailrenee.banks1231@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1231agency-a-derived/enrollment_clean.csv, row 1130
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1149Mergedcrm:C-01231 and enrollment:1130Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Renee Banks

Only this person is in the household.

  • Renee Banks (this person)