Golden record

FieldValueTaken fromWhyDeciding tier
First nameVictoriaEnrollment enrollment:1742agency-a-derived/enrollment_clean.csv, row 1742Most trusted source (enrollment over CRM)Rules (automatic)
Last nameGilmoreEnrollment enrollment:1742agency-a-derived/enrollment_clean.csv, row 1742Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1937-04-13Enrollment enrollment:1742agency-a-derived/enrollment_clean.csv, row 1742Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******DE00Enrollment enrollment:1742agency-a-derived/enrollment_clean.csv, row 1742Most trusted source (enrollment over CRM)Rules (automatic)
Street0211 Luis PlainCRM crm:C-01896agency-a-snapshot/clients.csv, row 1896Most recent recordRules (automatic)
CityEast LindasideCRM crm:C-01896agency-a-snapshot/clients.csv, row 1896Most recent recordRules (automatic)
StateLACRM crm:C-01896agency-a-snapshot/clients.csv, row 1896Most recent recordRules (automatic)
ZIP70050CRM crm:C-01896agency-a-snapshot/clients.csv, row 1896Most recent recordRules (automatic)
Phone(733) 555-0132CRM crm:C-01896agency-a-snapshot/clients.csv, row 1896Most recent recordRules (automatic)
Emailvictoria.gilmore1896@example.comCRM crm:C-01896agency-a-snapshot/clients.csv, row 1896Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01896Enrollment enrollment:1742
First nameVictoriaVictoria
Last nameGilmoreGilmore
Birth date1937-04-131937-04-13
MBI (last 4 only)*******DE00*******DE00
Street0211 Luis PlainMissing
CityEast LindasideMissing
StateLAMissing
ZIP70050Missing
Phone(733) 555-0132Missing
Emailvictoria.gilmore1896@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1896agency-a-derived/enrollment_clean.csv, row 1742
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1772Mergedcrm:C-01896 and enrollment:1742Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Victoria Gilmore

Only this person is in the household.

  • Victoria Gilmore (this person)