Golden record

FieldValueTaken fromWhyDeciding tier
First nameStephanieEnrollment enrollment:1081agency-a-derived/enrollment_clean.csv, row 1081Most trusted source (enrollment over CRM)Rules (automatic)
Last nameGarciaEnrollment enrollment:1081agency-a-derived/enrollment_clean.csv, row 1081Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1950-12-19Enrollment enrollment:1081agency-a-derived/enrollment_clean.csv, row 1081Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******RM52Enrollment enrollment:1081agency-a-derived/enrollment_clean.csv, row 1081Most trusted source (enrollment over CRM)Rules (automatic)
Street826 James Course Suite 425CRM crm:C-01185agency-a-snapshot/clients.csv, row 1185Most recent recordRules (automatic)
CityRandyfurtCRM crm:C-01185agency-a-snapshot/clients.csv, row 1185Most recent recordRules (automatic)
StateMDCRM crm:C-01185agency-a-snapshot/clients.csv, row 1185Most recent recordRules (automatic)
ZIP21510CRM crm:C-01185agency-a-snapshot/clients.csv, row 1185Most recent recordRules (automatic)
Phone(430) 555-0105CRM crm:C-01185agency-a-snapshot/clients.csv, row 1185Most recent recordRules (automatic)
Emailstephanie.garcia1185@example.comCRM crm:C-01185agency-a-snapshot/clients.csv, row 1185Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01185Enrollment enrollment:1081
First nameStephanieStephanie
Last nameGarciaGarcia
Birth date1950-12-191950-12-19
MBI (last 4 only)*******RM52*******RM52
Street826 James Course Suite 425Missing
CityRandyfurtMissing
StateMDMissing
ZIP21510Missing
Phone(430) 555-0105Missing
Emailstephanie.garcia1185@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1185agency-a-derived/enrollment_clean.csv, row 1081
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1100Mergedcrm:C-01185 and enrollment:1081Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Stephanie Garcia

Only this person is in the household.

  • Stephanie Garcia (this person)