Report Title Report Name or Query Name Report Type Data
Source
Business Process Reporting Area
Student Enrollment Appointments UCCS_R_ENRL_APPOINTMENTS PS Query   Enroll Students Enroll Students
 

Query Name: UCCS_R_ENRL_APPOINTMENTS
Report Title: Student Enrollment Appointments
Purpose: Reporting on enrollment appointments assigned to a student or specified groups of students.
Description:

Rows: One row per term-activated student, per academic plan, per enrollment appointment.
Term-activated student with no appointment have blank values in appointment columns.

Columns: Student ID, name, and e-mail address; Term; Eligible to enroll flag; Advising hold Y/N; Enrolled Y/N; Other Enrollment

Holds Y/N; Acad Plan; CPP detail drilldown; Appointment Start date and time; Appointment end date and time; Appointment limits

Drilldowns: Advising Hold Y/N drills to audit data for ADV hold if any (UCCS_R_SI_AUDIT)
Other Enrollment Hold Y/N drills to all current service indicators for ID and term (UCCS_R_SI_BY_ID_TERM)
Enrolled Y/N drills to current enrollments for ID and term (UCCS_R_ENRL_BY_ID_AND_TERM)
CPP Detail drills to current CPP stack data (UCCS_R_CPP_ACTIVE_BY_ID)

Required Prompts: Term; Current or Future appts only (default Y); Include students w/ no appt (default Y); Institution (default UCB01)

Optional Prompts: Career, College/School, Dept, Acad Plan, Student Group, ID

Records used: STDNT_CAR_TERM, SCC_PRI_NAME_VW; STDNT_ENRL_APPT; APPOINTMENT_TBL; SRVC_IND_DATA; SRVC_IND_DATA; SERVICE_IMPACT; SCC_EMAIL_QVW; STDNT_ENRL; ACAD_PROG; ACAD_PLAN; TERM_TBL; UC_ACDPLN_H_VW; STDNT_GRPS_HIST

Report Inventory ID: UCCS_R_1194

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