Golden record

FieldValueTaken fromWhyDeciding tier
First nameStacyEnrollment enrollment:219agency-a-derived/enrollment_clean.csv, row 219Most trusted source (enrollment over CRM)Rules (automatic)
Last nameLivingstonEnrollment enrollment:219agency-a-derived/enrollment_clean.csv, row 219Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1944-10-29Enrollment enrollment:219agency-a-derived/enrollment_clean.csv, row 219Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******CF71Enrollment enrollment:219agency-a-derived/enrollment_clean.csv, row 219Most trusted source (enrollment over CRM)Rules (automatic)
Street2696 Payne Extensions Suite 109CRM crm:C-00259agency-a-snapshot/clients.csv, row 259Most recent recordRules (automatic)
CityNorth JosetonCRM crm:C-00259agency-a-snapshot/clients.csv, row 259Most recent recordRules (automatic)
StateMECRM crm:C-00259agency-a-snapshot/clients.csv, row 259Most recent recordRules (automatic)
ZIP04651CRM crm:C-00259agency-a-snapshot/clients.csv, row 259Most recent recordRules (automatic)
Phone(303) 555-0193CRM crm:C-00259agency-a-snapshot/clients.csv, row 259Most recent recordRules (automatic)
Emailstacy.livingston259@example.comCRM crm:C-00259agency-a-snapshot/clients.csv, row 259Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00259Enrollment enrollment:219
First nameStacyStacy
Last nameLivingstonLivingston
Birth date1944-10-291944-10-29
MBI (last 4 only)*******CF71*******CF71
Street2696 Payne Extensions Suite 109Missing
CityNorth JosetonMissing
StateMEMissing
ZIP04651Missing
Phone(303) 555-0193Missing
Emailstacy.livingston259@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 259agency-a-derived/enrollment_clean.csv, row 219
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
223Mergedcrm:C-00259 and enrollment:219Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Stacy Livingston

Only this person is in the household.

  • Stacy Livingston (this person)