Golden record

FieldValueTaken fromWhyDeciding tier
First nameMeganEnrollment enrollment:1181agency-a-derived/enrollment_clean.csv, row 1181Most trusted source (enrollment over CRM)Rules (automatic)
Last nameGrantEnrollment enrollment:1181agency-a-derived/enrollment_clean.csv, row 1181Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1950-05-27Enrollment enrollment:1181agency-a-derived/enrollment_clean.csv, row 1181Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******AF69Enrollment enrollment:1181agency-a-derived/enrollment_clean.csv, row 1181Most trusted source (enrollment over CRM)Rules (automatic)
Street628 Lisa Mission Apt. 143CRM crm:C-01285agency-a-snapshot/clients.csv, row 1285Most recent recordRules (automatic)
CityNorth DeannaCRM crm:C-01285agency-a-snapshot/clients.csv, row 1285Most recent recordRules (automatic)
StateNECRM crm:C-01285agency-a-snapshot/clients.csv, row 1285Most recent recordRules (automatic)
ZIP68535CRM crm:C-01285agency-a-snapshot/clients.csv, row 1285Most recent recordRules (automatic)
Phone(231) 555-0132CRM crm:C-01285agency-a-snapshot/clients.csv, row 1285Most recent recordRules (automatic)
Emailmegan.grant1285@example.comCRM crm:C-01285agency-a-snapshot/clients.csv, row 1285Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01285Enrollment enrollment:1181
First nameMeganMegan
Last nameGrantGrant
Birth date1950-05-271950-05-27
MBI (last 4 only)*******AF69*******AF69
Street628 Lisa Mission Apt. 143Missing
CityNorth DeannaMissing
StateNEMissing
ZIP68535Missing
Phone(231) 555-0132Missing
Emailmegan.grant1285@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1285agency-a-derived/enrollment_clean.csv, row 1181
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1201Mergedcrm:C-01285 and enrollment:1181Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Brian Grant.same householdMegan GrantBrian Grant

This person shares a household with Brian Grant.