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