Golden record

FieldValueTaken fromWhyDeciding tier
First nameScottEnrollment enrollment:35agency-a-derived/enrollment_clean.csv, row 35Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWashingtonEnrollment enrollment:35agency-a-derived/enrollment_clean.csv, row 35Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1956-06-15Enrollment enrollment:35agency-a-derived/enrollment_clean.csv, row 35Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******YC10Enrollment enrollment:35agency-a-derived/enrollment_clean.csv, row 35Most trusted source (enrollment over CRM)Rules (automatic)
Street868 Merritt Summit Suite 743CRM crm:C-00036agency-a-snapshot/clients.csv, row 36Most recent recordRules (automatic)
CityKatiehavenCRM crm:C-00036agency-a-snapshot/clients.csv, row 36Most recent recordRules (automatic)
StateAKCRM crm:C-00036agency-a-snapshot/clients.csv, row 36Most recent recordRules (automatic)
ZIP99580CRM crm:C-00036agency-a-snapshot/clients.csv, row 36Most recent recordRules (automatic)
Phone(804) 555-0164CRM crm:C-00036agency-a-snapshot/clients.csv, row 36Most recent recordRules (automatic)
Emailscott.washington36@example.comCRM crm:C-00036agency-a-snapshot/clients.csv, row 36Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00036Enrollment enrollment:35
First nameScottScott
Last nameWashingtonWashington
Birth date1956-06-151956-06-15
MBI (last 4 only)*******YC10*******YC10
Street868 Merritt Summit Suite 743Missing
CityKatiehavenMissing
StateAKMissing
ZIP99580Missing
Phone(804) 555-0164Missing
Emailscott.washington36@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 36agency-a-derived/enrollment_clean.csv, row 35
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
38Mergedcrm:C-00036 and enrollment:35Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with John Washington.same householdScott WashingtonJohn Washington

This person shares a household with John Washington.