Golden record

FieldValueTaken fromWhyDeciding tier
First nameWilliamEnrollment enrollment:1841agency-a-derived/enrollment_clean.csv, row 1841Most trusted source (enrollment over CRM)Rules (automatic)
Last nameSmithEnrollment enrollment:1841agency-a-derived/enrollment_clean.csv, row 1841Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1950-07-25Enrollment enrollment:1841agency-a-derived/enrollment_clean.csv, row 1841Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******WX82Enrollment enrollment:1841agency-a-derived/enrollment_clean.csv, row 1841Most trusted source (enrollment over CRM)Rules (automatic)
Street85858 Maria Plains Apt. 567CRM crm:C-01995agency-a-snapshot/clients.csv, row 1995Most recent recordRules (automatic)
CitySouth KristinaCRM crm:C-01995agency-a-snapshot/clients.csv, row 1995Most recent recordRules (automatic)
StateSCCRM crm:C-01995agency-a-snapshot/clients.csv, row 1995Most recent recordRules (automatic)
ZIP36033CRM crm:C-01995agency-a-snapshot/clients.csv, row 1995Most recent recordRules (automatic)
Phone(804) 555-0161CRM crm:C-01995agency-a-snapshot/clients.csv, row 1995Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01995Enrollment enrollment:1841
First nameWilliamWilliam
Last nameSmithSmith
Birth date1950-07-251950-07-25
MBI (last 4 only)*******WX82*******WX82
Street85858 Maria Plains Apt. 567Missing
CitySouth KristinaMissing
StateSCMissing
ZIP36033Missing
Phone(804) 555-0161Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1995agency-a-derived/enrollment_clean.csv, row 1841
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1873Mergedcrm:C-01995 and enrollment:1841Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.William Smith

Only this person is in the household.

  • William Smith (this person)