Golden record

FieldValueTaken fromWhyDeciding tier
First nameJeremyEnrollment enrollment:906agency-a-derived/enrollment_clean.csv, row 906Most trusted source (enrollment over CRM)Rules (automatic)
Last nameTranEnrollment enrollment:906agency-a-derived/enrollment_clean.csv, row 906Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1951-07-04Enrollment enrollment:906agency-a-derived/enrollment_clean.csv, row 906Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******AT43Enrollment enrollment:906agency-a-derived/enrollment_clean.csv, row 906Most trusted source (enrollment over CRM)Rules (automatic)
Street22903 Diamond FerryCRM crm:C-01006agency-a-snapshot/clients.csv, row 1006Most recent recordRules (automatic)
CityRileytonCRM crm:C-01006agency-a-snapshot/clients.csv, row 1006Most recent recordRules (automatic)
StateTXCRM crm:C-01006agency-a-snapshot/clients.csv, row 1006Most recent recordRules (automatic)
ZIP79504CRM crm:C-01006agency-a-snapshot/clients.csv, row 1006Most recent recordRules (automatic)
Phone(720) 555-0155CRM crm:C-01006agency-a-snapshot/clients.csv, row 1006Most recent recordRules (automatic)
Emailjeremy.tran1006@example.comCRM crm:C-01006agency-a-snapshot/clients.csv, row 1006Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01006Enrollment enrollment:906
First nameJeremyJeremy
Last nameTranTran
Birth date1951-07-041951-07-04
MBI (last 4 only)*******AT43*******AT43
Street22903 Diamond FerryMissing
CityRileytonMissing
StateTXMissing
ZIP79504Missing
Phone(720) 555-0155Missing
Emailjeremy.tran1006@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1006agency-a-derived/enrollment_clean.csv, row 906
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
922Mergedcrm:C-01006 and enrollment:906Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Stephanie Tran.same householdJeremy TranStephanie Tran

This person shares a household with Stephanie Tran.