Golden record

FieldValueTaken fromWhyDeciding tier
First nameMeganEnrollment enrollment:1064agency-a-derived/enrollment_clean.csv, row 1064Most trusted source (enrollment over CRM)Rules (automatic)
Last nameMontgomeryEnrollment enrollment:1064agency-a-derived/enrollment_clean.csv, row 1064Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1938-02-11Enrollment enrollment:1064agency-a-derived/enrollment_clean.csv, row 1064Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******EF48Enrollment enrollment:1064agency-a-derived/enrollment_clean.csv, row 1064Most trusted source (enrollment over CRM)Rules (automatic)
Street583 Nicholas CourtsCRM crm:C-01166agency-a-snapshot/clients.csv, row 1166Most recent recordRules (automatic)
CityLake CynthiaCRM crm:C-01166agency-a-snapshot/clients.csv, row 1166Most recent recordRules (automatic)
StateIACRM crm:C-01166agency-a-snapshot/clients.csv, row 1166Most recent recordRules (automatic)
ZIP51300CRM crm:C-01166agency-a-snapshot/clients.csv, row 1166Most recent recordRules (automatic)
Phone(908) 555-0142CRM crm:C-01166agency-a-snapshot/clients.csv, row 1166Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01166Enrollment enrollment:1064
First nameMeganMegan
Last nameMontgomeryMontgomery
Birth date1938-02-111938-02-11
MBI (last 4 only)*******EF48*******EF48
Street583 Nicholas CourtsMissing
CityLake CynthiaMissing
StateIAMissing
ZIP51300Missing
Phone(908) 555-0142Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1166agency-a-derived/enrollment_clean.csv, row 1064
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1081Mergedcrm:C-01166 and enrollment:1064Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Megan Montgomery

Only this person is in the household.

  • Megan Montgomery (this person)