Penn Computing

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

COURSE SECTION RESTRICTIONS on LEVEL table

(dwngss_ps.crse_sect_rstr_levl)

Explanation

Contains any registration restrictions placed on a course section in a term, based on students' level code.

Source

The warehouse CRSE_SECT_RSTR_LEVL 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_SSRRLVL.

 

Primary Key Indexed Data Elements Related Tables
CRSE_SECT_RSTR_LEVL_PK
based on term, crn, and student level code

CRSE_SECTION, ST_ENROLLMENT

Cautions and notes

  • The course section restrictions are placed on scheduled sections in a term, and may not be the same on every term.
  • These restrictions are placed based on the student's level. (not to be confused with the degree level). See V_STDNT_LEVEL.
CRSE_SECT_RSTR_LEVL 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