Golden record

FieldValueTaken fromWhyDeciding tier
First nameChristineEnrollment enrollment:1470agency-a-derived/enrollment_clean.csv, row 1470Most trusted source (enrollment over CRM)Rules (automatic)
Last nameFosterEnrollment enrollment:1470agency-a-derived/enrollment_clean.csv, row 1470Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1933-10-03Enrollment enrollment:1470agency-a-derived/enrollment_clean.csv, row 1470Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******MA09Enrollment enrollment:1470agency-a-derived/enrollment_clean.csv, row 1470Most trusted source (enrollment over CRM)Rules (automatic)
Street9266 Gardner RidgesCRM crm:C-01607agency-a-snapshot/clients.csv, row 1607Most recent recordRules (automatic)
CityLake TheresaCRM crm:C-01607agency-a-snapshot/clients.csv, row 1607Most recent recordRules (automatic)
StateMOCRM crm:C-01607agency-a-snapshot/clients.csv, row 1607Most recent recordRules (automatic)
ZIP65487CRM crm:C-01607agency-a-snapshot/clients.csv, row 1607Most recent recordRules (automatic)
Phone(486) 555-0198CRM crm:C-01607agency-a-snapshot/clients.csv, row 1607Most recent recordRules (automatic)
Emailchristine.foster1607@example.comCRM crm:C-01607agency-a-snapshot/clients.csv, row 1607Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01607Enrollment enrollment:1470Enrollment enrollment:1471
First nameChristineChristineChristine
Last nameFosterFosterFoster
Birth date1933-10-031933-10-031933-10-03
MBI (last 4 only)*******MA09*******MA09*******MA09
Street9266 Gardner RidgesMissingMissing
CityLake TheresaMissingMissing
StateMOMissingMissing
ZIP65487MissingMissing
Phone(486) 555-0198MissingMissing
Emailchristine.foster1607@example.comMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1607agency-a-derived/enrollment_clean.csv, row 1470agency-a-derived/enrollment_clean.csv, row 1471
Active policyYesYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1493Mergedcrm:C-01607 and enrollment:1470Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1494Mergedcrm:C-01607 and enrollment:1471Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1981Mergedenrollment:1470 and enrollment:1471Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Scott Foster.same householdChristine FosterScott Foster

This person shares a household with Scott Foster.

  • Christine Foster (this person)
  • Scott Foster: same household