Golden record

FieldValueTaken fromWhyDeciding tier
First nameGabrielleEnrollment enrollment:746agency-a-derived/enrollment_clean.csv, row 746Most trusted source (enrollment over CRM)Rules (automatic)
Last nameSmithEnrollment enrollment:746agency-a-derived/enrollment_clean.csv, row 746Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1935-06-29Enrollment enrollment:746agency-a-derived/enrollment_clean.csv, row 746Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******AT86Enrollment enrollment:746agency-a-derived/enrollment_clean.csv, row 746Most trusted source (enrollment over CRM)Rules (automatic)
Street6862 Susan TurnpikeCRM crm:C-00847agency-a-snapshot/clients.csv, row 847Most recent recordRules (automatic)
CityEast ErichavenCRM crm:C-00847agency-a-snapshot/clients.csv, row 847Most recent recordRules (automatic)
StateTXCRM crm:C-00847agency-a-snapshot/clients.csv, row 847Most recent recordRules (automatic)
ZIP76126CRM crm:C-00847agency-a-snapshot/clients.csv, row 847Most recent recordRules (automatic)
Phone(518) 555-0135CRM crm:C-00847agency-a-snapshot/clients.csv, row 847Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00847Enrollment enrollment:745Enrollment enrollment:746
First nameGabrielleGabrielleGabrielle
Last nameSmithSmithSmith
Birth date1935-06-291935-06-291935-06-29
MBI (last 4 only)*******AT86*******AT86*******AT86
Street6862 Susan TurnpikeMissingMissing
CityEast ErichavenMissingMissing
StateTXMissingMissing
ZIP76126MissingMissing
Phone(518) 555-0135MissingMissing
EmailMissingMissingMissing
Sourceagency-a-snapshot/clients.csv, row 847agency-a-derived/enrollment_clean.csv, row 745agency-a-derived/enrollment_clean.csv, row 746
Active policyYesNoYes

Merge log lines for this person

LineActionPairTierScoreRule
759Mergedcrm:C-00847 and enrollment:745Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
760Mergedcrm:C-00847 and enrollment:746Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
2122Mergedenrollment:745 and enrollment:746Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Gabrielle Smith

Only this person is in the household.

  • Gabrielle Smith (this person)