Golden record

FieldValueTaken fromWhyDeciding tier
First nameBrandonEnrollment enrollment:1687agency-a-derived/enrollment_clean.csv, row 1687Most trusted source (enrollment over CRM)Rules (automatic)
Last nameSmithEnrollment enrollment:1687agency-a-derived/enrollment_clean.csv, row 1687Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1959-11-13Enrollment enrollment:1687agency-a-derived/enrollment_clean.csv, row 1687Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******UH71Enrollment enrollment:1687agency-a-derived/enrollment_clean.csv, row 1687Most trusted source (enrollment over CRM)Rules (automatic)
Street563 Edward MissionCRM crm:C-01825agency-a-snapshot/clients.csv, row 1825Most recent recordRules (automatic)
CityRosetonCRM crm:C-01825agency-a-snapshot/clients.csv, row 1825Most recent recordRules (automatic)
StateCOCRM crm:C-01825agency-a-snapshot/clients.csv, row 1825Most recent recordRules (automatic)
ZIP80150CRM crm:C-01825agency-a-snapshot/clients.csv, row 1825Most recent recordRules (automatic)
Phone(308) 555-0182CRM crm:C-01825agency-a-snapshot/clients.csv, row 1825Most recent recordRules (automatic)
Emailbrandon.smith1825@example.comCRM crm:C-01825agency-a-snapshot/clients.csv, row 1825Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01825Enrollment enrollment:1687
First nameBrandonBrandon
Last nameSmithSmith
Birth date1959-11-131959-11-13
MBI (last 4 only)*******UH71*******UH71
Street563 Edward MissionMissing
CityRosetonMissing
StateCOMissing
ZIP80150Missing
Phone(308) 555-0182Missing
Emailbrandon.smith1825@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1825agency-a-derived/enrollment_clean.csv, row 1687
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1714Mergedcrm:C-01825 and enrollment:1687Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Michael Smith.same householdBrandon SmithMichael Smith

This person shares a household with Michael Smith.

  • Brandon Smith (this person)
  • Michael Smith: same household