Academic Department Reports can be found through Main Menu > Records and Enrollment > KU Custom. Access to these reports varies, and is noted under each report.


Available Reports

Access to these reports varies and is noted in the “security” column for each report. The second column indicates the underlying query’s name. The query can also be accessed via Reporting Tools > Query > Query Viewer.

 

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


Report Name
Query Name
Description
Search Parameters
Fields Returned
Security
Advising List by Academic Program
PZAA_ADVISING_LISTS
This query/report returns a list of advisees, and their advisors, enrolled in the Acad Plan specified for the term specified. Note: Only returns students currently “active” on their program/plan stacks (regardless of term).
  • Institution 
  • Term 
  • Acad plan 
  • Student’s emplid
  • Student’s name
  • Primary academic program
  • Acad plan, description, and version (term)
  • Full-­‐time/part-­‐ time
  • Class rank
  • Total credits taken
  • Total GPA
  • Advisor’s emplid
  • Student’s home address
  • Advisor’s name
  • Advisor’s email
  • Advising Center
  • IT Help Center
  • IT Support
  • Distance Ed
  • Registrar’s Office
  •  Deans, Chairs, and admin staff
Check Lecture/Lab Enrollment
PSZR_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. Also returns the course number.
  • Term 
  • Student emplid
  • Student name
  • Class (3-­‐letter subject code, catalog number, section number)
  • Advising Center
  • Connections
  • IT Help Center
  • IT Support
  • Distance Ed
  • Library Staff
  • Registrar’s Office
Class Enrollment List
PZ_R014_CLASS_ENRL_LIST
Returns a list of students, their enrollment status, and their residency (O = Out of State, I = In-­‐State, F= Foreign)
  • 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 (in-­-state/out-­‐state)
  • Registrar’s Office
  •  Social Equity Office
Course Drops by Instructor
SR_COURSE_DROPS_BY_INSTR_ TERM
Displays a list of students that dropped a course for the instructor specified.
  • Instructor last name
  • Term
  • College
  • Instructor name
  • Class number
  • Student emplid
  • Student name
  • Drop code
  • Reason for drop
  • Subject
  • Catalog number
  • Section number
  •  Class description
  • Academic Affairs
  • Advising Center
  • IT Help Center
  • IT Support
  • Distance Ed
  • Registrar’s Office
  •  Social Equity Office
Distance Ed Courses (CRSDIS)    
PZSR_DIS_ED_COURSEMASTER
Displays a list of courses offered in a distance ed format, including the course attribute code that describes the type of DE course: O8 = Online 80-­‐99%, OL = Online 100%, IH = Interactive TV, IR = Interactive TV Remote Site, BL = Blended 30-­‐79%, APPROVED = Approved.
  • Term
  • Session
  • Course attribute value
  • Description
  • Subject
  • Catalog number
  • Section number
  • Course title
  • Course ID
  • Course offer number
  • Class number
  • Seats available
  • Minimum units
  • Maximum units
  • Instructor name
  • Total number enrolled
  • Human Resources
  • IT Help Center
  • IT Support
  • Distance Ed
  • Payroll Services
  • Registrar’s Office
  • Other personnel involved in determining faculty workload
Emailing Learning Communities
PZSR_EMAIL_SPP_STUDENTS
Returns a list of all students enrolled in an SPP (Learning Community) course for the term specified.
  • Term
  • Class number
  • Class
  • Student’s emplid
  • Student’s name
  • Student’s email
  • Class rank
  • Academic plan(s)
  • IT Help Center
  • IT Support
  • Distance Ed
  • Graduate Studies
Email Students by College
PZSR_EMAIL_STUDENTS_BY_CO LLEGE
This is meant as a way to get a list of students in a college, download the results into Excel, copy all their email addresses, then past them into a new email in Outlook. Theprogram status can be filtered in Excel, in case someone wants to exclude those who have left the university, are on a leave of absence, graduated, etc. Note: If a student is expected to be on the list, but isn’t, it might have to do with the Student Career Number on the Student’s Program/Plan stack not matching their Term Activation record for the term in question. The Registrar’s Office would need to be contacted to look into these situations.
  • Institution
  • Acad group
  • Term
  • Student’s emplid
  • Student’s email
  • Student’s name
  • Academic career
  • Class rank
  •  Credits taken/scheduledTotal credits taken
  • Total test & transfer credits
  • Program status for the term
  • Career Development
  • IT Help Center
  • IT Support
  • Distance Ed
  • Deans, Chairs, and their admin staff
Enrollment Audit (CRSAUD)
PZSR_ENRL_AUDIT
Returns all the enrollment activities for the specified student and term, including those initiated by advisors, Registrar’s Office personnel, academic departments, etc. This is a simpler alternative to the Enrollment Request Search screen (found under Records and Enrollment > Enroll Students > Enrollment Request Search)
  • Student’s emplid
  • Term
  • Enrollment Request ID
  • Session
  • Class number
  • Subject
  • Catalog number
  • Section
  • Component
  • Action
  • Operator
  • Date and time of action
  • Status
  • Message
  • Registrar’s Office
  • Connections
  • Student Success Department (CASA)
  • Faculty
  • Deans, Chairs, and their admin staff
  • IT Help Center
  • IT Support
  • Distance Ed
  • Financial Aid
  • Select individuals in the Bursar’s
  •  Office
Enrollments by Term
PZSR_ENROLLMENTS_BY_TERM
This is the same as “Email Students by College,” expect this includes student’s home and cell phone number. Originally intended for HR and Payroll.
  • Term
  • Academic career
  • Emplid
  • Unit taken progress
  • Academic year
  • Cumulative GPA
  • Cumulative credits
  • Acad prog
  • Student’s name
  • Student’s home address
  • Acad plan descriptionAcad plan
  • Student’s cell number
  • Student’s home number

  • Human Resources
  • IT Help Center
  • IT Support
  • Distance Ed
  • Payroll Services
  • Registrar’s Office
Get Class Roster with Email
PZSR_EMAIL_CLASS_ROSTER
This is meant as a way to get a list of students in a class, download the results into Excel, copy al their email addresses, and then paste them into a new email in Outlook. There is also a way to email all students in a class via Faculty Center > Class Roster.
  • Term
  • Subject
  • Catalog number
  • Section
  • Session
  • Class number
  • Class
  • Student’s emplid
  • Student’s name
  • Student’s email
  • Class rank
  • Acad plan
  • Advisor’s name
  • Advisor’s email
  • Academic Affairs
  • Advising Center
  • Bookstore
  • Deans, Chairs, and their admin staff
  • Faculty
  • Grants Office
  • Human Diversity (Disability Services Office)
  • Human Resources
  • IT Help Center
  • IT Support
  • Distance Ed
  • Payroll Services
  • Public Safety
  • Registrar’s Office
  • Social Equity
  • Student Success (CASA)
  • Select individuals in Career Development and
  • Bursar’s Office
Get Degree Recipients
PZSR_DEGREE_AWARDED
Returns a list of everyone that graduated for the term specified. Originally created for HR and Payroll Services.
  • Term
  • Student’s emplid
  • Student’s name
  • Academic career
  • Campus email
  • Financial Aid
  • Human Resources
  • IT Help Center
  • IT Support
  • Distance Ed
  • Payroll Services
  • Registrar’s Office
  •  Deans, Chairs,and their Admin Staff
  • Select Individuals in the Bursar’s
  • Office
Get Enrolled Vets by Term
PZSR_VETS_BY_TERM
Returns a list of military veterans that are/were enrolled in classes for the term specified.
  • Term
  • Student’s emplid
  • Student’s email
  • Student’s name
  • Student’s home address
  • Student’s preferred phone number
  • Phone type
  • VA benefit
  • Military status
  • Academic career
  • Class rank
  • Career Development
  • IT Help Center
  • IT Support
  • Distance Ed
  • Registrar’s Office
Get SSSP/TRIO Instructors
PZSR_GET_TRIO_INSTRUCTORS
Returns a list of all instructors teaching students belonging to the SSSP/TRIO student group for the term specified.
  • Term
  • Session
  • Advisor’s emplid
  • Advisor’s name
  • Advisor’s email
  • IT Help Center
  • IT Support
  • Student Support Services
  • Registrar’s Office
Get SSSP/TRIO Students
PZFC_SSSP_EMAIL
Returns a list of students currently marked as “active” in the SSSP student group.
  • None
  • Student’s emplid
  • Student’s email
  • Student’s name
  • Student group name (SSSP)
  • Advising Center
List Candidates for Graduation
PZAD_INTENT_TO_GRADUATE
Returns a list of everyone that has not yet been awarded a degree and has an expected graduation term equal to the current term or earlier.
  • None
  • Student’s emplid
  • Student’s email
  • Student’s name
  • Acad prog
  • Acad plan and description
  • Dual major?
  • Honors
  • Acad plan sequence number
  • Class rank
  • Total cumulative credits
  • Graduate status
  • Term
  • Student’s home address
  • Student’s campus address
  • Admissions
  • Housing
  • Human Resources
  • IT Help Center
  • IT Support
  • Learning Management
  • Registrar’s Office
List Current Academic Plans
PZSR_LIST_ACADEMIC_PLANS
Returns a list of all the Academic Plan codes in the system that are currently active.
  • None
  • Academic plan
  • Academic plan description
  • Major/minor
  • Academic plan
Advising Center
IT Help Center
IT Support
Learning Management
Registrar’s Office
List Students by Major
PZSR_LIST_STUDENTS_BY_MAJO  R
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 email
  • Student’s name
  • Student’s home address
  • Student’s campus address
  • Acad plan
  • Career
  • Class rank
  • Scheduled credits
  • Total credits taken
  • Total test & transfer credits
  • Total GPA
  • Sex
  • Advising Center
  • Career Development
  • IT Help Center
  • IT Support
  • Learning Management
  • Social Equity
  • Registrar’s Office
List Undeclared Students
PZSR_UNDECLARED
Returns all students that are “Undeclared” (or in “Exploratory Studies”) for the term specified.
  • Term
  • Student’s emplid
  • Academic standing
  • Student’s name
  • Transfer status and class rank
  • Credits scheduled
  • Total credits taken
  • Total transfer credits
  • Academic career
  • Activation date
  • Advisor’s name
  • Student’s cell phone number
  • Advisor’s email
  • Advising Center
  • IT Help Center
  • IT Support
  • Learning Management
  • Library Staff
  • Registrar’s Office
Students By Major
PZSR_PLAN_BY_STUDENT
Returns a list of students, their acad plans, when they declared those acad plans, and the version of the acad plan that they’re in.
  • Institution
  • Acad plan
  • Term 1
  • Term 2
  • Student’s emplid
  • Acad plan
  • Declare date
  • Req term
  • Student’s name
  • Credits scheduled
  • Total transfer credits
  • Total credits taken
  • Class rank
  • Program status
  • Completion term
  • Registrar’s Office
Students By College
PZSR_LIST_STUDENTS_BY_COLL EGE
Similar to “Students By Major” report. Lists all students enrolled in a particular academic plan for the term specified. 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. Note: This will only return students that are marked as “Active”, “On Leave of Absence”, or “Completed” (Graduated) on their Academic Record (Program Plan stack).
  • Institution
  • Acad group
  • Term
  • Student’s emplid
  • Student’s email address
  • Student’s name
  • Student’s home address
  • Student’s campus address
  • Acad plan
  • Career
  • Class rank
  • Schedule credits
  • Total credits taken
  • Total test & transfer credits
  • Total GPA
  • Registrar’s Office
View Enrollment Counts (COSINQ)
PZSR_COUNT_OF_SEATS_INQUI RY
COS = Count of Seats. Returns a snapshot of enrollment in course for the term specified, subject specified, and/or Academic Org (academic department) specified. Contains data on a room’s seat capacity, a course’s seat capacity, and other statistics relevant to course schedulers.
  • Institution
  • Term
  • Subject
  • Academic Org
  • Course ID
  • Academic Org
  • Combined section ID
  • Class number
  • Subject
  • Catalog number
  • Section
  • Session
  • Instructor’s name
  • Instruction type
  • Course description
  • Academic career that the course is tied to
  • Lecture/lab
  •  RoomStart date
  • End date
  • Room capacity
  • Requested room capacity
  • Enrollment capacity
  • Enrollment total
  • Withdrawal count
  • Combined enrollment total
  • Seats open
  • Minimum units
  • Maximum units
  • Status
  • APSCUF Office
  • Academic Affairs
  • Advising Center
  • Bookstore
  • Commuter/Judici al Services
  • Connections
  • Cultural Affairs
  • IT Help Center
  • IT Support
  • Distance Ed
  • Graduate Studies
  •  Select individual’s in the Bursar’sOffice
  • Registrar’s Office
View Historical Grades
PZSR_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.
  • 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
  • Drop date
  • Units taken
  • Grade
  • IT Help Center
  • IT Support
  • Learning Management
  • Registrar’s Office
View Transcript Notes
SR_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
  • Academic Affairs
  • Advising Center
  • Commuter & Judicial Services
  • IT Help Center
  • IT Support
  • Learning Management
  • Standard Permissions
  • Registrar’s Office
View Transfer Credit Summary
PZSR_VIEW_XFER_CREDITS
Returns a list of all courses transferred into KU for a given student.
  • Student’s emplid
  • Articulation term
  • Transferred course
  • Units taken
  • Grade
  • KU course
  • KU description
  • Advising Center
  • Connections
  • IT Help Center
  • IT Support
  • Distance Ed
  • Graduate Studies
  •  Registrar’s Office
View an Advsior's Advisee List
PZAA_VIEW_ADVISOR_ADVISEE S
Used primarily by academic department secretaries, chairs, and deans to view courses for a person’s advisees for a particular term.
  • Advisor’s emplid
  • Term
  • Student’s emplid
  • Academic career
  • Student’s name
  • Student’s email
  • Student’s advisors
  •  Effective date
  • Academic Affairs
  • Advising Center
  • IT Help Center
  • IT Support
  • Distance Ed
  • Registrar’s Office
  • Faculty/Advisors
  • Deans, Chairs, and their admin vstaff



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

Action – i.e., enroll, drop, grade added

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


Carerr

  • 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


Program Status – i.e., active in program, leave of absence, cancelled/discontinued


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

  • 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