15 dominios: book records a zero-duration row same-day as the real opening period - question for Eugenia

Sub-tickets — 6/16 done

Activity

• coder03-mba-l-cc created · 1w ago
• coder03-mba-l-cc assigned · 1w ago
  researcher-mba-l-cc / solo
• researcher-mba-l-cc statusChanged · 1w ago
  Researcher started at 2026-10-08T12:12:36-03:00.
• researcher-mba-l-cc verified · 1w ago
  researcher-mba-l-cc Independently re-verified all 15 dominios directly against the pinned workbook, not by trusting MOVILBA-726's 3-row sample. MD5 of /data-lezama/movilba/libro/2026-10-06-1140-parque-rutap.xlsx confirmed eb2e2683ccdd16a33be4a34b7b56088b (matches the pinned digest). Read Base sheet (header row 2) at the exact row numbers cited for all 15 dominios, checked dominio match, fecha_alta=fecha_baja on the zero row, shared start date with the longer row, and the longer row's own end date/tramite. All 15/15 pass on every check - dominio, zero-duration, shared-start. Full per-row output kept in scratchpad, not attached (same conclusion as 726, now independently confirmed for the full set instead of a 3-row sample). DRAFT QUESTION FOR EUGENIA (coder03 writes to tracker XLSX): "Para estos 15 dominios, la base tiene DOS filas con la misma fecha de alta: una con alta y baja el mismo dia (duracion cero) y otra con un periodo real mas largo arrancando ese mismo dia. Dominios: AB259JY, AD919PL, AE352LD, AE922FX, AE971FE, AE971FF, AG358KX, AH850FS, AH850GK, AI023DC, AI024HE, AI058QM, AI105QP, AI357IV, OPB348. ¿La fila de duracion cero es (a) un registro duplicado que se puede ignorar, (b) una correccion que anulo y reemplazo esa fila, o (c) un registro administrativo intencional (por ejemplo, un alta y baja el mismo dia por un tramite que no llego a tener vigencia)? No vamos a tocar la importacion hasta la respuesta." No DB/import change made or recommended - per the ticket's own instruction, this stays a question until Eugenia answers.
• researcher-mba-l-cc blocked · 1w ago
  Verified, question drafted in bwi note. Waiting on coder03 to write it to the tracker XLSX and on Eugenia's answer.
• researcher-mba-l-cc blocked · 1w ago
  Written to tracker XLSX, confirmed done - waiting on Eugenia's answer only.
• db04-mba-l-ca note · 1w ago
  Additional SELECT-only evidence from MOVILBA-38 (PROD snapshot 11, DEV snapshot 21): five of this item's 15 domains—AH850FS, AI023DC, AH850GK, AI058QM, AI024HE—have two imported normalized-history rows with the same vehiculo_id and fecha_alta equal to a predecessor's fecha_baja. In each, one candidate expte_alta matches the predecessor expte_baja and the other differs; choosing by expediente would assume the relationship under question. Existing tracker question at live Pendientes!D8 already names all five and asks whether the zero-duration row is duplicate/correction/intentional. F8 remains unanswered; no duplicate question added. Source: MOVILBA-38 current-book measurement, not a DB repair proposal.
• coder03-mba-l-ca note · 2d ago
  2026-10-13 pinned workbook SHA256 81874621...bd20 checked directly in Base XML: all 15 listed domains still have exactly one row with Fecha_Alta=Fecha_Baja and another row with the same Fecha_Alta and a nonzero period. Pending CSV now asks Eugenia whether each one-day period is intentional or requires book correction; import remains faithful, no DB change.
• coder03-mba-l-ca progress · 1d ago
  Split the 15 domains into child questions MOVILBA-805 through MOVILBA-819; created MOVILBA-820 to clarify the draft-only AE922FE mention. Updated the 2026-10-15-1428 Pendientes CSV to one concise row per domain, preserving draft answers as unconfirmed and keeping MOVILBA-244 separate. Supporting 50-to-106 transfer CSV covers AE922FX, AE971FE and AE971FF; no source or DB changes. Parent stays open until Eugenia confirms individual answers.