...
Features Ready for Release
Previous Cycles
Release 2022.1.0 [January 2022]
- 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
- Added a function on a2_hist_enrl_u46_ay to calculate the Academic_Year dynamically. (Academic_Year=dbo.getAcademicYear(t1.Term_Identifier)) – commented on the hardcoded codes
- SQL Only: Added the ipeds.IPEDS_Long_Name field and joined the IPEDS_DEMO_DEMOGRAPHICS view to the a2_hist_enrl_u46_ay.
Previous Cycles
...
- .
...
- Cosmetic updates to bring the report in line with the latest SPS design standard
- Set the Banner size to W=1280 H=85 and color = #162A53 on all pages
- Set the Columbia SPS Logo to Width = 300 and Height = 85 on all pages
- Info Image set to Width = 75, Height = 50 and Y Position = 12
- Infor version text Width = 75, Height = 30 and Y Position = 55
- Report title Width = 500, Height = 75 and Y position = 12
- Remove the Slicers from the report pages and add them to the Filters pane
- After the design completion, publish the report on adcudev and test
- Compare data with the adcudev report and adcu PROD report.
...