Golden record

FieldValueTaken fromWhyDeciding tier
First nameRebeccaEnrollment enrollment:1705agency-a-derived/enrollment_clean.csv, row 1705Most trusted source (enrollment over CRM)Rules (automatic)
Last nameSmithEnrollment enrollment:1705agency-a-derived/enrollment_clean.csv, row 1705Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1950-08-24Enrollment enrollment:1705agency-a-derived/enrollment_clean.csv, row 1705Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******QD46Enrollment enrollment:1705agency-a-derived/enrollment_clean.csv, row 1705Most trusted source (enrollment over CRM)Rules (automatic)
Street5099 Hannah Creek Apt. 898CRM crm:C-01849agency-a-snapshot/clients.csv, row 1849Most recent recordRules (automatic)
CityTimothyshireCRM crm:C-01849agency-a-snapshot/clients.csv, row 1849Most recent recordRules (automatic)
StateUTCRM crm:C-01849agency-a-snapshot/clients.csv, row 1849Most recent recordRules (automatic)
ZIP84289CRM crm:C-01849agency-a-snapshot/clients.csv, row 1849Most recent recordRules (automatic)
Phone(471) 555-0183CRM crm:C-01849agency-a-snapshot/clients.csv, row 1849Most recent recordRules (automatic)
Emailrebecca.smith1849@example.comCRM crm:C-01849agency-a-snapshot/clients.csv, row 1849Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01849Enrollment enrollment:1705
First nameRebeccaRebecca
Last nameSmithSmith
Birth date1950-08-241950-08-24
MBI (last 4 only)*******QD46*******QD46
Street5099 Hannah Creek Apt. 898Missing
CityTimothyshireMissing
StateUTMissing
ZIP84289Missing
Phone(471) 555-0183Missing
Emailrebecca.smith1849@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1849agency-a-derived/enrollment_clean.csv, row 1705
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1732Mergedcrm:C-01849 and enrollment:1705Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Rebecca Smith

Only this person is in the household.

  • Rebecca Smith (this person)