Technical Details

Current Release Version: 2023.1.0

Release Date: 1/18/2023

Crystal Report Name: 

SQL Stored Procedure: a1_gpa_grades_v2023

Report Location on Crystal CMC: SPS - School of Professional Studies / Registration Management

(1) a1_gpa_grades_v2023_gpa (2) a1_gpa_grades_v2023_inc_grades (3) a1_gpa_grades_v2023_missing_grades

Security Roles: ADCU Security Groups - Grouper Group

Report Location on H in MS Excel:

H:\Systems and Data Analysis\SPS Analytics\Degree Programs\zzAcademic Program Review\Student Support\Grades

Requested Features

Current Cycle

Release 2022.1.1 [March 2023]

Features to Complete

• Not started

Features to Consider

• Not started

Features Ready for Release

• None

Previous Cycles

Release 2023.1.0 [January 2023]

_output

                  = gpa -- SPS student's GPA for the recent three terms
                 = missing_grades-- a list of students whose grades are missing
                 = inc_grades-- a list of students whose grades are incomplete

Report Fields List:

@_output = 'gpa'

Person_ID_Number
Person_Last_Name
Person_First_Name
UNI
Term_Identifier
Term
Billing_Program_Code
Program_Description
Degree_Code
Term_Points_Registered
Term_Points_Completed
Term_GPA
Total_Points_Registered
Total_Points_Completed
Cumulative_GPA
Academic_Action

--------------------------------------------------------------------------------------------

@_output = 'inc_grades' or missing_grades

Person_ID_Number
Person_Last_Name
Person_First_Name
UNI
Billing_Program_Code
Program_Description
TSTA_School_Code
Total_INC_Grades
Term_Identifier
Term
School_Bulletin_Prefix_Code
Subterm_Code
Course_Number
Section_Code
Course_Identifier
Class_Name
Instructional_Level_Code
Course_Subject_Code
Credits_Awarded_Count
Grading_System_Code
Final_Grade_Code
Completion_Status_Code
Instructor_ID_Number
Instructor_Last_Name
Instructor_First_Name
Instructor_Full_Name
Instructor_UNI
Instructor_CU_Email
Instructor_Actual_Email
Instructor_Actual_Email(1)
School_Type
Faculty_Code
CLAS_School_Code
Academic_Action