Penn Computing

University of Pennsylvania
Penn Computing << go backback
CRSE_SECT_SCHED_WITH Table . Pennant Student Records Home . Data Warehouse Home

CRSE_SECT_SCHED_WITH Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Course_Num

Indexed - no
Format - Varchar2(5)
May be Null? Y

Number that identifies the course in the subject. The Subject and Course Number come from the COURSE table, no course section can have a Course Num that is not defined in COURSE. Source field: SSBSECT_CRSE_NUMB.

Course_ID

Indexed - no
Format - Varchar2(9)
May be Null? Y

The Subject area and the Course number concatenated into one field. This column, along with the term, can be used to join to the COURSE table when needed. Source fields: SSBSECT_SUBJ_CODE+SSBSECT_CRSE_NUMB.

Course_Ref_Num

Indexed - no
Format - Varchar2(5)
May be Null? Y

The internal Banner Course Reference Number. Source field: SSRXLST_CRN.

Crse_Sect_Sched_With_Pk

Indexed - yes
Format - Varchar2(26)
May be Null? N

internal warehouse primary key: based on TERM_CODE, XLST_GROUP and CRN

Group_Pri_Section_Id

Indexed - no
Format - Varchar2(12)
May be Null? Y

The SECTION_ID of the course section that is the primary member of a group of Scheduled-With course sections.

Pri_Sec_Ind

Indexed - no
Format - Varchar2(1)
May be Null? Y

For Scheduled-With courses sections, this code indicates whether the section is the (P) Primary or one of the (S) Secondary sections.

Primary_Course_ID

Indexed - no
Format - Varchar2(9)
May be Null? Y

For Scheduled-With courses sections, this is the Course ID (subject area + course number) of the primary section.

Primary_Course_Num

Indexed - no
Format - Varchar2(5)
May be Null? Y

For Scheduled-With courses sections, this is the course number of the primary section. Source: SSBSECT_CRSE_NUMB

Primary_Section_Num

Indexed - no
Format - Varchar2(3)
May be Null? Y

For Scheduled-With courses sections, this is the section number of the primary section. Source: SSBSECT_SEQ_NUMB

Primary_Subject

Indexed - no
Format - Varchar2(4)
May be Null? Y

For Scheduled-With courses sections, this is the subject area of the primary section. Source: SSBSECT_SUBJ_CODE

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

sysdate of the latest refresh of this warehouse table

Sched_With_Group

Indexed - no
Format - Varchar2(15)
May be Null? Y

Identifies the Scheduled With group to which the course section belongs in this term. Sections that are Schedule With each other meet at the same time in the same room and are taught by the same instructors. These can be cross-listed courses, or they can simply be courses that meet at the same time and place. Source field: SSRXLST_XLST_GROUP. See also table CRSE_SECT_SCHED_WITH_GRP

Section_Id

Indexed - no
Format - Varchar2(12)
May be Null? Y

Subject, Course Number, and Sequence number together uniquely identify a course section.

Section_Num

Indexed - no
Format - Varchar2(3)
May be Null? Y

Number that identifies the section of a course, associated with the Subject/Course Num. A Section number can only be used once to identify a Subject/Course Num combination in a term. (Note, however, multiple sections of a course can share a 0 section number.) Source field: SSBSECT_SEQ_NUMB.

Sect_Activity_Date

Indexed - no
Format - Date
May be Null? Y

The last date the section record was updated in the source. Source field: SSBSECT_ACTIVITY_DATE.

Ssbx_Activity_Date

Indexed - no
Format - Date
May be Null? Y

The last date the cross-listed section was updated in the source. Source field: SSRXLST_ACTIVITY_DATE.

Subject

Indexed - no
Format - Varchar2(4)
May be Null? Y

Code for the Subject Area associated with the course section. The Subject and Course Number come from the COURSE table, no course section can have a Subject that is not defined in COURSE. Source field: SSBSECT_SUBJ_CODE. Source validation table: STVSUBJ. Warehouse validation table: V_SUBJECT.

Term

Indexed - no
Format - Varchar2(6)
May be Null? Y

Section Scheduled With term. Source field: SSRXLST_TERM_CODE.

Xlist_Family

Indexed - no
Format - Varchar2(35)
May be Null? Y

Code shared by courses that are cross-listed with each other in the COURSE_XLIST table. Note: not all Scheduled With courses are cross-listed in the base table. If a section does not belong to a cross-list family, this column will be null. However, all cross-listed sections will have a group code. See Cautions and Notes for the CRSE_SECT_SCHED_WITH table.
Source field for XLIST_FAMILY: SCBSUPP_PERM_DIST_IND

CRSE_SECT_SCHED_WITH Table . 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