Golden record

FieldValueTaken fromWhyDeciding tier
First nameFrankEnrollment enrollment:769agency-a-derived/enrollment_clean.csv, row 769Most trusted source (enrollment over CRM)Rules (automatic)
Last nameHollandEnrollment enrollment:769agency-a-derived/enrollment_clean.csv, row 769Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1946-05-18Enrollment enrollment:769agency-a-derived/enrollment_clean.csv, row 769Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******UX84Enrollment enrollment:769agency-a-derived/enrollment_clean.csv, row 769Most trusted source (enrollment over CRM)Rules (automatic)
Street73652 Davis Falls Suite 223CRM crm:C-00868agency-a-snapshot/clients.csv, row 868Most recent recordRules (automatic)
CityHardingburghCRM crm:C-00868agency-a-snapshot/clients.csv, row 868Most recent recordRules (automatic)
StateWVCRM crm:C-00868agency-a-snapshot/clients.csv, row 868Most recent recordRules (automatic)
ZIP26017CRM crm:C-00868agency-a-snapshot/clients.csv, row 868Most recent recordRules (automatic)
Phone(581) 555-0172CRM crm:C-00868agency-a-snapshot/clients.csv, row 868Most recent recordRules (automatic)
Emailfrank.holland868@example.comCRM crm:C-00868agency-a-snapshot/clients.csv, row 868Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00868Enrollment enrollment:769
First nameFrankFrank
Last nameHollandHolland
Birth date1946-05-181946-05-18
MBI (last 4 only)*******UX84*******UX84
Street73652 Davis Falls Suite 223Missing
CityHardingburghMissing
StateWVMissing
ZIP26017Missing
Phone(581) 555-0172Missing
Emailfrank.holland868@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 868agency-a-derived/enrollment_clean.csv, row 769
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
783Mergedcrm:C-00868 and enrollment:769Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Andrew Holland.same householdFrank HollandAndrew Holland

This person shares a household with Andrew Holland.

  • Andrew Holland: same household
  • Frank Holland (this person)