Penn Computing

University of Pennsylvania
Penn Computing << go backback

COURSE SECT TYPE TERM Table - Data Element Index . Tables and Data Elements . Student Records Data Home . Data Warehouse Home

COURSE SECTION TYPE TERM Table

(dwadmin.course_section_type_term)

Explanation

Contains Section Types for a Course Section. A Course Section can have up to ten Section Types. One record exists in this table for each Section Type for each Course ID for each term the course is offered at Penn.

Common Uses

  • Finding which course sections are offered in a given term for certain section types.
Primary Key Indexed Data Elements Related Tables
TERM, SECTION_ID, SECTION_TYPE SECTION_TYPE COURSE_SECTION
CEN_COURSE_SECT_TYPE
ENROLLMENT_ALL_V
ENROLLMENT_SECT_TYPE_TERM

Cautions

  • Students who enroll in a course with Section Types can subsequently have the Section Type on their enrollment record changed. It is possible for the Section Type in ENROLLMENT_SECT_TYPE_TERM and the Section Type in COURSE_SECT_TYPE_TERM to be different, even within the same course section in the same term. One common example is WATU, where the Section Type is maintain on a student-by-student basis, and is not always assigned to everyone enrolled in the course.

 

COURSE SECT TYPE TERM Table - Data Element Index . Tables and Data Elements . Student Records Data 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