COURSE column definitions . Pennant Student Records Home . Data Warehouse Home

COURSE table

(dwngss_ps.course)

Explanation

Course inventory information, represented in a term-by-term view. Contains the course short and long titles, home school, department, and, if applicable, administering division. Also has things like catalog start and end terms, max and min credits, and the course cross-list family identifier if applicable.

Source

The warehouse COURSE table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The UPENN_ODS source tables are SATURN_SCBCRSE, SATURN_SCBSUPP, SATURN_SCRSYLN and SATURN_SCRCRKY. In the online Pennant system, the data in the COURSE table can be viewed on the SCACRSE form.

Common Uses

• Getting course inventory titles.
• Identifying courses that have changed over time.

Cautions and notes

• Since course Level, Grad Type, Schedule Type, corequisites and prerequisites can have multiple values per course, those data elements are found in separate tables. Because the Data Warehouse stores Course inventory data term-by-term (instead of term-effective), it simplifies the joins between Course and the Related Tables: the join should be on Term, Subject and Course Number.
• The COURSE table does not contain the Level that the course can be offered. CRSE_LEVEL contains the level or levels. These are matched to the student levels when students register. Only students in a level that matches one of the course levels can take the course. Note that the Course Level does not indicate whether a course is undergraduate or graduate. For that, you will need to look at the course number. See the Catalog's "Course Numbering" page.

COURSE column definitions . Pennant Student Records Home . Data Warehouse Home