Golden record

FieldValueTaken fromWhyDeciding tier
First nameAprilEnrollment enrollment:1106agency-a-derived/enrollment_clean.csv, row 1106Most trusted source (enrollment over CRM)Rules (automatic)
Last nameGarciaEnrollment enrollment:1106agency-a-derived/enrollment_clean.csv, row 1106Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1956-05-15Enrollment enrollment:1106agency-a-derived/enrollment_clean.csv, row 1106Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******XX00Enrollment enrollment:1106agency-a-derived/enrollment_clean.csv, row 1106Most trusted source (enrollment over CRM)Rules (automatic)
Street2373 Williams CircleCRM crm:C-01209agency-a-snapshot/clients.csv, row 1209Most recent recordRules (automatic)
CityCochranshireCRM crm:C-01209agency-a-snapshot/clients.csv, row 1209Most recent recordRules (automatic)
StateNECRM crm:C-01209agency-a-snapshot/clients.csv, row 1209Most recent recordRules (automatic)
ZIP68442CRM crm:C-01209agency-a-snapshot/clients.csv, row 1209Most recent recordRules (automatic)
Phone(289) 555-0155CRM crm:C-01209agency-a-snapshot/clients.csv, row 1209Most recent recordRules (automatic)
Emailapril.garcia1209@example.comCRM crm:C-01209agency-a-snapshot/clients.csv, row 1209Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01209Enrollment enrollment:1106
First nameAprilApril
Last nameGarciaGarcia
Birth date1956-05-151956-05-15
MBI (last 4 only)*******XX00*******XX00
Street2373 Williams CircleMissing
CityCochranshireMissing
StateNEMissing
ZIP68442Missing
Phone(289) 555-0155Missing
Emailapril.garcia1209@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1209agency-a-derived/enrollment_clean.csv, row 1106
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1125Mergedcrm:C-01209 and enrollment:1106Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Elizabeth Garcia.same householdApril GarciaElizabeth Garcia

This person shares a household with Elizabeth Garcia.