Analytics Field Value Indicator — Automatically Populate Threshold Options for School-Based Fields Such as STU.CU
What is happening now:
The Field Value Analytics Indicator type requires threshold values to be manually added to the Update Code Table (Table/Field at School = 0) before they appear in the threshold dropdown. For fields like STU.CU (Counselor Number), which reference school-based teacher numbers (TCH.TN), this means districts must manually enter each teacher number as a district-level code entry before the indicator can be configured. There is no automatic resolution from the Teacher (TCH) table.
Why this matters:
STU.CU is populated dynamically from TCH in all other areas of Aeries, so districts do not expect to need a separate manual setup step in Analytics. Additionally, teacher numbers are school-scoped and not unique district-wide, meaning the same number can belong to different staff members at different schools. A single district-level COD entry cannot accurately represent both, making the workaround unreliable in districts where teacher numbers are shared across schools.
Impact if unchanged:
Districts cannot build counselor-based Analytics dashboards without a manual workaround that carries data integrity risk. Districts with duplicate teacher numbers across schools have no reliable path to configure this indicator at all.
AdminPriscilla Huerta
(Admin, Aeries Software)
shared this idea
