Technical Details

Current Release Version: 2023.1.0

Release Date: 31 Jan 2023

Crystal Report Name: a1_reg_summary_v2022

Crystal Report Name: a1_reg_summary_v2023

SQL Stored Procedure: a1_reg_summary_v2022

SQL Stored Procedure: a1_reg_summary_v2023

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 2023.1.1 [April 2023]

Features to Complete

• Not started

Features to Consider

• Not started

Features Ready for Release

• None

Previous Cycles

Release 2023.1. [January 2023]

Added the Application_ID_Number to the SQL Stored Procedure: a1_reg_summary_v2023

Release 2022.1.0 [January 2022]

RMS report field list

Term
Degree_Description
Program_Name
Billing_Program_Code
CUID
UNI
Person_Last_Name
Person_First_Name
Admission_Term_ID
Cohort_Status
Registration_Status
Cumulative_Attempted_Credits_SPS
Cumulative_Earned_Credits_SPS
Cumulative_Attempted_Credits_SPS_Program
Cumulative_Earned_Credits_SPS_Program
In_Process_Credits
Term_Credits_Registered_So_Far_NW
CU_Email
Email
Age
Gender_Code
Residency_Country_Code
Visa_Type_Code
Citizenship_Country
Street_Name
Street_Name_2
City
State
Country
Zip_Code
Day_Phone
Local_Day_Phone
Immunization_Hold
Other_Hold_Code
Other_Hold
SP_LOA_Hold
SP_Withdrawal_Hold
SP_Advising_Hold
SP_Admissions_Hold
Hold_Modification_Date
Registration_Transaction_Date
Cummulative_GPA
Graduation_Application_Status
Expected_Graduation_Term_ID
Pool_Code
School_Code
Applicant_Housing_Request_Flag