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

ST_CRSE_FEES table

(dwngss_ps.st_crse_fees)

Explanation

Contains the billing fee type, amount, term, and associated course subject and course number, for courses in which a special fee is assessed to students registered in that course.

Source

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

Common Uses

• Identify special billing on courses in a term.

Cautions and notes

• This table does not contain student Penn_ids or pidms. It pertains to course sections. To find students who may be assessed the course fee, see ST_ENROLLMENT.

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