Criterio MDVR: camaras_internas o id_mdvr distinto de cero implica MDVR = SI
Criterio de Eugenia, textual: 'MDVR: Si Camaras_Internas distinto de cero y/o ID MDVR distinto de cero implica que MDVR = Si'. Mismo bloque sin numerar de la pestana Para Elazar, filas 32-34. Columnas involucradas. Libro RUTAP: mdvr, camaras_internas, id_mdvr. Negocio en public.vehiculos_datos_colectivos: mdvr_id (FK a opciones), camaras_internas smallint, ip_mdvr text. Ojo con ip_mdvr: la columna se llama ip_ pero el dato es el ID MDVR del libro, y MOVILBA-618 ya le saco el apostrofe de transporte, asi que hoy son doce digitos limpios y un distinto de cero se puede evaluar sin normalizar de nuevo. Que hay que medir ANTES de proponer nada, en PROD y contra el libro vigente: 1. Cuantas filas tienen camaras_internas distinto de cero y/o ip_mdvr con valor mientras mdvr dice NO o viene vacio. Ese conteo es el tamano real del problema; si es cero no hay nada que arreglar y el item se cierra con la medicion. 2. A que grupo de opciones apunta hoy mdvr_id. La regla permanente es que todo campo Si/No resuelve contra general/respuesta_binaria, 24 SI y 25 NO; un catalogo dedicado para un booleano es el defecto, no la solucion. 3. Si el criterio se aplica al IMPORTAR o solo se usa como control que reporta la discrepancia. No lo decide el carril: el libro es SSOT y derivar un valor que el libro no dice es inventar un hecho. Salida esperada: medicion mas recomendacion; la decision es de Elazar. Gemelo de MOVILBA-633, que es el mismo criterio para ADAS. Conviene medirlos juntos y traer los dos conteos en el mismo reporte.
Activity
-
db04-mba-l-ca 2026-10-01 11:10 ART. Waiting on Elazar: should Eugenia's MDVR implication be a discrepancy report only, preserving source MDVR=NO, or may the importer derive SI against the book's explicit NO? PROD movilba, snapshot 8 = 2026-09-30-1305-parque-rutap.xlsx, md5 8512833be84d1568743d61b601179c6b (disk md5 matches), 5548 source rows. Criterion: upper(btrim(mdvr)) IN ('NO','') AND (numeric camaras_internas<>0 OR ID MDVR after stripping its known leading Excel apostrophe is nonblank and not all zero). Result 403 contradictions, all NO, 0 blank: 377 with nonzero cameras, 131 with nonzero ID, 105 both (272 camera-only, 26 ID-only). Three apparent extras ('000000000000 on AE192MZ/AH207DF/AI501GH) vanish when transport apostrophe is stripped; raw staging is not changed. Installed normalized history has same 403 contradictory rows; current VDC has 41. mdvr_id resolves exclusively to opciones 24 SI / 25 NO, both general.respuesta_binaria (4314/1234 imported history; current VDC 2185/234). Recommend discrepancy report only until explicit derivation ruling; do not silently rewrite source NO. Not exercised: future snapshots or downstream display.
-
coder03-mba-l-cc 2026-10-01 11:13 ART - ROUTING: this is a question for Eugenia, not a decision for Elazar. The book says MDVR = NO on 403 rows while the same book's own camaras_internas / id_mdvr columns carry a nonzero value on those rows; that is an internal contradiction of the SSOT, and the standing rule is that an SSOT contradiction goes back to its author. The criterion that exposes it is hers to begin with. Deriving SI over an explicit NO stays out of scope meanwhile: the discrepancy is reported, not written. Going into the tracker as a Para Eugenia question with the 403 count, the 377 / 131 / 105 breakdown and the 41 current VDC contradictions; held off the write only because Elazar is uploading the workbook right now.
-
Esperando a Eugenia: el libro dice MDVR = NO en 403 filas que el mismo libro trae con camaras_internas o id_mdvr distinto de cero. Contradiccion interna del SSOT, vuelve a su autora. No se deriva SI sobre un NO explicito mientras tanto.
-
coder03assistant-mba-l-ca | 2026-10-05 13:43 ART Internal tracker instructions removed from stakeholder-facing Comentario para Claudia cells in archived live workbook SHA cb74a882. Original Pendientes L16 and L50: 'Anexo Datos: todo-rutap-anexos.xlsx, hoja Datos.'
-
Stakeholder feedback, tracker online 2026-10-05 13:24 (Eugenia/Fabri), relayed by coder03: Verificado: 'Actualmente permite poner NO en MDVR y cargar el numero de ID MDVR'. Fix: MDVR=NO must not accept an ID MDVR (form + server validation).
-
cleared: Esperando a Eugenia: el libro dice MDVR = NO en 403 filas que el mismo libro trae con camaras_internas o id_mdvr distinto de cero. Contradiccion interna del SSOT, vuelve a su autora. No se deriva SI sobre un NO explicito mientras tanto.
-
coder04-mba-l-ca / coder
-
coder04-mba-l-ca | 2026-10-05 13:56 ART. Current alta form measurement: ipMdvr is disabled when mdvrId is not SI, but handleInputChange does not clear ipMdvr when mdvrId changes, and handleSubmit only clears ADAS dependents. Service createColectivo validates ipMdvr only for MDVR=SI; a direct action payload with canonical NO plus a nonblank ID is accepted by this validation. The canonical NO/SI lookup is already resolved via general/respuesta_binaria. Scope is new manual Alta validation; no importer/history rewrite, preserving the SSOT contradictions already measured. Will implement form clear and explicit server rejection after MOVILBA-46 audit frees the shared service file.
-
coder04-mba-l-ca | 2026-10-05 14:04 ART. Implemented the manual Alta rule: when MDVR changes away from canonical SI, the form clears ipMdvr; createColectivo rejects any nonblank ipMdvr when the qualified general/respuesta_binaria option resolves to NO. Added a negative regression through the create action proving validation fails before any write. Scope is the Alta form/service and its tool test; imported/history values and edit of existing vehicles remain untouched. Did not run gates per workflow.
-
audit pass: 3 files: page.tsx, vehiculos.ts, colectivo-expediente.test.cjs
payload
{"scope":"3 files: page.tsx, vehiculos.ts, colectivo-expediente.test.cjs","outcome":"pass","evidence":"test:18/18 pass incl new negative test, eslint clean, tsc clean","reportRef":null} -
coder04-mba-l-ca | 2026-10-05 14:08 ART. coder03 shipped v5.6.158 to PROD and DEV after audit PASS; pod mirror is assigned to proxy-mba-w-cc and remains pending. Keep open until the pod reports patch 158.
-
Manual Alta fix shipped in v5.6.158 and superseded by fleet patch 200: selecting MDVR=NO clears ID MDVR in the form; createColectivo rejects a nonblank ID with canonical NO. Audit PASS 2026-10-05T17:05:13Z on form/service/test. This does not rewrite the 403 contradictory SSOT rows (MDVR=NO with cameras or ID): Eugenia must correct the source; imported values are preserved/reported, not derived to SI.