• Faculty Reports can be found through Main Menu > Faculty Reports. Access to all of these reports is limited to faculty/advisors, chairs, deans, and their secretaries or administrative staff.


Available Reports

Search parameters that are required are in bold; others are optional.


Report Name
Query Name
Description
Search Parameters
Fields Returned
Advisement Holds Released
PZFC_ADVISEMENT_UNBLOCKED
The “Advisor Registration Block (RAB)” service
indicator is a hold put on a student’s account that prevents them from enrolling in classes until it’s removed by their advisor (or someone with the appropriate authorization).
 This query/report returns a list of advisees that have had their Advisor Registration Block (RAB) service indicator removed from their account for the term specified.
  • Term
  • Advisor’s emplid
  • Student’s emplid
  • Student’s name
  • Primary acad. prog
  • Acad plan
  • Class rank
  • Schedule credits
  • Total credits
  • Test & transfer credits
  • Total GPA
  • Service Indicator description
  • Service Indicator removal date & time
  • Emplid that removed the Service Indicator
  • Advisor(s) name
  • Advisor(s) email
Advisement Holds on Students
PZFC_ADVISEMENT_BLOCKED
This report is similar to the Advisement Holds Released query, except this shows who has the RAB service indicator on their account for the term specified.
  • Term
  • Advisor’s emplid
  • Student’s emplid
  • Student’s email
  • Student’s name
  • Acad plan
  • Primary acad. prog
  • Class rank
  • Schedule credits
  • Total credits
  • Test & transfer credits
  • Total GPA
  • Service Indicator description
  • Service Indicator date & time
  •  Emplid that assignedService Indicator
  • Advisor(s) name
  • Advisor(s) email
Advisement Notes    
PZFC_ADVISEMENT_NOTES
Returns a list of notes between the student and advisor. A “Visible to Student” column indicates whether the advisor’s note can be viewed by the
 student in Student Center (via the Advisement Notes option in the Academics dropdown).
  • Student’s emplid
  • Student’s emplid
  • Student’s email
  • Student’s name
  • College
  • Acad plan
  • Class rank
  • Advisor(s) name
  • Advisor(s) email
  • Note’s date & time
  • Note’s author
Advisor's Advisees
PZFC_VIEW_ADVISOR_ADVISEES
Returns a list of advisees for a term. If the student has a registration appointment for the advising term specified, information about that will be displayed as well.
  • Advisor’s emplid
  • Term
  • Acad prog
  • Acad plan
  • Advising term
  • Student’s emplid
  • Student’s email
  • Student’s name
  • Sex
  • Acad prog
  • Acad plan
  • Career
  • Class rank
  • Scheduled credits
  • Total credits
  • Total & test credits
  • Total GPA
  • Req term
  • Academic plan description
  • Advisor name
  • Advisor department
  • Eff date
Check Lecture/Lab Enrollment
PZFC_LEC_LAB_ENR_CHECKER
Gets a list of student emplids where the student is enrolled in the lecture component of a course, but not its lab component. Returns the class with the 3- letter subject code, catalog number, and section
 number.
  • Term
  • Student emplid
  • Student name
  • Class
Class Enrollment List
PZFC_R014_CLASS_ENRL_LIST
Returns a list of students in a course, including add and drops. Student tuition/residency (O= Out of State, I = In-State, F= Foreign) is also indicated.
  • Academic Institution
  • Term
  • Subject Area
  • Catalog Number
  • Class Section
  • Student emplid
  • Student email
  • Student’s name
  • Enrollment reason
  • Add date
  • Drop date
  • Subject
  • Catalog number
  • Instructor name
  • Tuition
College of Education Candidacy
PZFC_COECANDIDACY
Primarily for College of Education. Returns a list of students if they pass certain ENG courses, PRAXIS, and PAPA exams.
  • Term
  • Student’s emplid
  • Student’s email
  • Student’s name
  • Home address
  • Campus address
  • Acad plan
  • Scheduled credits
  • Total credits
  • Total GPA
  • Passed ENG010
  • Passed ENG023/025
  • Passed another ENG course
  • Total MAT credits
  • Praxis Reading score
  • Praxis Writing score
  • Praxis Composite score
  • PAPA Reading score
  • PAPA Math score
  • PAPA Writing score
  • PAPA Composite score
Course Drops by Instructor
PZFC_CRSE_DROPS_BY_INSTR_TERM
Displays a list of students that dropped a course for the instructor specified.
  • Instructor’s last name
  • Term
  • College
  • Instructor name
  • Class number
  • Student emplid
  • Student name
  • Drop code
  • Reason for drop
  • Subject
  • Catalog number
  • Section number
  • Class description
Courses Taken Report

Program

 (Chairs, Deans and Academic Secretaries)
Displays a list of students in a major and the grade/enrollment information for courses.
To run the report, you must define the majors and the courses to be reviewed.
Instructions:
  1.  Select a pre-existing "Report ID" or create a new one.
  2. To Create a new "Report ID":
    1. Click on "Add a New Value"Enter new "Report ID" (i.e. "Economics")
    2. Change Status to "Active"
    3. Enter a Description for the report
  3. Enter list of Academic Plans (majors) to be used as the selection criteria
  4. Enter list of courses to check
  5. Click "Save"
  6. Click on "Run Report"
  7. Click on either the PDF or Excel icons to download the file (PDF can only handle 9 courses).
  • Status
  • Description
  • Academic Plan
  • Course ID
  • Student ID
  • Name
  • Email
  • Advisor
  • Major
  • Term Credits
  • Total Credits
  • Course(s) selected
Enroolment Audit (CRSAUD)
PZFC_ENRL_AUDIT
Returns all the enrollment activities for the specified student and term, including those initiated by advisors, Registart, academic deparments, etc.

This is a simpler alternative to the Enrollment Request Search screen found under Records and Enrollments.
  • Student’s emplid
  • Term
  • Enrollment request ID
  • Session
  • Class number
  • Subject
  • Catalog number
  • Section
  • Component
  • Action
  • Operator
  • Date & time of action
  • Status
  • Message
Get Class Roster with Email
PZFC_EMAIL_CLASS_ROSTER
This is meant as a way to get a list of students in a class, download the results into Excel, copy all their email address, and then paste them into a new Outlook email. There is a way to email all students in a class via the Faculty Center’s Class Roster.
  • Term
  • Subject
  • Catalog number
  • Section
  • Session
  • Student’s emplid
  • Student’s name
  • Acad plan
  • Class rank
  • Advisor(s) name
  • Advisor(s) email
  • Class number
  • Class
Graduates with Minors
PZFC_GRADUATION_MINORS
Displays a list of students that graduated that had a minor. Academic Plans are typically majors, but they can include minors and certifications as well, which is why Acad Plan is being returned twice in this report.
  • Graduated term
  • Minor
  • Student’s emplid
  • Student’s email
  • Student’s name
  • Student’s home address
  • Acad plan (major)
  • Acad plan (minor)
  • Class rank
  • Advisor(s) name
  • Advisor(s) email
Graduation Report
PZFC_GRADUATED
Returns information on students who graduated at the end of the term specified. References the ACAD_DEGR (Student Degree) table.
Security: Chairs, Deans, Secretaries, Faculty, and Career Development Center
  • Term
  • Student emplid
  • Student’s email
  • Student’s name
  • Student’s home address
  • Student’s campus address
  • Term
  • Acad prog
  • Acad plan
  • Acad plan description
  • Honors
  • Class rank
  • Total cumulative credits
  • Cumulative GPA
List Candidates for Graduation
PZFC_INTENT_TO_GRADUATE
Returns a list of everyone that has not yet been award a degree and has an expected graduation term equal to the current term or earlier.
  • None
  • Student’s emplid
  • Student’s name
  • Student’s email
  • Student’s home address
  • Student’s campus address
  • Term
  • Acad prog
  • Acad plan
  • Acad plan description
  • Honors
  • Academic plan sequence
  • Class rank
  • Total cumulative credits
  • Grad status
  • Term
List Current Academic Plans
PZFC_LIST_ACADEMIC_PLANS
Returns a list of all “Academic Plan” codes that are active in the system.
  • None
Academic plan
Academic plan description
Major/minor
 Academic program
List Students by Major
PZFC_LIST_STUDENTS_BY_MAJOR
Lists all currently enrolled students in a particular academic plan for a particular term. This is meant as a way to get a list of students, download the results into Excel, copy all their email addresses, and then paste them into a new email in Outlook.
  • Acad Plan
  • Term
  • Student’s emplid
  • Student’s name
  • Student’s email
  • Sex
  • Student’s home address
  •  Student’s campus addressAcad plan
  • Career
  • Class Rank
  • Scheduled credits
  • Total credits taken
  • Test & Transfer credits
  • Total GPA
Students by Major (Version)
PZFC_PLAN_BY_STUDNET
Returns a list of students, their acad plans, when they declared those acad plans, and the version of the acad plan they’re in. The two terms correspond with the version of the Acad Plan the students are in (the versions correspond with terms, a.k.a.
 Requirement Terms).
  • Institution
  • Acad plan
  • Term 1
  • Term 2
  • Student’s emplid
  • Student’s name
  • Declare date
  • Effective date
  • Requirement term
Student Schedule
PZFC_STUDENT_SCHEDULE
Used primarily by academic department secretaries, chairs, and deans to view for a course all of the students’ schedule for that term. You can click on the link of the student ID and you will see the student schedule.
  • Term
  • Institution
  • Subject
  • Catalog Number
  • Class section
  • Student’s emplid
  • Student’s name
  • Student’s email
  • Academic program
  • Academic plan
  • FT/PT Status
  • Level
  • Total GPA
  • Term GPA
  • Advisor Name
  • Subject
  • Catalog number
  • Class number
  • Class description
  • Unit taken
  • Repeat code
  • Enroll status reason
  • Meeting days
  • Meeting time start
Rooms Available
PZFC_ROOM_AVAILABLE
Used by Academic Departements and Course Scheduler in the Registrar's Office to determine when and where courses should be scheduled for a semester.

This is a simpler version of Search for a Facility under Curriculum Management.
  • Term
  • Meeting days (MWF)
  • Meeting start time (1:30PM)
  • Building code
  • Room
  • Building description
  • Facility type
  • Capacity
Students by College
PZFC_LIST_STU_BY_COLLEGE
Similar to Student by Major report. Lists all currently enrolled students in a particular academic plan for a particular term. This is meant as a way to get a list of student, download the results to Excel, copy all their email addresses, and then paste them into a new email in Outlook.
  • Institution
  • Acad group
  • Term
  • Student’s emplid
  • Student’s name
  • Student’s email
  • Student’s home address
  • Student’s campus address
  • Acad plan
  • Career
  • Class rank
  • Scheduled credits
  • Total credits taken
  • Test & Transfer credits
  • Total GPA
Undeclared Students/ Advisors
PZFC_UNDECLARED
Returns all students that are “Undeclared” or “Exploratory Studies” for the term specified. Originally intended for the Academic Enrichment department in the library.
  • Term
  • Student’s emplid
  • Student’s name
  • Student’s email address
  • Academic standing
  • Cell phone number
  • Career
  • Transfer status and Class rank
  • Credits scheduled
  • Total credits taken
  • Total transfer credits
  • Total GPA
  • Activation date
  • Advisor(s) name
  • Advisor(s) email
View Enrollment Counts (COSINQ)
PZFC_COUNT_OF_SEATS_INQUIRY
Used by academic departments and course
 scheduler in the Registrar’s Office. COSINQ = Count of Seats Inquiry.
  • Institution
  • Term
  • Subject
  • Academic Org
  • Course ID
  • Academic org
  • Combined section ID
  • Class number
  • Subject
  • Catalog number
  • Section
  • Session
  • Name
  • Instruction type
  • Course description
  • Academic career
  • Lecture or lab
  • Room
  • Start date
  • End date
  • Meeting days
  •  Start timeEnd time
  • Room capacity
  • Requested room capacity
  • Enrollment capacity
  • Enrollment total
  • Withdrawal count
  • Combined enrollment total
  • Seats open
  • Minimum units
  • Maximum units
  • Status
  •  COSINQ
View Historical Grades
PZFC_VIEW_HIS_GRD_ROSTER
Returns a list of students for the course and term specified. Can be used to look up grades for any course in which grades have been issued.

Security: Dean/Dept., Faculty, Linked to SR
  • Term
  • Subject
  • Catalog number
  • Section number
  • Session number
  • Student’s emplid
  • Student’s name
  • Academic career
  • Component
  • Course ID
  • Subject
  • Catalog number
  • Section
  • Descr
  • Start date
  • End date
  • Session
  • Reason (enrollment status)
  • Drop date
  • Units taken
  • Grade
View Prerequisite Descriptions
PZFC_COURSE_PREREQ
Returns the latest course prerequisites as of the time the report is run.
  • Acad group
  • Catalog number
  • Subject
  • Acad group
  • Subject
  • Catalog number
  • Course number
  • Course ID
  • Acad org
  • Career
  • Requirement group
  • Requirement group description
View Transcript Notes
PZFC_TNOINQ
Displays notes that supplement a student’s transcript. These are internal notes entered by
Registrar’s Office staff and visible only to employees.
They do not appear on the student’s transcript.
  • Student’s emplid
  • Sequence number
  • Date
  • Comment on transcript
View Transfer Credit Summary
PZFC_VIEW_XFER_CREDITS
Returns a list of a student’s transfer credits.
  • Student’s emplid
  • Articulation term
  • Transferred course
  • Units taken
  • Grade
  • KU course
  • KU description
View Advisee's Grades
PZFC_ADVISEE_GRADES
Used primarily by academic department secretaries, chairs, and deans to view course for a person’s advisees for a particular term.
  • Term
  • Advisor’s emplid
  • Subject
  • Student’s emplid
  • Student’s name
  • Student’s email
  • Acad prog
  • Acad plan
  • Acad plan description
  • First term valid
  • Level
  • Total credits taken
  • Total GPA
  • Advisor’s emplid
  • Advisor’s name
  • Advisory role (primary/secondary)
  • Advisor’s email
  • Course subject
  • Course Catalog
  • Class number
  • Class description
  • Units taken
  • Repeat code
  • Enrollment status reason
View Enrollment Counts (Legacy)
PZSR_LEG_COSINQ
View the enrollment counts for a given term and department or a given term and course number from legacy.
  • Term
  • Dept.
  • Course number
  • Term
  • Department
  • Course
  • Section
  • Instructor name
  • Title
  • Seats allocated
  • Seats taken
  • Meeting start time
  • Meeting end time
  • Meeting days


Glossary and Notes

Acad Plan – major

Academic Plan Sequence – reference to the student’s program/plan stack; used by the Registrar’s Office

Academic Standing

  • Good
  • Dismissed
  • Dean’s list
  • Probation
  • Warning


Academic Org – the three letter prefix for an academic department/college on campus


Activation Date – the date the student was “term activated” for the term; this is a prerequisite for enrolling in classes each term


Career

  • UGRD = Undergraduate student
  • GRAD = Graduate student


Class Rank

  • Freshman
  • Sophomore
  • Junior
  • Senior
  • Grad Student


Class Number – a unique four-digit code used by the Registrar’s Office to identify a course; this is NOT the Subject + Catalog Number + Section Number (LIB 109 010) that most users see


Combined Enrollment Total – the number of seats if the course is a combined section (ANT010 and SOC010)


Combined Section ID – Internal reference to a course used by the Registrar’s Office if the course has more than one course schedule reference. For example, certain Anthropology and Sociology course are the same, but display in the course schedule as ANT010 and SOC010


Component – course type

  • Lecture
  • Lab
  • Seminar
  • Independent study


COSINQ – (Count of Seats Inquiry) – Used by the course scheduler in the Registrar’s Office


Course ID – internal reference to a course used by the Registrar’s Office


Descr – Course title


Eff Date – the date that the advisor becomes/became the student’s advisor


Enrollment Capacity – the maximum number of seats allotted for this course


Enrollment Status Reason – denotes whether the student was enrolled or withdrawn form the course at time of grading


Enrollment total – the number of seats currently taken in the course


Grad Status – reference to the student’s Degree Checkout Status on their program/plan stack; used by the Registrar’s Office

  • Applied, approved, denied, under review, pending, withdrawn


Level – Class rank (see class rank)


Maximum Units – if a course can be taken for a range of credits, this is the maximum value. For example, an independent study class can be taken for 3-12 credits


Minimum Units – if a course can be taken for a range of credits, this is the minimum value. For example, an independent study class can be taken for 3-12 credits


Operator – The first and last name of whoever took the specified action; can be student


Repeat Code – designates whether the course was repeated


Req Term – the “version” of the major/acad plan that the student is in; acad plan requirements change over time and go into effect at the beginning of a term


Request Room Capacity – the number of seats the academic departments would like this room to have


Requirement Group (Prerequisites) – a code identifying the group of prerequisites for a course


Room Capacity – the number of occupants/seats allowed per the Fire Marshall


Scheduled Credits – credits that the student is currently enrolled in for the semester


Seats open – the number of seats remaining in the course


Sequence Number – (for comments and notes); the earlier the number, the earlier the comment was entered. For example, on transcript notes


Session

  • Term and Session
  • 1 = regular session
  • 10W = MBA courses occur in 10 week cycles, so there’s a 10W session for those courses.
  • Summer term is split up into 2 sessions
  • S1 = Summer 1
  • S2 = Summer 2


Status – the end result of an action

  • Success
  • Errors
  • Messages – the action was successful, even though there were some messages warning of potential errors; details error status


Status (Class) – the status of the class

  • Active
  • Stop further enrollment
  • Tentative section
  • Cancelled section


Transfer Status and Class Rank – if the student has transfer credits, TR is added to their class rank, denoting that they are a transfer student at that class rank


Withdrawal count – the overall number of students who have withdrawn for the course.