Golden record

FieldValueTaken fromWhyDeciding tier
First nameJanetEnrollment enrollment:685agency-a-derived/enrollment_clean.csv, row 685Most trusted source (enrollment over CRM)Rules (automatic)
Last nameGordonEnrollment enrollment:685agency-a-derived/enrollment_clean.csv, row 685Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1939-06-30Enrollment enrollment:685agency-a-derived/enrollment_clean.csv, row 685Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******QF24Enrollment enrollment:685agency-a-derived/enrollment_clean.csv, row 685Most trusted source (enrollment over CRM)Rules (automatic)
Street2571 Smith PrairieCRM crm:C-00780agency-a-snapshot/clients.csv, row 780Most recent recordRules (automatic)
CityReyesburyCRM crm:C-00780agency-a-snapshot/clients.csv, row 780Most recent recordRules (automatic)
StateMTCRM crm:C-00780agency-a-snapshot/clients.csv, row 780Most recent recordRules (automatic)
ZIP59596CRM crm:C-00780agency-a-snapshot/clients.csv, row 780Most recent recordRules (automatic)
Phone(304) 555-0195CRM crm:C-00780agency-a-snapshot/clients.csv, row 780Most recent recordRules (automatic)
EmailNoneNoneNo record has a valueNone

Member records side by side

FieldCRM crm:C-00780Enrollment enrollment:685
First nameJanetJanet
Last nameGordonGordon
Birth date1939-06-301939-06-30
MBI (last 4 only)*******QF24*******QF24
Street2571 Smith PrairieMissing
CityReyesburyMissing
StateMTMissing
ZIP59596Missing
Phone(304) 555-0195Missing
EmailMissingMissing
Sourceagency-a-snapshot/clients.csv, row 780agency-a-derived/enrollment_clean.csv, row 685
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
697Mergedcrm:C-00780 and enrollment:685Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphOnly this person is in the household.Janet Gordon

Only this person is in the household.

  • Janet Gordon (this person)