Record, TPA, bronze and silver
TPA-57891
Received 2026-07-15T03:35:32Z, line 80,447 of the TPA feed
TPARule
Bronze vs silver
Field by field: what arrived, what normalisation produced, and whether anything changed
| Field | Bronze (as received) | Silver (normalised) | Change |
|---|---|---|---|
| First name | Betty | Betty | Unchanged |
| Middle | — | — | Unchanged |
| Last name | Paetl | Paetl | Unchanged |
| Date of birth | 07-02-1959 | 1959-02-07 | Parsed |
| Gender | M | M | Unchanged |
| Member ID | UHC-54842-23 | UHC-54842-23 | Unchanged |
| SSN | •••-••-3836 | •••-••-3836 | Unchanged |
| Phone | 7427794631 | 7427794631 | Unchanged |
| betty.patel16@aol.com | betty.patel16@aol.com | Unchanged | |
| Address | 1321 River Road Apt 2·· | 1321 River Rd Apt 2 | Changed |
| City | Charlotte | Charlotte | Unchanged |
| State | NC | NC | Unchanged |
| ZIP | 28291 | 28291 | Unchanged |
| Group | — | — | Unchanged |
| Plan | — | — | Unchanged |
- Quality score
- 0.68
- Name key
- betty|paetl
- Address key
- 1321|river|28291
- Canonical first
- betty
Quality flags
4 raised during normalisation
- Date of birth reformattedDate of birth rewritten to ISO 8601 from a source format (MM/DD/YYYY, YYYYMMDD, Mon D, YYYY)
- Unit split from streetApartment, suite or unit designator split from street line and re-appended in standard form
- Street suffix standardisedStreet suffix standardised to USPS abbreviation (Street to St, Avenue to Ave, and so on)
- Address re-casedStreet line re-cased and punctuation removed
Candidate pairs
Every scored comparison involving this record, highest score first
| Other record | Score | Method | Rule | Decision |
|---|---|---|---|---|
| CLM-417884 | 0.99 | Rule | D1 member id + dob exact | Auto-linked |
| CLM-417885 | 0.99 | Rule | D1 member id + dob exact | Auto-linked |
| TPA-57892 | 0.97 | Rule | D2 ssn4 + dob + last name | Auto-linked |
Resolution
Linked 2026-10-22 12:43:43
- Identity
- MBR-000110
- Method
- Rule
- Confidence
- 0.99
- Rule
- D1 member id + dob exact
Golden record: Betty Patel, 1959-02-07, 4 records, Verified
Evidence
Matched against CLM-417884
| Field | Similarity | Weight | Note |
|---|---|---|---|
| Name | 0.97 | 3.0 | |
| Date of birth | 1.00 | 3.0 | exact |
| Member ID | 1.00 | 4.0 | |
| Phone | 1.00 | 1.5 | |
| Address | 0.70 | 2.0 | street_match |
Audit
6 hash-chained entries for this record
- Record linked automatically1fde2ad2452026-10-22 12:43:51, matching_agentidentity id MBR-000110, confidence 0.99, rule D1 member_id + dob exact, method deterministic, matched record CLM-417884
- Record linked automaticallye0425478bc2026-10-19 19:54:38, matching_agentidentity id MBR-000110, confidence 0.99, rule D1 member_id + dob exact, method deterministic, matched record CLM-417884
- Record linked automatically4ce1ffbd212026-10-19 19:52:08, matching_agentidentity id MBR-000110, confidence 0.99, rule D1 member_id + dob exact, method deterministic, matched record CLM-417884
- Record linked automatically9433ff7a702026-10-19 19:45:41, matching_agentidentity id MBR-000110, confidence 0.99, rule D1 member_id + dob exact, method deterministic, matched record CLM-417884
- Record linked automatically3b138f563e2026-10-19 19:32:30, matching_agentidentity id MBR-000110, confidence 0.99, rule D1 member_id + dob exact, method deterministic, matched record CLM-417884
- Record linked automatically9c9cb1fcf42026-10-19 19:31:28, matching_agentidentity id MBR-011062, confidence 0.97, rule D2 ssn4 + dob + last name, method deterministic, matched record ENR-123642