Golden record

FieldValueTaken fromWhyDeciding tier
First nameStevenEnrollment enrollment:1000agency-a-derived/enrollment_clean.csv, row 1000Most trusted source (enrollment over CRM)Rules (automatic)
Last nameSimpsonEnrollment enrollment:1000agency-a-derived/enrollment_clean.csv, row 1000Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1955-07-19Enrollment enrollment:1000agency-a-derived/enrollment_clean.csv, row 1000Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******CF34Enrollment enrollment:1000agency-a-derived/enrollment_clean.csv, row 1000Most trusted source (enrollment over CRM)Rules (automatic)
Street653 Lester Harbors Suite 515CRM crm:C-01102agency-a-snapshot/clients.csv, row 1102Most recent recordRules (automatic)
CityPerezfurtCRM crm:C-01102agency-a-snapshot/clients.csv, row 1102Most recent recordRules (automatic)
StatePACRM crm:C-01102agency-a-snapshot/clients.csv, row 1102Most recent recordRules (automatic)
ZIP19424CRM crm:C-01102agency-a-snapshot/clients.csv, row 1102Most recent recordRules (automatic)
Phone(568) 555-0112CRM crm:C-01102agency-a-snapshot/clients.csv, row 1102Most recent recordRules (automatic)
Emailsteven.simpson1102@example.comCRM crm:C-01102agency-a-snapshot/clients.csv, row 1102Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01102Enrollment enrollment:1000
First nameStevenSteven
Last nameSimpsonSimpson
Birth date1955-07-191955-07-19
MBI (last 4 only)*******CF34*******CF34
Street653 Lester Harbors Suite 515Missing
CityPerezfurtMissing
StatePAMissing
ZIP19424Missing
Phone(568) 555-0112Missing
Emailsteven.simpson1102@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1102agency-a-derived/enrollment_clean.csv, row 1000
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1015Mergedcrm:C-01102 and enrollment:1000Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Margaret Simpson.same householdSteven SimpsonMargaret Simpson

This person shares a household with Margaret Simpson.

  • Steven Simpson (this person)
  • Margaret Simpson: same household