Golden record

FieldValueTaken fromWhyDeciding tier
First namePatriciaEnrollment enrollment:1677agency-a-derived/enrollment_clean.csv, row 1677Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWatkinsEnrollment enrollment:1677agency-a-derived/enrollment_clean.csv, row 1677Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1985-10-11Enrollment enrollment:1677agency-a-derived/enrollment_clean.csv, row 1677Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******WJ38Enrollment enrollment:1677agency-a-derived/enrollment_clean.csv, row 1677Most trusted source (enrollment over CRM)Rules (automatic)
Street5686 Cheryl Knoll Apt. 257CRM crm:C-01815agency-a-snapshot/clients.csv, row 1815Most recent recordRules (automatic)
CityWest ChristinaCRM crm:C-01815agency-a-snapshot/clients.csv, row 1815Most recent recordRules (automatic)
StateMECRM crm:C-01815agency-a-snapshot/clients.csv, row 1815Most recent recordRules (automatic)
ZIP04289CRM crm:C-01815agency-a-snapshot/clients.csv, row 1815Most recent recordRules (automatic)
Phone(909) 555-0124CRM crm:C-01815agency-a-snapshot/clients.csv, row 1815Most recent recordRules (automatic)
Emailpatricia.watkins1815@example.comCRM crm:C-01815agency-a-snapshot/clients.csv, row 1815Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01815Enrollment enrollment:1677
First namePatriciaPatricia
Last nameWatkinsWatkins
Birth date1985-10-111985-10-11
MBI (last 4 only)*******WJ38*******WJ38
Street5686 Cheryl Knoll Apt. 257Missing
CityWest ChristinaMissing
StateMEMissing
ZIP04289Missing
Phone(909) 555-0124Missing
Emailpatricia.watkins1815@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1815agency-a-derived/enrollment_clean.csv, row 1677
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1704Mergedcrm:C-01815 and enrollment:1677Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Patricia Watkins

Only this person is in the household.

  • Patricia Watkins (this person)