Technical Details
Current Release Version: 20232024.1.1
Release Date: 30 Aug
Report Location: PowerBI / Apps / SPS Enrollment
...
Requested Features
Current Cycle
Release
...
2025.1.
...
0 [
...
January 2025]
Features to Complete
- None
Features to Consider
...
Features Ready for Release
- None
...
- SQL Only - added vw_sps_enrollment local table for speed on #tmp_term_tbl
Previous Cycles
Release 2024.1.0 [December 2024]
- Change the Cohort_Status field name to Student_Status in the stored procedure and the Power BI report
- Change the Country_Description field name to Citizenship_Country in the stored procedure and the Power BI report
Release 2024.1.0 [December 2024]
- Showing blank data on the Fa23 term
Release 2023.1.1 [August 2023]
- Add the completed credits for each PID so the report can filter out students who have completed more or less than a certain number.
- Renamed the filter name from "Grad Application Status." to "Request for Conferral"
- Added a new filter named 'Total Credits Earned"
- SQL Only:Temp Table names:
* 1. #tmp_term_tbl - Getting the latest three Term IDs from the took table
* 2. #tmp_sps_enrollment - Getting PIDs, total Academic_Credits and total Billing_Credits from the latest three terms
* 3. #tmp_registered_students - Getting the student list from the STUD table for three terms (Spring, Summer, and Fall)
* 4. #tmp_stud_holds - Getting the students HOLDs information
* 5. #final_holds - Consolidate the holds into one row per student
* 6. #tmp_u_target - Getting the data from the u_target table for the latest three terms
* 7. #student_credits_prg - Credit calculation from TOOK table
* 8. #tmp_final - Joining the tables for the final output
*
Release 2023.1.0 [July 2023]
...