The schedule views contain columns for course information (course number, course title, subject code, administering faculty, etc.) as well as many other data elements.
All the schedule views are keyed by the term code (TERM_CODE_KEY) and course registration number (CRN_KEY). These views contain all the terms since Banner went live (200209 and greater). The views will return one row of information per crn per term.
The view names you see will depend on the level of access you have been granted. The naming convention is as follows:
| Developer level: | SRM_SCHEDULE |
| Central User level: | SRU_SCHEDULE |
| Faculty level: | SRU_SCHEDULE |
Other "special" schedule views have been created for specific cases.
Schedule Views [.pdf]
The Schedule View contains details about courses. It will return one row for each crn per term.
Schedule Views [.xls]
The Schedule View contains details about courses. It will return one row for each crn per term.