The catalog views contain columns for course information (course number, course title, subject code, administering faculty, etc.) as well as many other data elements.
All the catalog views are keyed by the term code (TERM_CODE_KEY), subject code (SUBJECT_CODE), course number (COURSE_NUMBER), administering faculty code (ADMIN_FACULTY_CODE), teaching faculty code (TEACHING_FACULTY_CODE), teaching department code (TEACHING_DEPT_CODE), and unit/subunit code (UNIT_SUBUNIT_CODE). These views contain all the terms since Banner went live (200209 and greater). The views will return one row of information per course per administration unit 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_CATALOG |
| Central User level: | SRU_CATALOG |
Other "special" catalog views have been created for specific cases.
Catalog Views [.pdf]
The catalog view contains details about the course catalog. It will return one row per course per administration unit per term.
Catalog Views [.xls]
The catalog view contains details about the course catalog. It will return one row per course per administration unit per term.