Golden record

FieldValueTaken fromWhyDeciding tier
First nameKaylaEnrollment enrollment:857agency-a-derived/enrollment_clean.csv, row 857Most trusted source (enrollment over CRM)Rules (automatic)
Last nameOrtegaEnrollment enrollment:857agency-a-derived/enrollment_clean.csv, row 857Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1941-03-28Enrollment enrollment:857agency-a-derived/enrollment_clean.csv, row 857Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******YH22Enrollment enrollment:857agency-a-derived/enrollment_clean.csv, row 857Most trusted source (enrollment over CRM)Rules (automatic)
Street4065 Brendan DamCRM crm:C-00952agency-a-snapshot/clients.csv, row 952Most recent recordRules (automatic)
CityNatashahavenCRM crm:C-00952agency-a-snapshot/clients.csv, row 952Most recent recordRules (automatic)
StateWACRM crm:C-00952agency-a-snapshot/clients.csv, row 952Most recent recordRules (automatic)
ZIP98930CRM crm:C-00952agency-a-snapshot/clients.csv, row 952Most recent recordRules (automatic)
Phone(400) 555-0136CRM crm:C-00952agency-a-snapshot/clients.csv, row 952Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00952Enrollment enrollment:857
First nameKaylaKayla
Last nameOrtegaOrtega
Birth date1941-03-281941-03-28
MBI (last 4 only)*******YH22*******YH22
Street4065 Brendan DamMissing
CityNatashahavenMissing
StateWAMissing
ZIP98930Missing
Phone(400) 555-0136Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 952agency-a-derived/enrollment_clean.csv, row 857
Active policyNoNo

Merge log lines for this person

LineActionPairTierScoreRule
873Mergedcrm:C-00952 and enrollment:857Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Eric Ortega.same householdKayla OrtegaEric Ortega

This person shares a household with Eric Ortega.