...
- Update the a2_hist_enrl_u46_ay procedure - (Note: Removed the SPS_Program, HEGIS_Program_Code from the top part of the code and added them at the bottom with pgrm.HEGIS_Program_Code to correct it.)
- Created a Function, named it dbo.getAcademicYear to obtain the Academic Year dynamically, and updated it in the code. The field name is Academic_Year
- Added AY21 to the a2_hist_enrl_blt_ld_u46_ay and rebuilt the table
- Removed AY21 from the a2_hist_enrl_cur_ld_u46_ay stored procedure
- Added AY23 to the a2_hist_enrl_cur_ld_u46_ay stored procedure
Features to Consider
- Add state to the available filters
...