Golden record

FieldValueTaken fromWhyDeciding tier
First nameDavidEnrollment enrollment:865agency-a-derived/enrollment_clean.csv, row 865Most trusted source (enrollment over CRM)Rules (automatic)
Last nameLinEnrollment enrollment:865agency-a-derived/enrollment_clean.csv, row 865Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1938-08-12Enrollment enrollment:865agency-a-derived/enrollment_clean.csv, row 865Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******RW85Enrollment enrollment:865agency-a-derived/enrollment_clean.csv, row 865Most trusted source (enrollment over CRM)Rules (automatic)
Street60787 Christopher Groves Apt. 591CRM crm:C-00961agency-a-snapshot/clients.csv, row 961Most recent recordRules (automatic)
CityArianamouthCRM crm:C-00961agency-a-snapshot/clients.csv, row 961Most recent recordRules (automatic)
StateARCRM crm:C-00961agency-a-snapshot/clients.csv, row 961Most recent recordRules (automatic)
ZIP72893CRM crm:C-00961agency-a-snapshot/clients.csv, row 961Most recent recordRules (automatic)
Phone(307) 555-0151CRM crm:C-00961agency-a-snapshot/clients.csv, row 961Most recent recordRules (automatic)
Emaildavid.lin961@example.comCRM crm:C-00961agency-a-snapshot/clients.csv, row 961Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00961Enrollment enrollment:865
First nameDavidDavid
Last nameLinLin
Birth date1938-08-121938-08-12
MBI (last 4 only)*******RW85*******RW85
Street60787 Christopher Groves Apt. 591Missing
CityArianamouthMissing
StateARMissing
ZIP72893Missing
Phone(307) 555-0151Missing
Emaildavid.lin961@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 961agency-a-derived/enrollment_clean.csv, row 865
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
881Mergedcrm:C-00961 and enrollment:865Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Brenda Lin.same householdDavid LinBrenda Lin

This person shares a household with Brenda Lin.