State Reporting 24.10.3.0 Release Notes

PSSR-358012

Query Optimization to improve performance

To optimize system performance, certain database updates were made to replace virtual tables with actual tables.

PSSR-358239

Ed-Fi: Performance Upgrades for Staff Resources

Optimized the staging and publishing queries to potentially enhance the performance of processing the following resources:

• Staff Section Associations

• Staff Education Organization Employment Associations

• Staff Education Organization Assignment Associations

• Staff Education Organization Contact Associations

• Staff School Associations

• Staff Records

PSSR-357780

Ed-Fi: Performance Upgrades for Student Resources

Optimized the staging and publishing queries to potentially enhance the performance of processing the following student resources:

• student

• studentschoolassociation

• studentSectionAssociations

• disciplineIncidents

PSSR-358011

TN Ed-Fi - Performance upgrades in Student Program resources

Virtual tables have been replaced with actual tables in certain program association resources, enhancing data reliability. To simplify and improve data management, the following resources have been made inactive since they seem to be part of the base framework but not in use for TN Ed Fi.

• Student Program Associations

• Student Title I Part A Program Associations

• Student CTE Program Associations

• Student Language Instruction Program Associations

• Student Migrant Education Program Associations

• Student School Food Service Program Associations

PSSR-357781

Ed-Fi: Remove CST_PUBWORKFLOW_LIB Function

Removed CST_PUBWORKFLOW_LIB Function for the following descriptors that do not have code set mapping:

1. sexDescriptors

2. raceDescriptors

3. disciplineIncidentParticipationcodeDescriptors