Mapping queue
Identity reconciliation suggestions pending review in Snowflake. Read-only view of STAGING_CATALYZE.V_SUGGESTEDMAPPING.
Auto-approved
4
Confidence ≥ 0.95 — exact-ID or deterministic prefix swap
Needs review
2
0.85 – 0.95 — name fuzzy match awaiting data-team decision
Low confidence
1
< 0.85 — likely distinct people; surfaced for completeness
Pending suggestions
| Status | From → To | Names | Method | Confidence | Canonical | Notes |
|---|---|---|---|---|---|---|
| auto-approved | adp_wfn→smartsheet KK6181133 ↔ SKK181133 | Babek Adili-Khams Babek Adili-Khams, MD | prefix_swap | 1.00 | SKK181133 | KK→SKK family — Nate-confirmed 2026-05-15 |
| auto-approved | adp_wfn→smartsheet V0T600673 ↔ VDT600673 | Adam Aisner Adam Aisner | prefix_swap | 1.00 | VDT600673 | V0T→VDT family |
| auto-approved | offer_letter→adp_wfn (no ID) ↔ VDT600100 | Dr. Sarah Chen, MD Sarah Chen | name_fuzzy | 1.00 | VDT600100 | offer letter — degree-stripped name match | source_document=of-2026-05-12-001 |
| needs review | offer_letter→adp_wfn (no ID) ↔ VDT600412 | Michael Patel Mike Patel | name_fuzzy | 0.91 | VDT600412 | nickname variant — please confirm | source_document=of-2026-05-14-002 |
| needs review | offer_letter→adp_wfn (no ID) ↔ VDT600731 | Jennifer Wong Jennifer Wang | name_fuzzy | 0.89 | VDT600731 | single-character surname differential | source_document=of-2026-05-14-007 |
| low confidence | offer_letter→adp_wfn (no ID) ↔ VDT600099 | Sara Chenowith Sarah Chen | name_fuzzy | 0.78 | — | different surnames — probably distinct people | source_document=of-2026-05-15-003 |
| auto-approved | makeshift→smartsheet VDT601218 ↔ VDT601218 | Aaron Lee, PA-C Aaron Lee | exact_id | 1.00 | VDT601218 | post-migration ID — same on both sides |
Source: EXER_ANALYTICS.STAGING_CATALYZE.V_SUGGESTEDMAPPING — approval happens in Snowflake; promoted rows move to EXER_MAPPING.PROVIDER_MAPPING.
How matches are made
- prefix_swapDeterministic KK↔SKK and V0T↔VDT family mappings (confirmed by Nate Walma, 2026-05-15). 100% confidence.
- exact_idSame external ID format across systems (post-migration only).
- name_fuzzyJaro-Winkler name match. Strips degrees (MD/PA-C/etc.) and titles (Dr./Mr./Ms.), handles "Last, First" transposition. Used when offer letters arrive without an ID.