Academic Advising Queries
Student Records – Queries
UNLVSR_SC_CLASS_ROSTER
Class Roster with email and phone.
UNLVSR_SC_COURSE_ROSTER
Course Roster with email and phone.
UNLVSR_UGRD_APPLIED_GRDTN_COLL
Applied for graduation by college.
UNLVSR_UGRD_DNGR_BY_COLL
Shows DNGR, Did Not Graduate, by College.
Student Records – Graduation Process Queries
UNLVSR_UGRD_APPLIED_GRDTN_COLL
Students who Applied for Graduation, by College.
UNLVSR_UGRD_DEPT_CHKLST_ALL
Graduation Checklist status.
General Queries
UNLVAA_TRNS_COLLEGE_BY_PLAN
Students with Tranfer Credit this lists their Transfer schools and contact info. This is by the Students Plan (Major or Minor)
UNLVAA_ENRL_PER_STDNT_TERM
Student Enrollment information by Student and Term.
UNLVAA_ACTIVE_ENR_TERM_COLLEGE
Active and Enrolled student by Term sorted by Dept
* You must choose a College or you will get no results
UNLVAA_GRADE_ROSTER_COURSE
Grade Roster for a course by Section
UNLVET_CLASS_ROSTER_GRADES
UNLVET_CLASS_ROSTER_GRADES1
UNLVET_CLASS_ROSTER_GRADES2
Grade Roster by class. Each one gives different information.
UNLVAA_ADMIT_TERM_ENRL_TERM
Students admitted in x term are they enrolled in y term. You input the enrollment term and admit term.
UNLVAA_CLASS_COURSE_PERM
All course & class permissions for a given student and term
Checklist-Related Queries
UNLVAA_CHK_ITEMS_USED_TOTAL
Total of Checklist items Used
UNLVAA_CHCKLIST_TOTALS_BY_DATE
Totals for a Checklist by date range
UNLVAA_CHK_ITEMS_CENTER_DATE
Total of Checklist Items by Center and Date
UNLVAA_CHK_ITMS_CNTR_DATE_ADV
Total of Checklist Items by Center, Date, and Advisor
UNLVAA_ADVISORS_STUDENTS
All of the appointments (checklists) by a given advisor within a date range.
