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