Golden record

FieldValueTaken fromWhyDeciding tier
First nameStacyEnrollment enrollment:1068agency-a-derived/enrollment_clean.csv, row 1068Most trusted source (enrollment over CRM)Rules (automatic)
Last namePerezEnrollment enrollment:1068agency-a-derived/enrollment_clean.csv, row 1068Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1937-11-25Enrollment enrollment:1068agency-a-derived/enrollment_clean.csv, row 1068Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******CN20Enrollment enrollment:1068agency-a-derived/enrollment_clean.csv, row 1068Most trusted source (enrollment over CRM)Rules (automatic)
Street2362 Myers FieldsCRM crm:C-01170agency-a-snapshot/clients.csv, row 1170Most recent recordRules (automatic)
CityPort MichaelCRM crm:C-01170agency-a-snapshot/clients.csv, row 1170Most recent recordRules (automatic)
StateVACRM crm:C-01170agency-a-snapshot/clients.csv, row 1170Most recent recordRules (automatic)
ZIP23705CRM crm:C-01170agency-a-snapshot/clients.csv, row 1170Most recent recordRules (automatic)
Phone(524) 555-0178CRM crm:C-01170agency-a-snapshot/clients.csv, row 1170Most recent recordRules (automatic)
Emailstacy.perez1170@example.comCRM crm:C-01170agency-a-snapshot/clients.csv, row 1170Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01170Enrollment enrollment:1068
First nameStacyStacy
Last namePerezPerez
Birth date1937-11-251937-11-25
MBI (last 4 only)*******CN20*******CN20
Street2362 Myers FieldsMissing
CityPort MichaelMissing
StateVAMissing
ZIP23705Missing
Phone(524) 555-0178Missing
Emailstacy.perez1170@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1170agency-a-derived/enrollment_clean.csv, row 1068
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1086Mergedcrm:C-01170 and enrollment:1068Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Stacy Perez

Only this person is in the household.

  • Stacy Perez (this person)