Course Edit Reports and Scheduling Reports (SWREDIT, SWRDAYS & SWREGRP)
Course Edit Reports (SWREDIT)
You are able to run department course edit reports on demand in Banner. You may run one CRN at a time, an entire subject, or your entire department. Here's how:
Running the Course Edit Report
- Enter SSASECT (or SQASECT if SSASECT is not available).
- From the Options Menu at the top of the form, click on “Run SWREDIT Report.”
- 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.
Scheduling Time Zones Reports (SWRDAYS)
You are able to run department scheduling protocol reports 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
Enter SSASECT (or SQASECT if SSASECT is not available).
From the Options Menu, click on “Run SWRDAYS Report.”
Reenter your Banner user name and password if prompted to do so.
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.
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.
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).
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 [dot] edu.
Running Scheduling Reports in SWREGRP
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”.
- Select "Missing Instructors by Term/Dept."
- Enter the term code and dept code
- Click “Run Report” or select “Run Report” from the Options menu at the top of the screen
- 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”.
- Select "Missing IS Instructors by Term/Dept."
- Enter the term code and dept code
- Click “Run Report” or select “Run Report” from the Options menu at the top of the screen
- 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.
- Select "Individualized Study by Instructor"
- Enter the instructor’s ID number or search for instructor’s name by clicking on the arrow to the right of the ID field
- Click “Run Report” or select “Run Report” from the Options menu at the top of the screen
- 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.
- Select "Schedule Proof by Term/Dept or Coll"
- Enter the term code
- Enter the department code or college code (not necessary to enter both)
- Click “Run Report” or select “Run Report” from the Options menu at the top of the screen
- 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.
- Select "All Classes Ever Taught by Instructor"
- Enter the instructor’s ID number or search for instructor’s name by clicking on the arrow to the right of the ID field
- Click “Run Report” or select “Run Report” from the Options menu at the top of the screen
- 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.
- Select "All Final Exams Scheduled for CRNs by Department"
- Enter the term code and department code
- Click “Run Report” or select “Run Report” from the Options menu at the top of the screen
- 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”).
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 INB FAQ for information and assistance.
If you are still unable to resolve the problem, you may contact one of the following individuals for assistance:
- Jim Bouse, Associate Registrar, jbouse
uoregon [dot] edu, (541) 346-3182 - Jim Blick, Assistant Registrar jblick
uoregon [dot] edu, (541) 346-3246
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 [dot] edu, (541) 346-3225.
