捆绑SM社区

Catalog views

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听摆.辫诲蹿闭

The catalog view contains details about the course catalog. It will return one row per course per administration unit per term.

Catalog Views听摆.虫濒蝉闭

The catalog view contains details about the course catalog. It will return one row per course per administration unit per term.

Back to top