Golden record

FieldValueTaken fromWhyDeciding tier
First nameJuliaEnrollment enrollment:390agency-a-derived/enrollment_clean.csv, row 390Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWardEnrollment enrollment:390agency-a-derived/enrollment_clean.csv, row 390Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1945-10-05Enrollment enrollment:390agency-a-derived/enrollment_clean.csv, row 390Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******MM15Enrollment enrollment:390agency-a-derived/enrollment_clean.csv, row 390Most trusted source (enrollment over CRM)Rules (automatic)
Street3910 Diana VillageCRM crm:C-00450agency-a-snapshot/clients.csv, row 450Most recent recordRules (automatic)
CitySouth LaurietonCRM crm:C-00450agency-a-snapshot/clients.csv, row 450Most recent recordRules (automatic)
StateNYCRM crm:C-00450agency-a-snapshot/clients.csv, row 450Most recent recordRules (automatic)
ZIP12112CRM crm:C-00450agency-a-snapshot/clients.csv, row 450Most recent recordRules (automatic)
Phone(382) 555-0164CRM crm:C-00450agency-a-snapshot/clients.csv, row 450Most recent recordRules (automatic)
Emailjulia.ward450@example.comCRM crm:C-00450agency-a-snapshot/clients.csv, row 450Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00450Enrollment enrollment:390
First nameJuliaJulia
Last nameWardWard
Birth date1945-10-051945-10-05
MBI (last 4 only)*******MM15*******MM15
Street3910 Diana VillageMissing
CitySouth LaurietonMissing
StateNYMissing
ZIP12112Missing
Phone(382) 555-0164Missing
Emailjulia.ward450@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 450agency-a-derived/enrollment_clean.csv, row 390
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
392Mergedcrm:C-00450 and enrollment:390Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Julia Ward

Only this person is in the household.

  • Julia Ward (this person)