Golden record

FieldValueTaken fromWhyDeciding tier
First nameHeatherEnrollment enrollment:501agency-a-derived/enrollment_clean.csv, row 501Most trusted source (enrollment over CRM)Rules (automatic)
Last namePachecoEnrollment enrollment:501agency-a-derived/enrollment_clean.csv, row 501Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1946-05-24Enrollment enrollment:501agency-a-derived/enrollment_clean.csv, row 501Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******YY71Enrollment enrollment:501agency-a-derived/enrollment_clean.csv, row 501Most trusted source (enrollment over CRM)Rules (automatic)
Street9392 Robert Cape Apt. 780CRM crm:C-00569agency-a-snapshot/clients.csv, row 569Most recent recordRules (automatic)
CitySchmidtfortCRM crm:C-00569agency-a-snapshot/clients.csv, row 569Most recent recordRules (automatic)
StateIDCRM crm:C-00569agency-a-snapshot/clients.csv, row 569Most recent recordRules (automatic)
ZIP83837CRM crm:C-00569agency-a-snapshot/clients.csv, row 569Most recent recordRules (automatic)
Phone(493) 555-0173CRM crm:C-00569agency-a-snapshot/clients.csv, row 569Most recent recordRules (automatic)
Emailheather.pacheco569@example.comCRM crm:C-00569agency-a-snapshot/clients.csv, row 569Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-00569CRM crm:C-02017Enrollment enrollment:501
First nameHeatherHeatherHeather
Last namePachecoPahecoPacheco
Birth date1946-05-241946-05-241946-05-24
MBI (last 4 only)*******YY71*******YY71*******YY71
Street9392 Robert Cape Apt. 7809392 Robert Cape Apt. 780Missing
CitySchmidtfortSchmidtfortMissing
StateIDIDMissing
ZIP8383783837Missing
Phone(493) 555-0173(493) 555-0173Missing
Emailheather.pacheco569@example.comMissingMissing
Sourceagency-a-snapshot/clients.csv, row 569agency-a-snapshot/clients.csv, row 2017agency-a-derived/enrollment_clean.csv, row 501
Active policyNoNoNo

Merge log lines for this person

LineActionPairTierScoreRule
506Mergedcrm:C-00569 and crm:C-02017Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
507Mergedcrm:C-00569 and enrollment:501Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1893Mergedcrm:C-02017 and enrollment:501Rules (automatic)0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Corey Pacheco.same householdHeather PachecoCorey Pacheco

This person shares a household with Corey Pacheco.