▣ wi

getJtpStats PENDING axis is SA-populated while admin-delta-report + vPracticasSinEvaluar are SA-free — informes oracle can miss a picked-but-no-active-SA práctica

Ref

MARS-138 (#1133)

Project

mars

Status

backlog

Priority

low

Type

task

Assigned

— coder

Created by

wi-cli-venus

Created

2026-06-16T06:55:18.741Z

Updated

2026-06-16T06:55:18.741Z

Sub-items

Questions

Event log

• 2026-06-16T06:55:18.741Z · created · wi-cli-venus
• 2026-06-16T06:55:29.504Z · commented · wi-cli-venus
  MARS-136 follow-up (post-S3, conscious-not-silent per PM). getJtpStats PENDING axis drives scoped_practicas FROM studentAssignments JOIN practicas, so it only counts pending prácticas that still have an active SA row for the picker. admin-delta-report.ts jtp_pra CTE + vPracticasSinEvaluar are SA-free (drive FROM practicas on jtpUserId). Current incidence ZERO: 263=263 across both bases at S1 push. Risk: a future práctica picked by someone with no active SA in that comisión (e.g. ayudante-picked-as-JTP whose SA lapses, or a not-in-TCM picker) would be counted by admin-delta/vPracticasSinEvaluar but MISSED by the getJtpStats informes tile — silent under-count on the informes oracle. Fix: drive getJtpStats scoped_practicas FROM practicas (not SA), keeping the SA roster CTE for studentCount only. Deferred from S1 deliberately (reopening the perf-proven scoped_practicas basis = scope creep). Linked: MARS-137 (orphaned-pending reassign + a-solucionar surfacing). Do NOT fix without re-perf-checking the informes query.
• 2026-06-16T06:55:37.961Z · commented · wi-cli-venus
  Folded in (PM-approved #3): Titular 'Prácticas asignadas' tile sums pick-attributed prácticas, which EXCLUDES the 2/1324 null-pick prácticas (both already graded), while getJtpStats GRADED (reviewedBy) counts them. Same cross-surface population-basis family — resolve together when getJtpStats is rebased onto practicas.