Golden record

FieldValueTaken fromWhyDeciding tier
First nameAllenEnrollment enrollment:1505agency-a-derived/enrollment_clean.csv, row 1505Most trusted source (enrollment over CRM)Rules (automatic)
Last nameSmallEnrollment enrollment:1505agency-a-derived/enrollment_clean.csv, row 1505Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1938-09-30Enrollment enrollment:1505agency-a-derived/enrollment_clean.csv, row 1505Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******XY33Enrollment enrollment:1505agency-a-derived/enrollment_clean.csv, row 1505Most trusted source (enrollment over CRM)Rules (automatic)
Street983 Dustin CapeCRM crm:C-01643agency-a-snapshot/clients.csv, row 1643Most recent recordRules (automatic)
CityNorth JacobburghCRM crm:C-01643agency-a-snapshot/clients.csv, row 1643Most recent recordRules (automatic)
StateNCCRM crm:C-01643agency-a-snapshot/clients.csv, row 1643Most recent recordRules (automatic)
ZIP28195CRM crm:C-01643agency-a-snapshot/clients.csv, row 1643Most recent recordRules (automatic)
Phone(295) 555-0137CRM crm:C-01643agency-a-snapshot/clients.csv, row 1643Most recent recordRules (automatic)
Emailallen.small1643@example.comCRM crm:C-01643agency-a-snapshot/clients.csv, row 1643Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01643Enrollment enrollment:1505
First nameAllenAllen
Last nameSmallSmall
Birth date1938-09-301938-09-30
MBI (last 4 only)*******XY33*******XY33
Street983 Dustin CapeMissing
CityNorth JacobburghMissing
StateNCMissing
ZIP28195Missing
Phone(295) 555-0137Missing
Emailallen.small1643@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1643agency-a-derived/enrollment_clean.csv, row 1505
Active policyNoNo

Merge log lines for this person

LineActionPairTierScoreRule
1528Mergedcrm:C-01643 and enrollment:1505Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Allen Small

Only this person is in the household.

  • Allen Small (this person)