Academic Scheduling Reports

SWREGRP Scheduling Reports

Missing Instructors by Term/Dept

This report generates a list of courses that are missing instructor assignments. For individualized study courses, run "Missing IS Instructors by Term/Dept".

  1. Select "Missing Instructors by Term/Dept.".
  2. Enter the term code and dept code.
  3. Click "Run Report" or select "Run Report" from the Options menu at the top of the screen.
  4. The "Database User Authentication" screen will appear. Complete with your Banner (a) userid and (b) password and click on "Submit" (you do not have to fill in "Database").

Missing IS Instructors by Term/Dept

This report generates a list of all individualized study registrations for which no instructor has been assigned. All IS registrations without instructors assigned are listed. For non-individualized study courses, run "Missing Instructors by Term/Dept".

  1. Select "Missing IS Instructors by Term/Dept."
  2. Enter the term code and dept code
  3. Click "Run Report" or select "Run Report" from the Options menu at the top of the screen
  4. The "Database User Authentication" screen will appear. Complete with your Banner (a) userid and (b) password and click on "Submit" (you do not have to fill in "Database").

IS Course Title with Errors or Missing Specific Title

This report generates a list of all individualized study registrations that have a problem with the IS course title in SFAINDV. This report will help you identify courses that have missing titles or errors with the title currently entered.

  1. Select "IS Course with Errors or Missing Specific Title"
  2. Enter the term code
  3. Enter the department code
  4. Click "Run Report" or "Run Report" from the Options menu at the top of the screen or "Run Excel Report" if you would like the report generated as a spreadsheet.
  5. The "Database User Authentication" screen will appear. Complete with your Banner (a) userid and (b) password and click on "Submit" (you do not have to fill in "Database").

Individualized Study by Instructor

This report generates a list of all the individualized study registrations an instructor has graded. Current term registrations will not be listed since the grades for those courses haven’t rolled into academic history.

  1. Select "Individualized Study by Instructor"
  2. Enter the instructor’s ID number or search for instructor’s name by clicking on the arrow to the right of the ID field
  3. Click "Run Report" or select "Run Report" from the Options menu at the top of the screen
  4. The "Database User Authentication" screen will appear. Complete with your Banner (a) userid and (b) password and click on "Submit" (you do not have to fill in "Database").

Schedule Proof by Term/Department or College

This report generates a list of courses that are on the class schedule for the given term. Information listed includes Subject Code, Course Number, Title, Status (A = Active, I = Inactive), CRN, Credits, Enrollment Max, Approval, UO Grade Mode (blank = optional graded or pass/no pass grade mode, G = graded only, * = pass/no pass only), Major Grade Mode, Registration Restrictions, Part of Term, Time, Days, Room, Building, Instructor, Fees, Footnotes, and Schedule Comments. Department footnotes codes (lower-case letters) are listed at the top of the report; University-wide footnote codes (upper-case letters) are listed at the end of the report.

  1. Select "Schedule Proof by Term/Dept or Coll"
  2. Enter the term code
  3. Enter the department code or college code (not necessary to enter both)
  4. Click "Run Report" or select "Run Report" from the Options menu at the top of the screen
  5. The "Database User Authentication" screen will appear. Complete with your Banner (a) userid and (b) password and click on "Submit" (you do not have to fill in "Database").

All Classes Ever Taught by Instructor

This report generates a list of all the courses that an instructor has taught, including current and past term courses. Information listed includes Term, CRN, Subject Code, Course Number, Title, Credits, Enrollment, Campus Code, Cross-List Number, and Percentage Responsibility.

  1. Select "All Classes Ever Taught by Instructor"
  2. Enter the instructor’s ID number or search for instructor’s name by clicking on the arrow to the right of the ID field
  3. Click "Run Report" or select "Run Report" from the Options menu at the top of the screen
  4. The "Database User Authentication" screen will appear. Complete with your Banner (a) userid and (b) password and click on "Submit" (you do not have to fill in "Database").

All Final Exams Scheduled for CRNs by Department

This report generates a list of courses with their final exam schedule. Information listed includes Subject Code, Course Number, Title, CRN, Credits, Enrollment, Exam Day, Exam Tim, Exam Building and Room, and Instructor.

  1. Select "All Final Exams Scheduled for CRNs by Department"
  2. Enter the term code and department code
  3. Click "Run Report" or select "Run Report" from the Options menu at the top of the screen
  4. The "Database User Authentication" screen will appear. Complete with your Banner (a) userid and (b) password and click on "Submit" (you do not have to fill in "Database").

Course Catalog Report

This report generates a one page display of Banner catalog data for each course within a (department, college, or subject area). The report details include course number, course title, credits, level, UO/major grading options, fees, degree attributes, repeatability conditions, field of study restrictions, class level restrictions, college restrictions, prerequisites, and short course description.

  1. Enter effective term code.
  2. Enter Department code (Required).
  3. Enter College and/or Subject code.
  4. Click "Run Report" or "Run Report" from the Options menu at the top of the screen or "Run Excel Report" if you would like the report generated as a spreadsheet.
  5. The "Database User Authentication" screen will appear. Complete with your Banner (a) userid and (b) password and click on "Submit" (you do not have to fill in "Database").

Section Prerequisite List

This report generates a list of CRN and course numbers for a specific term with their prerequisite courses (SSAPREQ). The report displays subject, course number prereq(s), and minimum grade required to fulfill the course prerequisite.

  1. Enter term code
  2. Enter subject code
  3. Enter specific CRN or "ALL" to list all CRN
  4. Click "Run Report" or "Run Report" from the Options menu at the top of the screen or "Run Excel Report" if you would like the report generated as a spreadsheet.
  5. The "Database User Authentication" screen will appear. Complete with your Banner (a) userid and (b) password and click on "Submit" (you do not have to fill in "Database").

Catalog Prerequisite List

This report generates a list of all courses by subject and their prerequisite courses. The report will show the catalog prerequisite (SCAPREQ) and lists subject, course number prereq, and minimum grade required to fulfill the prerequisite.

  1. Enter term code.
  2. Enter subject code.
  3. Enter course number or "ALL" to list all courses.
  4. Click "Run Report" or "Run Report" from the Options menu at the top of the screen or "Run Excel Report" if you would like the report generated as a spreadsheet.
  5. The "Database User Authentication" screen will appear. Complete with your Banner (a) userid and (b) password and click on "Submit" (you do not have to fill in "Database").

List of Dropped Courses by Subject or Department

This report generates a list of courses that have been dropped from the catalog. The report provides you with the course number, title, credits, and effective term that the course was dropped.

  1. Enter term code
  2. Enter department code or subject code (you do not need to enter both)
  3. Click "Run Report" or "Run Report" from the Options menu at the top of the screen or "Run Excel Report" if you would like the report generated as a spreadsheet.
  4. The "Database User Authentication" screen will appear. Complete with your Banner (a) userid and (b) password and click on "Submit" (you do not have to fill in "Database").

Course Attribute Report

This report generates a list of courses that have one or more course attribute code assigned in SSASECT. The report provides you with the CRN, course number, title, instructor, and attribute code(s). This report should be used to review your department specific course attribute codes that are applied to the degree audit.

  1. Enter term code
  2. Enter department code (this field is required)
  3. Enter CRN and/or specific course attribute code. You can display a list of values for course attribute by pressing F9 or clicking on the Help menu and selecting List.
  4. Click "Run Report" or "Run Report" from the Options menu at the top of the screen.
  5. The "Database User Authentication" screen will appear. Complete with your Banner (a) userid and (b) password and click on "Submit" (you do not have to fill in "Database").

Course Fees Report

The Course Fee Report generates a list of courses that have one or more course fees assigned in SSADETL. The report provides you with the CRN, subject, credit subject, course number, title, account detail code, account detail description, fee amount, fee type, credit hours, and tuition fee waiver indicator. This report should be used to review your department course fees that are assessed in addition to regular tuition and fees.

  1. Enter term code
  2. Enter department code (this field is required)
  3. Optional. Enter Subject and/or Course Number. You can display a list of values for subject code by pressing F9 or clicking on the search arrow.
  4. Click "Run Report" or "Run Report" from the Options menu at the top of the screen.
  5. The "Database User Authentication" screen will appear. Complete with your Banner (a) userid and (b) password and click on "Submit" (you do not have to fill in "Database").

Faculty Office Hour Report (SWREGRP)

This report will provide office hour and faculty URL information for an individual faculty members or a list of ALL faculty by department affiliation. The report includes UO ID, name, faculty URL, from time/to time for office hours, days, comments, and display indicator.

Instructions

  1. Select “Faculty Office Hour Report”
  2. Enter “Instructor ID” (if you want a report for all faculty in your department skip this step)
  3. Enter “Department Code”; this field is required.
  4. Click "Run Report" or select "Run Report" from the Options menu at the top of the screen.
  5. The "Database User Authentication" screen will appear. Complete with your Banner (a) userid and (b) password and click on "Submit" (you do not have to fill in "Database").

Scheduling Time Zones Reports

Department scheduling protocol reports can be run on demand in Banner. The report calculates departmental compliance with the University Scheduling Protocols. It reflects the number and percent of courses taught in each time zone. You may run an entire subject, your entire department, a college summary, or an overall summary. Here's how:

Running the Utilization of Scheduling Time Zones Report

  1. Enter SSASECT (or SQASECT if SSASECT is not available).
  2. From the Options Menu, click on "Run SWRDAYS Report."
  3. Reenter your Banner user name and password if prompted to do so.
  4. A dialog box labeled "SWRDAYS: Runtime Parameter Form" will appear on the screen. The term code will default to the term indicated on SSASECT or SQSECT. (Change that to another term if you want.)
    • Use the pull-down menu to select a Department Code to retrieve all subjects within a department. For example, enter the code for Germanic Languages (GERL) to get Swedish, Danish, Norwegian, Finnish, German, and Scandinavian. The report will generate a page for each subject code within the department, as well as a department summary.
    • Use the pull-down menu to select a Subject Code to retrieve a single subject, such as ENG for English.
    • Use the pull-down menu to select a College Code to retrieve the report by College, including all departments and subjects within the College, such as JO for Journalism and Communication.
  5. Indicate with a "Y" or "N" whether you would like the report to include a summary by Department, College, or Campus-Wide. If you leave all the reports set to the default "Y" you will get all three reports.
  6. Once you have entered your values, click on the Submit Query button at the top of the page. Your protocol report will appear on your screen and may be saved in PDF format on your computer. You are then able to print the report. (You must have the current version of Adobe Acrobat Reader to view/print this report).
  7. Use this report to determine your department compliance with the zone percentages and evaluate where you might make changes in order to comply with the protocol requirements.

For help with this report, contact Academic Scheduling, (541) 346-3225 or sched@uoregon.edu.

Course Edit Reports

Course Edit reports can be run one CRN at a time, by a given subject, or by department.

Running the Course Edit Report

  1. Enter SSASECT (or SQASECT if SSASECT is not available).
  2. From the Options Menu at the top of the form, click on "Run SWREDIT Report."
  3. A dialogue box labeled "Report Parameters; Enter values for the Parameters" will appear on the screen. Enter values as desired, but always enter a Term Code. Leave the "%" signs in the fields you do not wish to use for your selection.
    • Enter a Term Code and CRN to run a course edit report for a single CRN.
    • Enter a Term Code and Department Code to get all subjects within a department (for example, enter the code for Germanic Languages (GERL) to get Swedish, Danish, Norwegian, Finnish, German, and Scandinavian).
    • Enter a Term Code and a Subject Code to run just one subject (ENG for English).
    • Enter a Term Code and Credit Subject Code to get edit reports by Credit Subject (OIMB for the marine biology center).

These values may be used in combination. For example, you may generate all the Biology courses for Winter 2006 with OIMB as the credit subject; enter 200502 in the Term Code field, BI in the Subject Code field, and OIMB in the Credit Subject Code field.

Once you have entered your values, click on the Submit Query button. Your edit reports will appear on your screen and may be printed and/or saved to your computer as a PDF file.

Getting Help

If you are unable to generate the edit reports, there may be a compatibility problem with your web browser or you may not be running a current version of Adobe Acrobat Reader. First check the Banner FAQ for information and assistance.

If you are still unable to resolve the problem, you may contact one of the following individuals for assistance:

If you have questions or need help running any of the scheduling reports, please call or e-mail staff in Academic and Classroom Scheduling, sched@uoregon.edu, (541) 346-3225.