Golden record

FieldValueTaken fromWhyDeciding tier
First nameEricEnrollment enrollment:1454agency-a-derived/enrollment_clean.csv, row 1454Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBrownEnrollment enrollment:1454agency-a-derived/enrollment_clean.csv, row 1454Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1939-08-02Enrollment enrollment:1454agency-a-derived/enrollment_clean.csv, row 1454Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******GN67Enrollment enrollment:1454agency-a-derived/enrollment_clean.csv, row 1454Most trusted source (enrollment over CRM)Rules (automatic)
Street2037 Zachary ViaductCRM crm:C-01586agency-a-snapshot/clients.csv, row 1586Most recent recordRules (automatic)
CityNorth ChristopherCRM crm:C-01586agency-a-snapshot/clients.csv, row 1586Most recent recordRules (automatic)
StateDECRM crm:C-01586agency-a-snapshot/clients.csv, row 1586Most recent recordRules (automatic)
ZIP19864CRM crm:C-01586agency-a-snapshot/clients.csv, row 1586Most recent recordRules (automatic)
Phone(407) 555-0111CRM crm:C-01586agency-a-snapshot/clients.csv, row 1586Most recent recordRules (automatic)
Emaileric.brown1586@example.comCRM crm:C-01586agency-a-snapshot/clients.csv, row 1586Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01586Enrollment enrollment:1454
First nameEricEric
Last nameBrownBrown
Birth date1939-08-021939-08-02
MBI (last 4 only)*******GN67*******GN67
Street2037 Zachary ViaductMissing
CityNorth ChristopherMissing
StateDEMissing
ZIP19864Missing
Phone(407) 555-0111Missing
Emaileric.brown1586@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1586agency-a-derived/enrollment_clean.csv, row 1454
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1478Mergedcrm:C-01586 and enrollment:1454Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Eric Brown

Only this person is in the household.

  • Eric Brown (this person)