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