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

CRSE_LEVEL table

(dwngss_ps.crse_level)

Explanation

Contains the level or levels at which a course may be offered. Each course must have at least one level.

Source

The warehouse CRSE_LEVEL 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_SCRLEVL.

Cautions and notes

• When students who are in multiple levels enroll in course sections, the credit hours are pointed to their primary level. Once their enrollement is the course section is graded and rolled to academic history, it can be pointed to additional levels so that the course will appear, if desired and approved, on more than one of their transcripts. Note that this pointing of courses cannot happen in the current term -- it only happens after the enrollment record has moved to academic history.

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