Golden record

FieldValueTaken fromWhyDeciding tier
First nameSeanEnrollment enrollment:515agency-a-derived/enrollment_clean.csv, row 515Most trusted source (enrollment over CRM)Rules (automatic)
Last nameRyanEnrollment enrollment:515agency-a-derived/enrollment_clean.csv, row 515Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1960-03-11Enrollment enrollment:515agency-a-derived/enrollment_clean.csv, row 515Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******QQ95Enrollment enrollment:515agency-a-derived/enrollment_clean.csv, row 515Most trusted source (enrollment over CRM)Rules (automatic)
Street398 Kimberly TrafficwayCRM crm:C-00587agency-a-snapshot/clients.csv, row 587Most recent recordRules (automatic)
CityJameslandCRM crm:C-00587agency-a-snapshot/clients.csv, row 587Most recent recordRules (automatic)
StateMOCRM crm:C-00587agency-a-snapshot/clients.csv, row 587Most recent recordRules (automatic)
ZIP64895CRM crm:C-00587agency-a-snapshot/clients.csv, row 587Most recent recordRules (automatic)
Phone(899) 555-0180CRM crm:C-00587agency-a-snapshot/clients.csv, row 587Most recent recordRules (automatic)
Emailsean.ryan587@example.comCRM crm:C-00587agency-a-snapshot/clients.csv, row 587Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00587Enrollment enrollment:515
First nameSeanSean
Last nameRanRyan
Birth date1960-03-111960-03-11
MBI (last 4 only)*******QQ95*******QQ95
Street398 Kimberly TrafficwayMissing
CityJameslandMissing
StateMOMissing
ZIP64895Missing
Phone(899) 555-0180Missing
Emailsean.ryan587@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 587agency-a-derived/enrollment_clean.csv, row 515
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
522Mergedcrm:C-00587 and enrollment:515Rules (automatic)0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Emily Ryan.same householdSean RyanEmily Ryan

This person shares a household with Emily Ryan.

  • Sean Ryan (this person)
  • Emily Ryan: same household