Golden record

FieldValueTaken fromWhyDeciding tier
First nameShelbyEnrollment enrollment:1360agency-a-derived/enrollment_clean.csv, row 1360Most trusted source (enrollment over CRM)Rules (automatic)
Last nameJonesEnrollment enrollment:1360agency-a-derived/enrollment_clean.csv, row 1360Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1943-06-07Enrollment enrollment:1360agency-a-derived/enrollment_clean.csv, row 1360Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******JG50Enrollment enrollment:1360agency-a-derived/enrollment_clean.csv, row 1360Most trusted source (enrollment over CRM)Rules (automatic)
Street08356 Wilkerson CornersCRM crm:C-01478agency-a-snapshot/clients.csv, row 1478Most recent recordRules (automatic)
CitySouth EricmouthCRM crm:C-01478agency-a-snapshot/clients.csv, row 1478Most recent recordRules (automatic)
StateWVCRM crm:C-01478agency-a-snapshot/clients.csv, row 1478Most recent recordRules (automatic)
ZIP25242CRM crm:C-01478agency-a-snapshot/clients.csv, row 1478Most recent recordRules (automatic)
Phone(340) 555-0135CRM crm:C-01478agency-a-snapshot/clients.csv, row 1478Most recent recordRules (automatic)
Emailshelby.jones1478@example.comCRM crm:C-01478agency-a-snapshot/clients.csv, row 1478Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01478Enrollment enrollment:1360
First nameShelbyShelby
Last nameJonesJones
Birth date1943-06-071943-06-07
MBI (last 4 only)*******JG50*******JG50
Street08356 Wilkerson CornersMissing
CitySouth EricmouthMissing
StateWVMissing
ZIP25242Missing
Phone(340) 555-0135Missing
Emailshelby.jones1478@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1478agency-a-derived/enrollment_clean.csv, row 1360
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1381Mergedcrm:C-01478 and enrollment:1360Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Shelby Jones

Only this person is in the household.

  • Shelby Jones (this person)