Golden record

FieldValueTaken fromWhyDeciding tier
First nameAudreyEnrollment enrollment:1523agency-a-derived/enrollment_clean.csv, row 1523Most trusted source (enrollment over CRM)Rules (automatic)
Last nameWileyEnrollment enrollment:1523agency-a-derived/enrollment_clean.csv, row 1523Most trusted source (enrollment over CRM)Rules (automatic)
SuffixNoneNoneNo record has a valueNone
Birth date1949-12-17Enrollment enrollment:1523agency-a-derived/enrollment_clean.csv, row 1523Most trusted source (enrollment over CRM)Rules (automatic)
MBI (last 4 only)*******GJ01Enrollment enrollment:1523agency-a-derived/enrollment_clean.csv, row 1523Most trusted source (enrollment over CRM)Rules (automatic)
Street1695 Adam OrchardCRM crm:C-01664agency-a-snapshot/clients.csv, row 1664Most recent recordRules (automatic)
CityRebeccalandCRM crm:C-01664agency-a-snapshot/clients.csv, row 1664Most recent recordRules (automatic)
StateVTCRM crm:C-01664agency-a-snapshot/clients.csv, row 1664Most recent recordRules (automatic)
ZIP05645CRM crm:C-01664agency-a-snapshot/clients.csv, row 1664Most recent recordRules (automatic)
Phone(392) 555-0107CRM crm:C-01664agency-a-snapshot/clients.csv, row 1664Most recent recordRules (automatic)
Emailaudrey.wiley1664@example.comCRM crm:C-01664agency-a-snapshot/clients.csv, row 1664Most recent recordRules (automatic)

Member records side by side

FieldCRM crm:C-01664Enrollment enrollment:1523
First nameAudreyAudrey
Last nameWileyWiley
Birth date1949-12-171949-12-17
MBI (last 4 only)*******GJ01*******GJ01
Street1695 Adam OrchardMissing
CityRebeccalandMissing
StateVTMissing
ZIP05645Missing
Phone(392) 555-0107Missing
Emailaudrey.wiley1664@example.comMissing
Sourceagency-a-snapshot/clients.csv, row 1664agency-a-derived/enrollment_clean.csv, row 1523
Active policyYesYes

Merge log lines for this person

LineActionPairTierScoreRule
1546Mergedcrm:C-01664 and enrollment:1523Rules (automatic)>0.9999AUTO-MATCH-HIGH (Automatic match)

Household

Household graphThis person shares a household with Larry Wiley.same householdAudrey WileyLarry Wiley

This person shares a household with Larry Wiley.

  • Audrey Wiley (this person)
  • Larry Wiley: same household