Penn Computing

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

COURSE SECTION MEETING table

(dwngss_ps.crse_sect_meeting)

Explanation

Contains information about the days, times, and building locations where course sections meet.

Source

The warehouse CRSE_SECT_MEETING 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_SSRMEET.

 

Primary Key Indexed Data Elements Related Tables
CRSE_SECT_MEETING_PK
based on term,course_ref_num, and surrogate_id

TERM, COURSE_REF_NUM

CRSE_SECTION

Cautions and notes

  • The CRSE_SECT_MEETING can have multiple rows per Course Section per term. For example, if a course meets on Mondays from 2-4, and on Wednesdays from 4-6, there will be two rows in the table for that course in that term.
  • Course section meetings have start and end dates for the course section. These usually align with the Part-of-Term assigned to the course section, but the start/end dates in CRSE_SECT_MEETING can sometimes be custom dates, that override the dates on the Part-of-Term.
CRSE_SECT_MEETING 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