Golden record

FieldValueTaken fromWhyDeciding tier
First nameBrianaEnrollment enrollment:1311agency-a-derived/enrollment_clean.csv, row 1311Most trusted source (enrollment over CRM)Rules (automatic)
Last nameJohnsonEnrollment enrollment:1311agency-a-derived/enrollment_clean.csv, row 1311Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1935-05-29Enrollment enrollment:1311agency-a-derived/enrollment_clean.csv, row 1311Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******HT28Enrollment enrollment:1311agency-a-derived/enrollment_clean.csv, row 1311Most trusted source (enrollment over CRM)Rules (automatic)
Street6811 Higgins ForgesCRM crm:C-01431agency-a-snapshot/clients.csv, row 1431Most recent recordRules (automatic)
CityEast NathanCRM crm:C-01431agency-a-snapshot/clients.csv, row 1431Most recent recordRules (automatic)
StateDCCRM crm:C-01431agency-a-snapshot/clients.csv, row 1431Most recent recordRules (automatic)
ZIP20236CRM crm:C-01431agency-a-snapshot/clients.csv, row 1431Most recent recordRules (automatic)
Phone(347) 555-0153CRM crm:C-01431agency-a-snapshot/clients.csv, row 1431Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01431Enrollment enrollment:1311
First nameBrianaBriana
Last nameJohnsonJohnson
Birth date1935-05-291935-05-29
MBI (last 4 only)*******HT28*******HT28
Street6811 Higgins ForgesMissing
CityEast NathanMissing
StateDCMissing
ZIP20236Missing
Phone(347) 555-0153Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1431agency-a-derived/enrollment_clean.csv, row 1311
Active policyNoNo

Merge log lines for this person

LineActionPairTierScoreRule
1331Mergedcrm:C-01431 and enrollment:1311Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Alexander Johnson.same householdBriana JohnsonAlexander Johnson

This person shares a household with Alexander Johnson.