Penn Computing

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

CRSE_SECT_OVERRIDE Table - Data Element Index

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

Data element Definition
Adm_Div_Ovrr

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

Administrative unit code, not currently used at Penn. Source field: SSBOVRR_DIVS_CODE. Source validation table: STVDIVS.

Course_Num

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

Number that along with the Subject Area and Section Number, identifies the Course Section in the term. 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: SSBOVRR_CRN

Crse_Section_Override_Pk

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

Internal warehouse primary key: based on TERM_CODE and CRN

Dept_Ovrr

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

Schedule Override Department Code. When a course section is set up for a department other than the department in the course catalog.Source field: SSBOVRR_DEPT_CODE.

Division_Ovrr

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

Schedule Override Division Code. When a course section is set up for a division other than the division in the course catalog. Source field: SSBOVRR_COLL_CODE.

Ovrr_Activity_Date

Indexed - no
Format - Date
May be Null? Y

The lastest date the section overrides were updated in the source. Source field: SSBOVRR_ACTIVITY_DATE.

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

The latest date this warehouse table was refreshed.

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. 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. Source field: SSBSECT_SUBJ_CODE. Source validation table: STVSUBJ. Warehouse validation table: V_SUBJECT.

Term

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

The term the course section is being offered. Source field: SSBOVRR_TERM_CODE

Tops_Ovrr

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

Schedule Override Taxonomy of Program Code, not currently used at Penn. Source field: SSBOVRR_TOPS_CODE. Source validation table: STVTOPS.

CRSE_SECT_OVERRIDE 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