| Data element |
Definition |
| Course_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | Subject and Course Number concatenated together. Can be used, along with the Term, to join to the COURSE table. |
| Course_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | Number (stored as character) 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_Ref_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | The internal Banner Course Reference Number (CRN) assigned to this course section, this uniquely identifies a course section in a term, in the source system. Source field: SSBSECT_CRN. |
| Crse_Sect_Grade_Mode_Pk Indexed - yes
Format - Varchar2(11)
May be Null? N | Internal warehouse primary key: based on Term, Course Reference Number (CRN), and Grade_Mode. |
| Grade_Mode Indexed - no
Format - Varchar2(1)
May be Null? Y | Code for a Grade Mode that can be used by students enrolling in this course section. At Penn, grade modes follow the student, not the course. Course sections have multiple potential grade modes associated with the section; the student choose the appropriate one when they register for the course section.
Calculated in CLSS based on the "Q" course attributes assigned to the course, that are translated into the available grade modes for the section. Source validation table: STVGMOD. Data Warehouse validation table: V_GRADE_MODE |
| Grade_Mode_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Description of the grade mode code. Source: STVGMOD_DESC. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date this warehouse table was refreshed. |
| Section_Id Indexed - no
Format - Varchar2(12)
May be Null? Y | Subject, Course Number, and Sequence number concatenated together. |
| Section_Num Indexed - no
Format - Varchar2(3)
May be Null? Y | Number (stored as character) 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. |
| 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. Data Warehouse validation table: V_SUBJECT |
| Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Code for the term in which the course section is offered. Source field: SSBSECT_TERM_CODE. Source validation table: STVTERM. Data Warehouse validation table: V_TERM. |
