Technical Details

Current Release Version: 2021.1.0

Release Date: 1/1/2021

Crystal Report Name: a1_student_course_data_v11

SQL Stored Procedure: a1_student_course_data_v11

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

Security Roles: ADCU Security Groups - Grouper Group

Report Location on H in MS Excel:

H:\Systems and Data Analysis\SPS Analytics\Degree Programs

H:\Systems and Data Analysis\SPS Analytics\Nondegree Programs

H:\Systems and Data Analysis\SPS Analytics\SPS All Programs

Requested Features

Current Cycle

Release 2022.1.1 [April 2022]

Features to Complete

• Not started

Features to Consider

• Not started

Features Ready for Release

• added a line [AND aprg.Program_Code=c.Billing_Program_Code] to remove the duplicated graduation date
• File saved as Z:\System Folders\Stored Procedure\mji3\a1_student_course_data_v11_bak_11_14_2022

Previous Cycles

Release 2021.1.0 [January 2021]

Report Fields List:

Billing_Program_Code
Person_ID_Number
UNI
Person_Last_Name
Person_First_Name
Email
CU_Email
UNI_Email
Term_Identifier
Course_Identifier
Instructor_Last_Name
Instructor_First_Name
Section_Code
Subterm_Code
Subject_Area_Code
Format
Class_Name
School_Bulletin_Prefix_Code
Student_Status_Code
Admission_Term_ID
Age
City
State
Country
Citizenship_Country
Visa_Type_Code
Zip_Code
Course_Credits_Awarded
Course_Credits_Attempted
gpatotal
gpaterm
Final_Grade_Code
Term_Credits_Awarded
Term_Credits_Attempted
Graduation_Date