Golden record

FieldValueTaken fromWhyDeciding tier
First nameHarryEnrollment enrollment:177agency-a-derived/enrollment_clean.csv, row 177Most trusted source (enrollment over CRM)Rules (automatic)
Last nameBarrettEnrollment enrollment:177agency-a-derived/enrollment_clean.csv, row 177Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1939-02-17Enrollment enrollment:177agency-a-derived/enrollment_clean.csv, row 177Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******WD39Enrollment enrollment:177agency-a-derived/enrollment_clean.csv, row 177Most trusted source (enrollment over CRM)Rules (automatic)
Street180 Jason Ways Suite 401CRM crm:C-00214agency-a-snapshot/clients.csv, row 214Most recent recordRules (automatic)
CityRachelshireCRM crm:C-00214agency-a-snapshot/clients.csv, row 214Most recent recordRules (automatic)
StateORCRM crm:C-00214agency-a-snapshot/clients.csv, row 214Most recent recordRules (automatic)
ZIP97629CRM crm:C-00214agency-a-snapshot/clients.csv, row 214Most recent recordRules (automatic)
Phone(862) 555-0111CRM crm:C-00214agency-a-snapshot/clients.csv, row 214Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00214Enrollment enrollment:177
First nameHarryHarry
Last nameBarrettBarrett
Birth date1939-02-171939-02-17
MBI (last 4 only)*******WD39*******WD39
Street180 Jason Ways Suite 401Missing
CityRachelshireMissing
StateORMissing
ZIP97629Missing
Phone(862) 555-0111Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 214agency-a-derived/enrollment_clean.csv, row 177
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
181Mergedcrm:C-00214 and enrollment:177Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Harry Barrett

Only this person is in the household.

  • Harry Barrett (this person)