Identidad de modelo para AGRALE MT 17: cual de los ids 123, 143 y 135 describe el modelo del libro, con fuente de fabricante

Sub-tickets

Activity

• coder03-mba-l-cc created · 1w ago
  parent=#4538
• researcher-mba-l-cc statusChanged · 1w ago
  researcher-mba-l-cc 21:22:44Z. Split from 728. Requested the public.chasis row content (fabricante, modelo, PBT, distinguishing columns) for chasis_id 123, 135, 143 in both bases from db03 at 21:16:58Z (no DB credential here) - that request covers this item's data need, not re-sending. Waiting on db03's reply before researching manufacturer identity per-id.
• researcher-mba-l-cc note · 1w ago
  2026-10-08T18:26:17-03:00 / 21:26:17Z researcher-mba-l-cc. Identity research, catalog rows from db03's DM (21:25Z): PROD 123='MT 17.0 LE GNV'/AGRALE, 135='MT 17'/AGRALE, 143='K 250 B 4X2'/SCANIA. DEV 123='MT 17.0 LE GNV', 143='MT 17'/AGRALE, 135 absent. public.chasis has no PBT/largo column to distinguish on - only chasis_modelo, fabricante_id, id. FIRST: PROD-143 (SCANIA K 250 B 4X2) is NOT part of the AGRALE question - it is pure id-number reuse across bases, unrelated chassis, different manufacturer. The actual pair in dispute is PROD-135 vs DEV-143, both 'MT 17'/AGRALE. RESEARCH (agrale.com.br ficha tecnica, pdf.agrale.com.br/2019/ficha-tecnica, 16valvulas.com.ar GNC launch coverage): Agrale's bus-chassis line has NO standalone SKU named plain 'MT 17'. The official designations are MT 17.0 LE (diesel, MAXXFORCE 7.2), MT 17.0 LE GNV (gas, FPT Cursor 8), and MT 17.0 LEe (electric) - all one 12m/17t Low Entry chassis family distinguished only by propulsion. This matches what's already documented in docs/reference/chasis-equivalencias.md for ids 123/127/129 (GNV/LE/LEe). CONCLUSION: 'MT 17' (bare, no suffix) at PROD-135 and DEV-143 is not a distinct chassis model - it is a truncated/abbreviated book designation of the same MT 17.0 LE family already cataloged. No manufacturer source supports it as an independent identity. These are not two competing models to pick between; they're the same abbreviation, independently catalogued once per base. NOT RESOLVED by this research, and outside what catalog-table research can answer: WHICH specific variant (123 GNV / 127 LE / 129 LEe) each 'MT 17' row's referencing vehicle rows actually mean - that depends on unidad_propulsora_id on the historial/resolver rows pointing at chasis_id 135 (PROD) / 143 (DEV), which public.chasis itself does not carry. Handing that lookup to whoever has resolver access (db03/731's scope) rather than guessing: if propulsion resolves cleanly to one of 123/127/129, 'MT 17' folds into that id as an alias and the bare row retires; if a referencing row's propulsion is itself ambiguous or undocumented in the book, that specific row goes to Eugenia, not the model identity question - the identity question (is 'MT 17' a real separate model) is answered NO.
• researcher-mba-l-cc note · 1w ago
  2026-10-08T18:26:42-03:00 / 21:26:42Z researcher-mba-l-cc. Direct answer to the rewritten question (model, not id): ONE chassis model, 'MT 17.0 LE' (Agrale, 12m/17t Low Entry), with GNV marking a GENUINE distinct variant - different engine entirely (MAXXFORCE 7.2 diesel vs FPT Cursor 8 gas, different displacement/power/torque), not a cosmetic suffix. This matches the terna rule already: fabricante+modelo+unidad_propulsora_id is exactly how LE/LE GNV/LEe are meant to separate (124 vs 157 pattern already documented for Scania K280, chasis-equivalencias.md:16). Bare 'MT 17' (PROD-135, DEV-143) is neither the LE nor the GNV variant on its own - it's a truncated book designation of the same family, missing its propulsion suffix. No manufacturer source names a standalone 'MT 17' SKU. Proposal: fold bare 'MT 17' into whichever of 123/127/129 matches the unidad_propulsora_id its referencing historial rows actually carry (db03/728's lookup, not mine - chasis table itself carries no propulsion). PROD-143 (SCANIA) stays irrelevant to this question, pure id-reuse coincidence across bases.
• researcher-mba-l-cc completed · 1w ago
  Closed - identity answered: one Agrale MT 17.0 LE chassis family, GNV a genuine distinct variant (different engine), bare 'MT 17' a truncated designation of the same family not a standalone model, PROD-143/SCANIA pure id-reuse coincidence. See notes 21:26:17Z/21:26:42Z for full research.
• researcher-mba-l-cc note · 1w ago
  2026-10-08T18:45:50-03:00 / 21:45:50Z researcher-mba-l-cc. CORRECTION per coder03/db03's review: my closing note's claim that PROD chasis_id 143 (SCANIA K 250 B 4X2) and DEV's id 143 (AGRALE "MT 17") were "pure cross-base id-number-reuse coincidence, unrelated to the AGRALE question" is WRONG in its SCANIA half. SCANIA K 250 B 4X2 exists in BOTH bases, referenced on both sides - PROD id 143, DEV id 146 (not a coincidental one-sided id reuse at all; it's a real chasis present in both, just under different ids). The AGRALE identity conclusion this item closed on is UNCHANGED: AGRALE has no standalone "MT 17" SKU, the family is MT 17.0 LE/LE GNV/LEe distinguished by unidad_propulsora_id, bare "MT 17" is a truncated designation of that family. Only the SCANIA aside, which was never load-bearing for that conclusion, was wrong.