Golden record

FieldValueTaken fromWhyDeciding tier
First nameTimothyEnrollment enrollment:1258agency-a-derived/enrollment_clean.csv, row 1258Most trusted source (enrollment over CRM)Rules (automatic)
Last nameMillerEnrollment enrollment:1258agency-a-derived/enrollment_clean.csv, row 1258Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1958-01-23Enrollment enrollment:1258agency-a-derived/enrollment_clean.csv, row 1258Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******VU27Enrollment enrollment:1258agency-a-derived/enrollment_clean.csv, row 1258Most trusted source (enrollment over CRM)Rules (automatic)
Street37218 Gutierrez LocksCRM crm:C-01374agency-a-snapshot/clients.csv, row 1374Most recent recordRules (automatic)
CityKnightportCRM crm:C-01374agency-a-snapshot/clients.csv, row 1374Most recent recordRules (automatic)
StateKYCRM crm:C-01374agency-a-snapshot/clients.csv, row 1374Most recent recordRules (automatic)
ZIP40947CRM crm:C-01374agency-a-snapshot/clients.csv, row 1374Most recent recordRules (automatic)
Phone(651) 555-0183CRM crm:C-01374agency-a-snapshot/clients.csv, row 1374Most recent recordRules (automatic)
Emailtimothy.miller1374@example.comCRM crm:C-01374agency-a-snapshot/clients.csv, row 1374Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01374Enrollment enrollment:1258
First nameTimothyTimothy
Last nameMillerMiller
Birth date1958-01-231958-01-23
MBI (last 4 only)*******VU27*******VU27
Street37218 Gutierrez LocksMissing
CityKnightportMissing
StateKYMissing
ZIP40947Missing
Phone(651) 555-0183Missing
Emailtimothy.miller1374@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1374agency-a-derived/enrollment_clean.csv, row 1258
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1278Mergedcrm:C-01374 and enrollment:1258Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Francisco Miller.same householdTimothy MillerFrancisco Miller

This person shares a household with Francisco Miller.