...
Release Date: 1/18/2023
Crystal Report Name: (1) a1_gpa_grades_v2023_gpa (2) a1_gpa_grades_v2023_inc_grades (3) a1_gpa_grades_v2023_missing_grades
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
...
= 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
School_Code
Total_INC_Grades
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_IdentifierNumber
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