Golden record

FieldValueTaken fromWhyDeciding tier
First nameMichaelEnrollment enrollment:1640agency-a-derived/enrollment_clean.csv, row 1640Most trusted source (enrollment over CRM)Rules (automatic)
Last nameFrostEnrollment enrollment:1640agency-a-derived/enrollment_clean.csv, row 1640Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1938-10-18Enrollment enrollment:1640agency-a-derived/enrollment_clean.csv, row 1640Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******WA12Enrollment enrollment:1640agency-a-derived/enrollment_clean.csv, row 1640Most trusted source (enrollment over CRM)Rules (automatic)
Street76487 Marie Mountains Suite 546CRM crm:C-01782agency-a-snapshot/clients.csv, row 1782Most recent recordRules (automatic)
CityNew KristinburghCRM crm:C-01782agency-a-snapshot/clients.csv, row 1782Most recent recordRules (automatic)
StateIDCRM crm:C-01782agency-a-snapshot/clients.csv, row 1782Most recent recordRules (automatic)
ZIP83344CRM crm:C-01782agency-a-snapshot/clients.csv, row 1782Most recent recordRules (automatic)
Phone(845) 555-0121CRM crm:C-01782agency-a-snapshot/clients.csv, row 1782Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-01782Enrollment enrollment:1640
First nameMichaelMichael
Last nameFrostFrost
Birth date1938-10-181938-10-18
MBI (last 4 only)*******WA12*******WA12
Street76487 Marie Mountains Suite 546Missing
CityNew KristinburghMissing
StateIDMissing
ZIP83344Missing
Phone(845) 555-0121Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1782agency-a-derived/enrollment_clean.csv, row 1640
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1666Mergedcrm:C-01782 and enrollment:1640Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Brendan Frost.same householdMichael FrostBrendan Frost

This person shares a household with Brendan Frost.