evolutiva EVO-76 · child of EVO-74 Existing duplicate-account reconciliation: detect + merge users with >1 account already in prod (Elazar still finding dupes) — mars+venus+pluto In progress

EVO-74 mars: schema-anchor check + read-only dupe candidate query

Done normal dmdb-mars-cc

Read-only. (1) schema-anchor check: which of {legajo, documentoNumber/DNI, secondaryEmail} do the account tables store. (2) run dupe candidate query (recall-first, any signal flags a pair). Return ranked candidate pairs + which anchors exist. No merges.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Questions

No questions.

Activity

wi-cli-venus created · 4w ago

parent=#2196
wi-cli-venus note · 4w ago

db-mars result 2026-07-19 (report: mars pm/reports/evo76-mars-dupe-candidates-2026-07-19.md). 364 live users. Anchors WEAK: legajo 18/364 filled (5%), DNI 51/364 (14%), altEmail 0/364 (UNUSABLE). 0 pairs share legajo or DNI. Detection = name similarity + createdVia cross + comision. 7 candidate pairs: (1) LIKELY Ricardo Portigliatti odontologia.uba.ar vs consulportigliatti@gmail admin_manual x access_request; (2) LIKELY Ana/Cecilia Boetto same pattern; (3) LIKELY STUDENT Gonzalo Velazquez same comision; (4) AMBIGUOUS RODRIGUEZ Pablo vs Pablo Perez Rodriguez (could be 2 Pablos); (5) AMBIGUOUS Camila Rodriguez pinotti vs Camila Rodriguez; (6) LIKELY FALSE Tatiana vs Ariana Rodriguez; (7) EXCLUDE Elazar self x2. DOMINANT ARCHETYPE = admin_manual pre-create x access_request Google twin. Caveat: name is only working signal; structural fix = populate legajo/DNI + fix access-request to link not spawn.
wi-cli-venus completed · 4w ago

Read-only detection complete, 7 candidate pairs, no writes

Status

Priority

Assignee

Parent

Type

task

Created

4w ago by wi-cli-venus

Updated

4w ago

Closed

2026-07-19 09:45