Common Banner Queries

Schedule Proof (ZSRCSPR) & Do Not Print List (ZSRDNPC)

  1. At the main Banner menu, type ZSRCSPR (Schedule Proof) or ZSRDNPC (Do Not Print list), select Enter.
  2. You should now be in either ZSRCSPR – Class Schedule Proof Report or ZSRDNPC – Do Not Print Course
  3. CTRL + page down to the Printer Control block, enter the name of the designated Banner printer in your office (where transcripts are now printed)
  4. CTRL + page down into the Parameter Values block  enter in Values Block
  5. Term Code – Type in the term, e.g., 200710
  6. Subject Code – Type in your three-letter subject code (ALL CAPS)
  7. Spacing – Type in the number 1
  8. CTRL + page down into Submission block – Save with an F10 or select the Save icon.
    • Note:  You do not need to Save Parameter Set by selecting the box.

Course Search; SSASECQ

To search for a CRN:

  1. Enter 3-letter subject code.
  2. Enter a specific term or leave blank to see all the terms that this course has been taught.
  3. Press F8 to execute query.

See Act field under Enrollment to view the current enrollment.
See Act field under Waitlist to view the number of waitlisted students.

Scheduling Query Form; ZSADETQ

  1. Enter 6-digit term.
  2. Enter CRN.
  3. Ctrl + PageDown.
  4. Section Tab: To view enrollment information, refer to "Actual" and "Wait List Actual" fields.
  5. Restrictions Tab: View the restrictions for the specific CRN.  
    • I = Include indicates that only students meeting the specific criteria may register in that CRN.
    • E = Exclude means that everyone except students with the stated criteria may register for that CRN.
  6. Cross-List/Co-Requisite Tab: If blank, the course is not cross-listed with another course.

Room Conflict Search; SSAMATX

  1. Enter building code, tab.
  2. Enter 5-digit room number, tab.
  3. Enter day, tab.
  4. Enter begin and end time in military time.
  5. Enter 6-digit term code.
  6. Press F8 to execute query.

Instructor’s Banner ID Search; SIAIQRY

  1. Enter term.
  2. Ctrl + PageDown.
  3. Key Last name and First name (use the wildcard % if searching for a common name).  Note: Entries are case-sensitive.
  4. Press F8 to execute query.

Instructor's Course Schedule; ZSAINSQ

Use this Banner screen to find which instructor is teaching a course/sections. The form is useful when finding the instructor for a 099/199 internship course due to several sections offered every quarter.

  1. Enter term.
  2. Enter 3 letter subject.
  3. Enter Course number.
  4. Press F8 to execute query.