Bob Resolve / Record provenance
Why did these records become one person?
Nancy Mckay is 3 records: crm:C-00005, enrollment:4, enrollment:5.
Aliases: none.
Candidate identity group. A deterministic match does not confirm a person.
Golden record
| Field | Value | Taken from | Why | Deciding tier |
|---|---|---|---|---|
| First name | Nancy | Enrollment enrollment:5agency-a-derived/enrollment_clean.csv, row 5 | Most trusted source (enrollment over CRM) | Rules (automatic) |
| Last name | Mckay | Enrollment enrollment:5agency-a-derived/enrollment_clean.csv, row 5 | Most trusted source (enrollment over CRM) | Rules (automatic) |
| Suffix | None | None | No record has a value | None |
| Birth date | 1957-09-01 | Enrollment enrollment:5agency-a-derived/enrollment_clean.csv, row 5 | Most trusted source (enrollment over CRM) | Rules (automatic) |
| MBI (last 4 only) | *******WY24 | Enrollment enrollment:5agency-a-derived/enrollment_clean.csv, row 5 | Most trusted source (enrollment over CRM) | Rules (automatic) |
| Street | 480 Erin Plain Suite 514 | CRM crm:C-00005agency-a-snapshot/clients.csv, row 5 | Most recent record | Rules (automatic) |
| City | Mooretown | CRM crm:C-00005agency-a-snapshot/clients.csv, row 5 | Most recent record | Rules (automatic) |
| State | GA | CRM crm:C-00005agency-a-snapshot/clients.csv, row 5 | Most recent record | Rules (automatic) |
| ZIP | 30075 | CRM crm:C-00005agency-a-snapshot/clients.csv, row 5 | Most recent record | Rules (automatic) |
| Phone | (608) 555-0164 | CRM crm:C-00005agency-a-snapshot/clients.csv, row 5 | Most recent record | Rules (automatic) |
| nancy.mckay5@example.com | CRM crm:C-00005agency-a-snapshot/clients.csv, row 5 | Most recent record | Rules (automatic) |
Member records side by side
| Field | CRM crm:C-00005 | Enrollment enrollment:4 | Enrollment enrollment:5 |
|---|---|---|---|
| First name | Nancy | Nancy | Nancy |
| Last name | Mckay | Mckay | Mckay |
| Birth date | 1957-09-01 | 1957-09-01 | 1957-09-01 |
| MBI (last 4 only) | *******WY24 | *******WY24 | *******WY24 |
| Street | 480 Erin Plain Suite 514 | Missing | Missing |
| City | Mooretown | Missing | Missing |
| State | GA | Missing | Missing |
| ZIP | 30075 | Missing | Missing |
| Phone | (608) 555-0164 | Missing | Missing |
| nancy.mckay5@example.com | Missing | Missing | |
| Source | agency-a-snapshot/clients.csv, row 5 | agency-a-derived/enrollment_clean.csv, row 4 | agency-a-derived/enrollment_clean.csv, row 5 |
| Active policy | Yes | No | Yes |
Merge log lines for this person
| Line | Action | Pair | Tier | Score | Rule |
|---|---|---|---|---|---|
| 5 | Merged | crm:C-00005 and enrollment:4 | Rules (automatic) | >0.9999 | AUTO-MATCH-HIGH (Automatic match) |
| 6 | Merged | crm:C-00005 and enrollment:5 | Rules (automatic) | >0.9999 | AUTO-MATCH-HIGH (Automatic match) |
| 2076 | Merged | enrollment:4 and enrollment:5 | Rules (automatic) | >0.9999 | AUTO-MATCH-HIGH (Automatic match) |
Household
This person shares a household with Jose Mckay, Vincent Mckay.
- Nancy Mckay (this person)
- Jose Mckay: same household
- Vincent Mckay: same household