~22 vehiculos donde rutap no tiene NADA de entidad y el libro si nombra algo

Sub-tickets

Activity

• wi-cli-venus created · 5w ago
• wi-cli-venus assigned · 5w ago
  db02-mba-l-cc
• wi-cli-venus assigned · 3w ago
  db04-mba-l-ca
• db04-mba-l-ca progress · 3w ago
  db04-mba-l-ca 2026-09-24 04:03 -03 — SELECT-only current-state check: DEV movilba_dev snapshot 18 and PROD movilba snapshot 5 both identify 2026-09-19-0648-parque-rutap-corrected.xlsx with 5528 source rows. The entity-missing source-to-projection count was not recomputed. Status unchanged; no DB write.
• researcher-mba-l-cc statusChanged · 1w ago
  researcher-mba-l-cc claiming, 2026-10-06 15:52 ART. Plan: db04 pulls current dominio list + book-stated entidad text for the ~22 rows where rutap entidad is empty but the book names something (fresh, post dbcaba-outage snapshot); per catalog order I match each book entidad string against the entidades catalog, research online (CUIT/registry lookups) for any that don't match, and only what survives goes to Eugenia.
• db04-mba-l-ca progress · 1w ago
  2026-10-06 SELECT-only fresh census after DEV recovery: PROD snapshot 8 and DEV snapshot 20 both pin 2026-09-30-1305-parque-rutap.xlsx (md5 8512833be84d1568743d61b601179c6b), 5548 raw/normalized import rows and 5548 nonblank book entity cells per base. Zero rows with named book identificador_empresa and NULL normalized entidad_id in either base. Current vehicle-detail NULL entidad_id is 0/2419 PROD, 0/2465 DEV; live vehicle/book/current-entity join also 0 domains/rows in each. Requested exception list empty; old ~22 count is stale. Query and controls: /data-lezama/movilba/evidencia/MOVILBA-320/2026-10-06-current-entity-gap.md. No write.
• researcher-mba-l-cc completed · 1w ago
  researcher-mba-l-cc 2026-10-06 15:56 ART. db04 fresh census against current approved book (2026-09-30-1305-parque-rutap.xlsx, md5 8512833be84d1568743d61b601179c6b, PROD snapshot8/DEV snapshot20): the entity-missing-while-book-names-one exception list is empty in both bases, 0/5548 rows. Positive control present (5548 named-entity book rows = 5548 normalized import rows in each base, current vehicle-detail also 0 NULL entidad_id). The original ~22 was tied to a superseded snapshot (5/18) and does not reproduce now - already resolved by a later import, not something to carry forward. Nothing survives to match against the catalog, research online, or bring to Eugenia. Evidence: /data-lezama/movilba/evidencia/MOVILBA-320/2026-10-06-current-entity-gap.md.