Penn Computing

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

CRSE_SECT_ATTRIBUTE Table - Data Element Index

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

Data element Definition
Attribute_Code

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

The course section attribute code. Source field: SSRATTR_ATTR_CODE. Source validation table: STVATTR. Warehouse validation table: V_CRSE_PROG_ATTR

Attribute_Desc

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

Description of the Attribute Code. Source field: STVATTR_DESC.

Attr_Activity_Date

Indexed - no
Format - Date
May be Null? Y

The last date the section attributes were updated in the source. Source field: SSRATTR_ACTIVITY_DATE.

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 - yes
Format - Varchar2(5)
May be Null? Y

The internal Banner Course Reference Number. Source field: SSRATTR_CRN

Crse_Section_Attribute_Pk

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

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

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date of the latest refresh of this warehouse table

Section_Id

Indexed - yes
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.

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.

Term

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

The term the course section is being offered, and in which this course section attribute is in effect. Source field: SSRATTR_TERM_CODE

CRSE_SECT_ATTRIBUTE 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