Golden record

FieldValueTaken fromWhyDeciding tier
First nameJessicaEnrollment enrollment:170agency-a-derived/enrollment_clean.csv, row 170Most trusted source (enrollment over CRM)Rules (automatic)
Last nameMurrayEnrollment enrollment:170agency-a-derived/enrollment_clean.csv, row 170Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1944-02-29Enrollment enrollment:170agency-a-derived/enrollment_clean.csv, row 170Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******FA81Enrollment enrollment:170agency-a-derived/enrollment_clean.csv, row 170Most trusted source (enrollment over CRM)Rules (automatic)
Street2353 Hudson Gardens Suite 854CRM crm:C-00206agency-a-snapshot/clients.csv, row 206Most recent recordRules (automatic)
CityLevyfortCRM crm:C-00206agency-a-snapshot/clients.csv, row 206Most recent recordRules (automatic)
StateCTCRM crm:C-00206agency-a-snapshot/clients.csv, row 206Most recent recordRules (automatic)
ZIP06646CRM crm:C-00206agency-a-snapshot/clients.csv, row 206Most recent recordRules (automatic)
Phone(342) 555-0154CRM crm:C-00206agency-a-snapshot/clients.csv, row 206Most recent recordRules (automatic)
Emailjessica.murray206@example.comCRM crm:C-00206agency-a-snapshot/clients.csv, row 206Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00206Enrollment enrollment:170
First nameJessicaJessica
Last nameMurrayMurray
Birth date1944-02-291944-02-29
MBI (last 4 only)*******FA81*******FA81
Street2353 Hudson Gardens Suite 854Missing
CityLevyfortMissing
StateCTMissing
ZIP06646Missing
Phone(342) 555-0154Missing
Emailjessica.murray206@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 206agency-a-derived/enrollment_clean.csv, row 170
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
174Mergedcrm:C-00206 and enrollment:170Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Jessica Murray

Only this person is in the household.

  • Jessica Murray (this person)