...
- 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 the 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 from the Billing and Academic credits in that Academic Year.
- For NW/CN, If a student is NW in an Academic Year, then the student is counted as NW, otherwise CN.
- For NDG, CER, and CPF, if a student enrolled in one program in the fall, and then enrolled in another program in the spring then the student will be counted twice. For example, if a student enrolled in fa21 with SPNDGV, in sp22 with SPBUSS, and in su22 with SSUSP then the student will be counted three times. The credits will sum from the separate program.
...