basquetWi + New ticket
movilba MOVILBA-619

Ask Eugenia about seven overlapping ID MDVR uses on different chassis

Done normal unassigned

The source itself, /data-lezama/movilba/libro/2026-09-28-1042-parque-rutap.xlsx Base, was read directly on 2026-09-30. Comparing ID MDVR after removing only the leading Excel text-guard apostrophe, among cross-vehicle guarded/plain pairs there are 55 row pairs over all periods: 35 meet exactly at a period boundary, 13 do not overlap, and 7 overlap for a positive duration. Each of the 7 overlapping pairs has different Chasis_Nro. Pairs (ID, guarded dominio/Excel row, plain dominio/Excel row): 303033303300 AC736PL/5144 AD463TT/2791; 303031313000 AA681DX/5016 AA467DO/3172; 303033393024 AI380TC/5202 AE618VJ/3380; 303033393092 AI380TE/5264 AE618VI/3381; 303031323000 AD672XS/5025 AA151PI/3862; 088000006393 AB629EO/4659 AH735FT/3927; 303033393085 AI019JU/5257 AI019JR/3936. Need Eugenia's criterion: can an ID MDVR be listed on two different chassis during overlapping periods? No source change by inference. The earlier 42 cross-vehicle matches on the DB current-history view do not establish simultaneous open book periods and must not be the stakeholder question. Related MOVILBA-618; its normalization remains correct.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Activity

  • db04-mba-l-ca created · 2w ago
  • db04-mba-l-ca titleChanged · 2w ago
    Ask Eugenia about seven overlapping ID MDVR uses on different chassis
  • db04-mba-l-ca descriptionChanged · 2w ago
    was: PROD movilba and DEV movilba_dev post-MOVILBA-618 measurement on 2026-09-30: 42 current cross-vehicle pairs (42 distinct ID MDVR strings) have the same normalized identifier where one source cell had an Excel text-guard apostrophe and another did not; across all historical periods there are 55 pairs. Raw source/staging was not changed; stripping transport punctuation only exposed equality already implicit in the book. No uniqueness constraint or identified equality join relies on ip_mdvr. Need Eugenia's criterion: may one ID MDVR belong to two currently listed vehicles, or are these source entries to review? Do not change the book or app data by inference. Evidence: /data-lezama/movilba/evidencia/MOVILBA-618/2026-09-30-applied.md. Existing Para Eugenia/Para Elazar/Resueltos in live and 2026-09-28-1423 download were searched for MDVR/duplicate-identifier question; none found. Related: MOVILBA-618 (text guard strip, done).
  • coder03assistant-mba-l-ca progress · 2w ago
    coder03assistant-mba-l-ca | 2026-09-30 04:08 ART — Added Para Eugenia question #92 at row 12 of live todo-rutap-importacion-prestaciones.xlsx. B12 asks whether one ID MDVR may appear on two chassis during overlapping periods; C12 identifies the 2026-09-28-1042 Base source; E12 remains PENDIENTE; G12 links MOVILBA-619. Checked live and latest download (2026-09-28-1423) across Para Eugenia, Para Elazar and Resueltos; no duplicate question. Re-imported tracker as SQLite snapshot 30; diff 29→30 shows only Para Eugenia +1 row/#92, all other sheets unchanged. Question remains open; no data changes requested.
  • db04-mba-l-ca progress · 2w ago
    db04-mba-l-ca 2026-09-30 04:08 ART. Independently read the agent-maintained live tracker /data-lezama/movilba/import-reports/todo-rutap-importacion-prestaciones.xlsx, Para Eugenia!A12:G12. Question #92 in B12 asks whether one ID MDVR may appear on two different chassis during overlapping periods; C12 identifies the 2026-09-28-1042 current book; D12 is blank, E12=PENDIENTE, G12=MOVILBA-619. coder03assistant-mba-l-ca added the row under the workbook lock and reported snapshot 30, diff 29→30 limited to this row. Await Eugenia's answer; no data change implied.
  • db04-mba-l-ca blocked · 2w ago
    db04-mba-l-ca 2026-09-30 04:08 ART. Waiting for Eugenia's answer to Para Eugenia question #92 (live tracker row 12): may one ID MDVR appear on two different chassis during overlapping book periods? Verified B12/C12/E12/G12; no answer in D12. No import, normalization, or data fix is blocked by this question.
  • coder03-mba-l-cc unblocked · 2w ago
    cleared: db04-mba-l-ca 2026-09-30 04:08 ART. Waiting for Eugenia's answer to Para Eugenia question #92 (live tracker row 12): may one ID MDVR appear on two different chassis during overlapping book periods? Verified B12/C12/E12/G12; no answer in D12. No import, normalization, or data fix is blocked by this question.
  • coder03-mba-l-cc completed · 2w ago
    Elazar, 2026-10-01 (CLI): 'ignore that, leave it as is, it is in ssot thus we call it done.' Los siete ID MDVR que se repiten en chasis distintos estan en el libro, asi que son el valor. No hay pregunta para Eugenia ni correccion que hacer: la cuarta regla del 2026-09-24 ya lo decide - si el SSOT tiene un valor, ese es el valor. No reabrir.
question
2w ago by db04-mba-l-ca
2w ago
2026-10-01 13:17