Golden record

FieldValueTaken fromWhyDeciding tier
First namePatriciaEnrollment enrollment:1102agency-a-derived/enrollment_clean.csv, row 1102Most trusted source (enrollment over CRM)Rules (automatic)
Last nameGreeneEnrollment enrollment:1102agency-a-derived/enrollment_clean.csv, row 1102Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1953-12-13Enrollment enrollment:1102agency-a-derived/enrollment_clean.csv, row 1102Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******AH70Enrollment enrollment:1102agency-a-derived/enrollment_clean.csv, row 1102Most trusted source (enrollment over CRM)Rules (automatic)
Street0995 Stephanie Field Suite 283CRM crm:C-01205agency-a-snapshot/clients.csv, row 1205Most recent recordRules (automatic)
CityCollinbergCRM crm:C-01205agency-a-snapshot/clients.csv, row 1205Most recent recordRules (automatic)
StateGACRM crm:C-01205agency-a-snapshot/clients.csv, row 1205Most recent recordRules (automatic)
ZIP39818CRM crm:C-01205agency-a-snapshot/clients.csv, row 1205Most recent recordRules (automatic)
Phone(570) 555-0158CRM crm:C-01205agency-a-snapshot/clients.csv, row 1205Most recent recordRules (automatic)
Emailpatricia.greene1205@example.comCRM crm:C-01205agency-a-snapshot/clients.csv, row 1205Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01205Enrollment enrollment:1102
First namePatPatricia
Last nameGreeneGreene
Birth date1953-12-131953-12-13
MBI (last 4 only)*******AH70*******AH70
Street0995 Stephanie Field Suite 283Missing
CityCollinbergMissing
StateGAMissing
ZIP39818Missing
Phone(570) 555-0158Missing
Emailpatricia.greene1205@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1205agency-a-derived/enrollment_clean.csv, row 1102
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1121Mergedcrm:C-01205 and enrollment:1102Rules (automatic)0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Audrey Greene.same householdPatricia GreeneAudrey Greene

This person shares a household with Audrey Greene.