Golden record

FieldValueTaken fromWhyDeciding tier
First nameRobertEnrollment enrollment:14agency-a-derived/enrollment_clean.csv, row 14Most trusted source (enrollment over CRM)Rules (automatic)
Last nameHarveyEnrollment enrollment:14agency-a-derived/enrollment_clean.csv, row 14Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1937-09-03Enrollment enrollment:14agency-a-derived/enrollment_clean.csv, row 14Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******NP90Enrollment enrollment:14agency-a-derived/enrollment_clean.csv, row 14Most trusted source (enrollment over CRM)Rules (automatic)
Street820 Melissa Cliff Apt. 361CRM crm:C-00017agency-a-snapshot/clients.csv, row 17Most recent recordRules (automatic)
CityNew BrookeCRM crm:C-00017agency-a-snapshot/clients.csv, row 17Most recent recordRules (automatic)
StateFLCRM crm:C-00017agency-a-snapshot/clients.csv, row 17Most recent recordRules (automatic)
ZIP32331CRM crm:C-00017agency-a-snapshot/clients.csv, row 17Most recent recordRules (automatic)
Phone(425) 555-0173CRM crm:C-00017agency-a-snapshot/clients.csv, row 17Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00017Enrollment enrollment:14
First nameRobertRobert
Last nameHarveyHarvey
Birth date1937-09-031937-09-03
MBI (last 4 only)*******NP90*******NP90
Street820 Melissa Cliff Apt. 361Missing
CityNew BrookeMissing
StateFLMissing
ZIP32331Missing
Phone(425) 555-0173Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 17agency-a-derived/enrollment_clean.csv, row 14
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
15Mergedcrm:C-00017 and enrollment:14Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Robert Harvey

Only this person is in the household.

  • Robert Harvey (this person)