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

V_CRSE_REG_PRIORITY table

(dwngss.v_crse_terms_offr)

Explanation

This is a validation table, containing the values and descriptions for the Terms Offered codes associated with courses, used as information published in the Course Catalog.

Examples: H = Fall, even numbered years, L = Summer only, etc.

Source

The warehouse V_CRSE_TERMS_OFFR 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_STVCUDE.

Cautions and notes

• The Terms Offered is associated with a Course. It is used for providing information to the Course Catalog. However, it is not a system-enforced rule when it comes to the offering of course Sections.

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