...
Release 2022.1.1 [April 2022]
Features to Complete
- None
Features to Consider
- Add state to the available filters
Features Ready for Release
- Include the inactive program codes (Remove code: AND p.Program_Status_Code='A') both on the Term and the AY procedure
- Adjust the billing_program_code to remove the duplicate program code
- Use RTRIM to remove the blank spaces
- Removed the duplicate PID in term: 20183, AUAUL, HEGIS_Program_Code - (Note: Removed the SPS_Program, HEGIS_Program_Code from the top part of the code and added them at the bottom to correct it.)
- 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
Features Ready for Release
- Include the inactive program codes (Remove code: AND p.Program_Status_Code='A') both on the Term and the AY procedure
- Adjust the billing_program_code to remove the duplicate program code
- Use RTRIM to remove the blank spaces
- Removed the duplicate PID in term: 20183, AUAUL, HEGIS_Program_Code - (Note: Removed the SPS_Program, HEGIS_Program_Code from the top part of the code and added them at the bottom to correct it.)Added a function on a2_hist_enrl_u46_ay to calculate the Academic_Year dynamically. (Academic_Year=dbo.getAcademicYear(t1.Term_Identifier)) – commented the hardcoded codes
Previous Cycles
Release 2022.1.0 [January 2022]
...