Technical Details

Current Release Version: 2022.1.0

Release Date: 28 Jan 2022

Report Location: PowerBi / Apps / SPS Enrollment

Security Roles: Security Roles: Leadership, Admissions, and Enrollment

Requested

...

Add state to the available filters
SQL ONLY: update the Academic_Year in the storeced stored procedures (1) a2_hist_enrl_cur_ld_u46_ay (2) a2_hist_enrl_blt_ld_u46_ay (REPEAT THIS PROCESS IN EVERY VERSION UPDATE)

This version of the Historical Enrollment report uses the vw_sps_enrollment table. The procedure name is a2_hist_enrl_pbi.sql
There are two blocks of codes in the a2_hist_enrl_pbi.sql procedure.
(1) Historical Enrollment by Term
- Enrolled students count only once in a term
(2) Historical Enrollment by Academic Year
- Academic Year = Fall of Current Year and Spring and Summer of the next year (for example, AY21 = fa20, sp21, su21)
- For the MS and MPS programs, students count only once within the Academic Year. In case if a student changes the modality or program with the Academic Year, we check the Max_Term in that Academic Year and select the Program_Code, Degree_Code, and School Code from that Max_Term. For example, If a student is in SPSUMA in Fa21, and SPSUSC in Sp22, then the student is considered a student in SPSUSC.
- For the MS and MPS programs credits, sum the Max_Credits within the Academic Year
- For NW/CN, If a student is NW in an Academic Year, then the student is counted as NW, otherwise CN.
The first start term id is 20102 (Fa10)

...