Penn Computing

University of Pennsylvania
Penn Computing << go backback
CRSE_SECT_OVERRIDE column definitions . Pennant Student Records Home . Data Warehouse Home

COURSE SECTION OVERRIDE table

(dwngss_ps.crse_sect_override)

Explanation

Contains any overrides to departments or divisions on a scheduled course offering. Overrides are used when a course section needs to be established with a setup that is different from the base course in the catalog, for example, a course may be associated with the School of Arts and Sciences in the catalog, but a specific scheduled course section might be set up as being administered by the Liberal and Professional Studies division.

Source

The warehouse CRSE_SECT_OVERRIDE table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The UPENN_ODS source table is SATURN_SSBOVRR.

 

Primary Key Indexed Data Elements Related Tables
CRSE_SECT_OVERRIDE_PK
based on term and crn

TERM

CRSE_SECTION

Cautions and notes

  • The CRSE_SECT_OVERRIDE table has columns for Administrative Unit and Taxonomy of Program overrides. As of the initial rollout of Pennant Student Records, those two fields are not used at Penn.
CRSE_SECT_OVERRIDE column definitions . Pennant Student Records Home . Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania