Golden record

FieldValueTaken fromWhyDeciding tier
First nameFranciscoEnrollment enrollment:1257agency-a-derived/enrollment_clean.csv, row 1257Most trusted source (enrollment over CRM)Rules (automatic)
Last nameMillerEnrollment enrollment:1257agency-a-derived/enrollment_clean.csv, row 1257Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1933-10-25Enrollment enrollment:1257agency-a-derived/enrollment_clean.csv, row 1257Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******CW52Enrollment enrollment:1257agency-a-derived/enrollment_clean.csv, row 1257Most trusted source (enrollment over CRM)Rules (automatic)
Street37218 Gutierrez LocksCRM crm:C-01373agency-a-snapshot/clients.csv, row 1373Most recent recordRules (automatic)
CityKnightportCRM crm:C-01373agency-a-snapshot/clients.csv, row 1373Most recent recordRules (automatic)
StateKYCRM crm:C-01373agency-a-snapshot/clients.csv, row 1373Most recent recordRules (automatic)
ZIP40947CRM crm:C-01373agency-a-snapshot/clients.csv, row 1373Most recent recordRules (automatic)
Phone(970) 555-0151CRM crm:C-01373agency-a-snapshot/clients.csv, row 1373Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01373Enrollment enrollment:1257
First nameFranciscoFrancisco
Last nameMillerMiller
Birth date1933-10-251933-10-25
MBI (last 4 only)*******CW52*******CW52
Street37218 Gutierrez LocksMissing
CityKnightportMissing
StateKYMissing
ZIP40947Missing
Phone(970) 555-0151Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1373agency-a-derived/enrollment_clean.csv, row 1257
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1277Mergedcrm:C-01373 and enrollment:1257Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Timothy Miller.same householdFrancisco MillerTimothy Miller

This person shares a household with Timothy Miller.