MARS-138 ·
marsgetJtpStats 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
Questions
No questions.
Event log
-
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.
-
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.