Report Title Report Name or Query Name Report Type Data
Source
Business Process Reporting Area
Current Service Indicators UCCS_R_SI_CURRENT PS Query   Enroll Students Enroll Students
 

Query Name: UCCS_R_SI_CURRENT
Report Title: Current Service Indicators
Purpose: Reporting on service indicators for term-activated students.
Description:

Rows: One row per term-activated student, per service indicator currently in effect.

Columns: Term, ID, Name, Email, Service Indicator Code, SI Description, SI Reason, Service Impacts, CPP drilldown, Enrollment drilldown, Appointments drilldown

Drilldowns: Service indicator code column: Drills to UCCS_R_SI_AUDIT for selected ID and service indicator code (shows audit history for service indicator)
"Drill to CPP" column: Drills to UCCS_R_CPP_ACTIVE_BY_ID for ID and term (shows current CPP stack information)
"Drill to Enrollment" column: Drills to UCCS_R_ENRL_BY_ID_AND_TERM for ID and term (shows current enrollments)
"Drill to Appointments" column: Drills to UCCS_R_ENRL_APPOINTMENTS for ID and term (shows current enrollment appointments)

Required prompts: Term

Optional prompts: Include positive service indicators (Y/N); Career: College/School; Department; Academic Plan; Student Group; ID; Service Indicator; Service Indicator Reason; Service Impact

Report Inventory ID: UCCS_R_1195

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 to see.
Report Elements: For description of elements visit the Custom Fields Table