Golden record

FieldValueTaken fromWhyDeciding tier
First nameDaleEnrollment enrollment:1432agency-a-derived/enrollment_clean.csv, row 1432Most trusted source (enrollment over CRM)Rules (automatic)
Last nameFrankEnrollment enrollment:1432agency-a-derived/enrollment_clean.csv, row 1432Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1934-03-09Enrollment enrollment:1432agency-a-derived/enrollment_clean.csv, row 1432Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******VH20Enrollment enrollment:1432agency-a-derived/enrollment_clean.csv, row 1432Most trusted source (enrollment over CRM)Rules (automatic)
Street39304 Ryan Junction Apt. 802CRM crm:C-01563agency-a-snapshot/clients.csv, row 1563Most recent recordRules (automatic)
CityCurtisportCRM crm:C-01563agency-a-snapshot/clients.csv, row 1563Most recent recordRules (automatic)
StateNCCRM crm:C-01563agency-a-snapshot/clients.csv, row 1563Most recent recordRules (automatic)
ZIP28362CRM crm:C-01563agency-a-snapshot/clients.csv, row 1563Most recent recordRules (automatic)
Phone(555) 555-0181CRM crm:C-01563agency-a-snapshot/clients.csv, row 1563Most recent recordRules (automatic)
Emaildale.frank1563@example.comCRM crm:C-01563agency-a-snapshot/clients.csv, row 1563Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01563Enrollment enrollment:1432
First nameDaleDale
Last nameFrankFrank
Birth date1934-03-091934-03-09
MBI (last 4 only)*******VH20*******VH20
Street39304 Ryan Junction Apt. 802Missing
CityCurtisportMissing
StateNCMissing
ZIP28362Missing
Phone(555) 555-0181Missing
Emaildale.frank1563@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1563agency-a-derived/enrollment_clean.csv, row 1432
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1454Mergedcrm:C-01563 and enrollment:1432Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Dale Frank

Only this person is in the household.

  • Dale Frank (this person)