Student Records Query List

Student Financials - Special Fees

UNLVSF_SPECFEES_ACADORG

Special Fees by Academic Org

UNLVSF_SPECFEES_SUBJECT

Special Fees by Subject

UNLVSF_SPECFEES_TERM

Special Fees by Term – ALL

General Queries

UNLVSR_ENRL_ATTEMPT_CLOSED_SBJ

(Prompts for Term and Subject and then returns a count of attempted enrollment after a class is full.)

UNLVSR_ENRL_ATTEMPT_CLOSED_GRP

(Prompts for Institution, Term, and Academic Group (College Code) and then returns a count of attempted enrollment after a class is full.)

UNLVSR_SCHEDULE_BY_COLLEGE

Class Schedule by College

UNLVSR_SCHEDULE_BY_SUBJECT

Class Schedule by Subject (keep in mind that some subjects are owned by different departments (AcadOrg) and may not appear in the results)

UNLVSR_SCHEDULE_BY_ACADORG

Class Schedule by Academic Org (this may be the best query to run if your department has multiple subjects)

UNLVSR_SC_CLASS_ROSTER

Class Roster w/ Email, Phone

UNLVSR_SC_SCHEDULE_BY_COLLEGE

Shortened Schedule by College

UNLVSR_SC_SCHEDULE_BY_SUBJECT

Shortened Schedule by Subject (keep in mind that some subjects are owned by different departments (AcadOrg) and may not appear in the results)

UNLVSR_SC_SCHEDULE_BY_ACADORG

Shortened Schedule by AcadOrg (this may be the best query to run if your department has multiple subjects)

UNLVSR_STDNT_GRP_CLASS_SCHED

(Prompt for Institution, Term, and Student Group code and returns a list of students and the classes they are taking.)