Academic Advising Queries

Student Records – Queries

UNLVSR_SC_CLASS_ROSTER

Class Roster with email and phone.

NLVSR_SC_COURSE_ROSTER

Course Roster with email and phone.

NLVSR_UGRD_APPLIED_GRDTN_COLL

Applied for graduation by college.

NLVSR_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.

NLVSR_UGRD_DEPT_CHKLST_ALL

Graduation Checklist status.

General Queries

UNLVAA_TRNS_COLLEGE_BY_PLAN

Students with Transfer Credit. This lists their Transfer schools and contact info. This is by the Students Plan (Major or Minor)

NLVAA_ENRL_PER_STDNT_TERM

Student Enrollment information by Student and Term.

NLVAA_ACTIVE_ENR_TERM_COLLEGE

Active and Enrolled student by Term sorted by Dept* You must choose a College or you will get no results

NLVAA_GRADE_ROSTER_COURSE

Grade Roster for a course by Section

NLVET_CLASS_ROSTER_GRADES

Grade Roster by class. Each one gives different information.

UNLVET_CLASS_ROSTER_GRADES1

Grade Roster by class. Each one gives different information.

UNLVET_CLASS_ROSTER_GRADES2

Grade Roster by class. Each one gives different information.

NLVAA_ADMIT_TERM_ENRL_TERM

Students admitted in x term are they enrolled in y term. You input the enrollment term and admit term.

NLVAA_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

NLVAA_CHCKLIST_TOTALS_BY_DATE

Totals for a Checklist by date range

NLVAA_CHK_ITEMS_CENTER_DATE

Total of Checklist Items by Center and Date

NLVAA_CHK_ITMS_CNTR_DATE_ADV

Total of Checklist Items by Center, Date, and Advisor

NLVAA_ADVISORS_STUDENTS

All of the appointments (checklists) by a given advisor within a date range.