Golden record

FieldValueTaken fromWhyDeciding tier
First nameJordanEnrollment enrollment:1808agency-a-derived/enrollment_clean.csv, row 1808Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWatersEnrollment enrollment:1808agency-a-derived/enrollment_clean.csv, row 1808Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1945-02-10Enrollment enrollment:1808agency-a-derived/enrollment_clean.csv, row 1808Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******HT55Enrollment enrollment:1808agency-a-derived/enrollment_clean.csv, row 1808Most trusted source (enrollment over CRM)Rules (automatic)
Street060 Holmes Pike Suite 932CRM crm:C-01960agency-a-snapshot/clients.csv, row 1960Most recent recordRules (automatic)
CityLake MatthewstadCRM crm:C-01960agency-a-snapshot/clients.csv, row 1960Most recent recordRules (automatic)
StateILCRM crm:C-01960agency-a-snapshot/clients.csv, row 1960Most recent recordRules (automatic)
ZIP60530CRM crm:C-01960agency-a-snapshot/clients.csv, row 1960Most recent recordRules (automatic)
Phone(811) 555-0177CRM crm:C-01960agency-a-snapshot/clients.csv, row 1960Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01960Enrollment enrollment:1808
First nameJordanJordan
Last nameWatersWaters
Birth date1945-02-101945-02-10
MBI (last 4 only)*******HT55*******HT55
Street060 Holmes Pike Suite 932Missing
CityLake MatthewstadMissing
StateILMissing
ZIP60530Missing
Phone(811) 555-0177Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1960agency-a-derived/enrollment_clean.csv, row 1808
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1840Mergedcrm:C-01960 and enrollment:1808Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Jordan Waters

Only this person is in the household.

  • Jordan Waters (this person)