Golden record

FieldValueTaken fromWhyDeciding tier
First nameSaraEnrollment enrollment:948agency-a-derived/enrollment_clean.csv, row 948Most trusted source (enrollment over CRM)Rules (automatic)
Last nameMayerEnrollment enrollment:948agency-a-derived/enrollment_clean.csv, row 948Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1943-10-03Enrollment enrollment:948agency-a-derived/enrollment_clean.csv, row 948Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******YQ10Enrollment enrollment:948agency-a-derived/enrollment_clean.csv, row 948Most trusted source (enrollment over CRM)Rules (automatic)
Street595 Donald Pike Apt. 958CRM crm:C-01051agency-a-snapshot/clients.csv, row 1051Most recent recordRules (automatic)
CityThomasboroughCRM crm:C-01051agency-a-snapshot/clients.csv, row 1051Most recent recordRules (automatic)
StateIDCRM crm:C-01051agency-a-snapshot/clients.csv, row 1051Most recent recordRules (automatic)
ZIP83740CRM crm:C-01051agency-a-snapshot/clients.csv, row 1051Most recent recordRules (automatic)
Phone(786) 555-0143CRM crm:C-01051agency-a-snapshot/clients.csv, row 1051Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01051Enrollment enrollment:948
First nameSaraSara
Last nameMayerMayer
Birth date1943-10-031943-10-03
MBI (last 4 only)*******YQ10*******YQ10
Street595 Donald Pike Apt. 958Missing
CityThomasboroughMissing
StateIDMissing
ZIP83740Missing
Phone(786) 555-0143Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1051agency-a-derived/enrollment_clean.csv, row 948
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
963Mergedcrm:C-01051 and enrollment:948Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Sara Mayer

Only this person is in the household.

  • Sara Mayer (this person)