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