Golden record

FieldValueTaken fromWhyDeciding tier
First nameErinEnrollment enrollment:506agency-a-derived/enrollment_clean.csv, row 506Most trusted source (enrollment over CRM)Rules (automatic)
Last nameAdamsEnrollment enrollment:506agency-a-derived/enrollment_clean.csv, row 506Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1956-05-04Enrollment enrollment:506agency-a-derived/enrollment_clean.csv, row 506Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******TR20Enrollment enrollment:506agency-a-derived/enrollment_clean.csv, row 506Most trusted source (enrollment over CRM)Rules (automatic)
Street53817 Karen TraceCRM crm:C-00576agency-a-snapshot/clients.csv, row 576Most recent recordRules (automatic)
CityWest MichaelCRM crm:C-00576agency-a-snapshot/clients.csv, row 576Most recent recordRules (automatic)
StateTXCRM crm:C-00576agency-a-snapshot/clients.csv, row 576Most recent recordRules (automatic)
ZIP77367CRM crm:C-00576agency-a-snapshot/clients.csv, row 576Most recent recordRules (automatic)
Phone(275) 555-0194CRM crm:C-00576agency-a-snapshot/clients.csv, row 576Most recent recordRules (automatic)
Emailerin.adams576@example.comCRM crm:C-00576agency-a-snapshot/clients.csv, row 576Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00576Enrollment enrollment:505Enrollment enrollment:506
First nameErinErinErin
Last nameAdamsAdamsAdams
Birth date1956-05-041956-05-041956-05-04
MBI (last 4 only)*******TR20*******TR20*******TR20
Street53817 Karen TraceMissingMissing
CityWest MichaelMissingMissing
StateTXMissingMissing
ZIP77367MissingMissing
Phone(275) 555-0194MissingMissing
Emailerin.adams576@example.comMissingMissing
Sourceagency-a-snapshot/clients.csv, row 576agency-a-derived/enrollment_clean.csv, row 505agency-a-derived/enrollment_clean.csv, row 506
Active policyYesNoYes

Merge log lines for this person

LineActionPairTierScoreRule
511Mergedcrm:C-00576 and enrollment:505Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
512Mergedcrm:C-00576 and enrollment:506Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
2088Mergedenrollment:505 and enrollment:506Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Joshua Adams.same householdErin AdamsJoshua Adams

This person shares a household with Joshua Adams.

  • Erin Adams (this person)
  • Joshua Adams: same household