Golden record

FieldValueTaken fromWhyDeciding tier
First nameMelissaEnrollment enrollment:344agency-a-derived/enrollment_clean.csv, row 344Most trusted source (enrollment over CRM)Rules (automatic)
Last nameKingEnrollment enrollment:344agency-a-derived/enrollment_clean.csv, row 344Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1937-01-19Enrollment enrollment:344agency-a-derived/enrollment_clean.csv, row 344Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******WP13Enrollment enrollment:344agency-a-derived/enrollment_clean.csv, row 344Most trusted source (enrollment over CRM)Rules (automatic)
Street063 Ortiz CovesCRM crm:C-00403agency-a-snapshot/clients.csv, row 403Most recent recordRules (automatic)
CitySouth DeniseCRM crm:C-00403agency-a-snapshot/clients.csv, row 403Most recent recordRules (automatic)
StateINCRM crm:C-00403agency-a-snapshot/clients.csv, row 403Most recent recordRules (automatic)
ZIP47040CRM crm:C-00403agency-a-snapshot/clients.csv, row 403Most recent recordRules (automatic)
Phone(555) 555-0156CRM crm:C-00403agency-a-snapshot/clients.csv, row 403Most recent recordRules (automatic)
Emailmelissa.king403@example.comCRM crm:C-00403agency-a-snapshot/clients.csv, row 403Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00403Enrollment enrollment:344
First nameMelissaMelissa
Last nameKingKing
Birth date1937-01-191937-01-19
MBI (last 4 only)*******WP13*******WP13
Street063 Ortiz CovesMissing
CitySouth DeniseMissing
StateINMissing
ZIP47040Missing
Phone(555) 555-0156Missing
Emailmelissa.king403@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 403agency-a-derived/enrollment_clean.csv, row 344
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
345Mergedcrm:C-00403 and enrollment:344Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Melissa King

Only this person is in the household.

  • Melissa King (this person)