Golden record

FieldValueTaken fromWhyDeciding tier
First nameAmyEnrollment enrollment:1448agency-a-derived/enrollment_clean.csv, row 1448Most trusted source (enrollment over CRM)Rules (automatic)
Last nameRichardsEnrollment enrollment:1448agency-a-derived/enrollment_clean.csv, row 1448Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1936-08-27Enrollment enrollment:1448agency-a-derived/enrollment_clean.csv, row 1448Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******FF30Enrollment enrollment:1448agency-a-derived/enrollment_clean.csv, row 1448Most trusted source (enrollment over CRM)Rules (automatic)
Street10797 Martinez GlenCRM crm:C-01580agency-a-snapshot/clients.csv, row 1580Most recent recordRules (automatic)
CityNorth KaitlynviewCRM crm:C-01580agency-a-snapshot/clients.csv, row 1580Most recent recordRules (automatic)
StateKYCRM crm:C-01580agency-a-snapshot/clients.csv, row 1580Most recent recordRules (automatic)
ZIP42588CRM crm:C-01580agency-a-snapshot/clients.csv, row 1580Most recent recordRules (automatic)
Phone(460) 555-0160CRM crm:C-01580agency-a-snapshot/clients.csv, row 1580Most recent recordRules (automatic)
Emailamy.richards1580@example.comCRM crm:C-01580agency-a-snapshot/clients.csv, row 1580Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01580CRM crm:C-02034Enrollment enrollment:1447Enrollment enrollment:1448
First nameAmyAmyAmyAmy
Last nameRichardsRchardsRichardsRichards
Birth date1936-08-271936-08-271936-08-271936-08-27
MBI (last 4 only)*******FF30*******FF30*******FF30*******FF30
Street10797 Martinez Glen10797 Martinez GlenMissingMissing
CityNorth KaitlynviewNorth KaitlynviewMissingMissing
StateKYKYMissingMissing
ZIP4258842588MissingMissing
Phone(460) 555-0160(460) 555-0160MissingMissing
Emailamy.richards1580@example.comMissingMissingMissing
Sourceagency-a-snapshot/clients.csv, row 1580agency-a-snapshot/clients.csv, row 2034agency-a-derived/enrollment_clean.csv, row 1447agency-a-derived/enrollment_clean.csv, row 1448
Active policyYesNoNoYes

Merge log lines for this person

LineActionPairTierScoreRule
1470Mergedcrm:C-01580 and crm:C-02034Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1471Mergedcrm:C-01580 and enrollment:1447Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1472Mergedcrm:C-01580 and enrollment:1448Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)
1910Mergedcrm:C-02034 and enrollment:1447Rules (automatic)0.9999AUTO-MATCH-HIGH (Automatic match)
1911Mergedcrm:C-02034 and enrollment:1448Rules (automatic)0.9999AUTO-MATCH-HIGH (Automatic match)
1977Mergedenrollment:1447 and enrollment:1448Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Shelly Richards.same householdAmy RichardsShelly Richards

This person shares a household with Shelly Richards.