Report Title Report Name or Query Name Report Type Data
Source
Business Process Reporting Area
Active CPP Data by ID and Term UCCS_R_CPP_ACTIVE_BY_ID PS Query   Enroll Students Enroll Students
 

Query Name: UCCS_R_CPP_ACTIVE_BY_ID
Report Title: Active CPP Data by ID and Term
Purpose: View currently active CPP stack (career, program, plan) data for a specified ID and term.
Description:

Rows: One row per active program/plan stack row (most recent effective date) for specified ID and term.

Columns: ID, Name, Term, Career Number, Effective date, Status, Career, Program, Plan, Plan Description, Plan Type, Plan Degree, Degree Description, Last program action, Last action date, Last action reason, Admit term, Expected graduation term, Degree checkout status

Required prompts: Term, ID

Report inventory ID: UCCS_R_1201

User Access Group: Role Not Defined
Process: Enroll Students
Usage Notes:  Uses row-level security for academic career and academic plan. Report will only return data for rows user has permission for.
Report Elements: For description of elements visit the Custom Fields Table