TABLE: COURSE
WUG February 1995

What is the COURSE table?
A table that contains information about courses. There is one record per course per semester. A course is the thing that appears in the ASU catalog i.e. ENG 101 Freshman English.

What is the key (unique identifier for a row) for COURSE?
Semester, course campus code, course ID

What is the timing of the table?
The COURSE table is updated weekly. All courses existing in the SIS course database are recreated each semester whether used or not. As new courses are approved and a class maintenance form is submitted to the registrar a new course record will appear in this table.

Why would you use it?
The most common use of the COURSE table is to put course titles on CLASS and STUDENT_CLASS records. This table is useful to join to the CLASS and STUDENT_CLASS tables to get info on the course. Override information by course could be useful in studying demand for a course.

What should you watch out for?
There is no way to tell if a course is currently being offered or is active without joining it to class or registrations. A NO_LONGER_ON_SIS flag doesn't even help here because the SIS course database has all course records whether they are courses that are currently offered or not.

WHS 102 - Accessing ASU Data Warehouse