Golden record

FieldValueTaken fromWhyDeciding tier
First nameSheilaEnrollment enrollment:681agency-a-derived/enrollment_clean.csv, row 681Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWeaverEnrollment enrollment:681agency-a-derived/enrollment_clean.csv, row 681Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1951-10-01Enrollment enrollment:681agency-a-derived/enrollment_clean.csv, row 681Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******UK52Enrollment enrollment:681agency-a-derived/enrollment_clean.csv, row 681Most trusted source (enrollment over CRM)Rules (automatic)
Street206 Lisa IslandsCRM crm:C-00775agency-a-snapshot/clients.csv, row 775Most recent recordRules (automatic)
CityNew JamieCRM crm:C-00775agency-a-snapshot/clients.csv, row 775Most recent recordRules (automatic)
StateNCCRM crm:C-00775agency-a-snapshot/clients.csv, row 775Most recent recordRules (automatic)
ZIP27483CRM crm:C-00775agency-a-snapshot/clients.csv, row 775Most recent recordRules (automatic)
Phone(428) 555-0165CRM crm:C-00775agency-a-snapshot/clients.csv, row 775Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00775Enrollment enrollment:681
First nameSheilaSheila
Last nameWeaverWeaver
Birth date1951-10-011951-10-01
MBI (last 4 only)*******UK52*******UK52
Street206 Lisa IslandsMissing
CityNew JamieMissing
StateNCMissing
ZIP27483Missing
Phone(428) 555-0165Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 775agency-a-derived/enrollment_clean.csv, row 681
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
692Mergedcrm:C-00775 and enrollment:681Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with David Weaver.same householdSheila WeaverDavid Weaver

This person shares a household with David Weaver.