| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date the Course co-requisite information was updated in the source table SCRGMOD. |
| Course_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | Subject and Course Number. |
| Course_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | Part of the unique identifer of a course: the course number and subject area, along with the effective term, uniquely identify a course. Most course numbers consist of 4 digits. Courses that are multi-term will also have an alpha character following the number. Source field: SCRGMOD_CRSE_NUMB. |
| Crse_Grade_Mode_Pk Indexed - yes
Format - Varchar2(15)
May be Null? N | Internal warehouse primary key, based on Subject area, Course Number, Term, and Grade Mode code. |
| Effective_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | First term of this version of this course attribute record. In the source system, courses are stored by effective term. Source field: SCRGMOD_EFF_TERM. Source validation table: STVTERM. Data Warehouse validation table: V_TERM. |
| Grade_Mode_Code Indexed - no
Format - Varchar2(1)
May be Null? Y | Code for the default grading mode to be used on this course when it is offered in a course section. Source field: SCRGMOD_GMOD_CODE. Source validation table: STVGMOD. |
| 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. |
| Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | Subject area of the course. Source field: SCRGMOD_SUBJ_CODE. Source validation table: STVSUBJ. Data Warehouse validation table: V_SUBJECT. |
| Term Indexed - no
Format - Varchar2(6)
May be Null? Y | A term in which this course version is in effect. The term-effective records in the source are turned into term-by-term records in the Data Warehouse extract/load process. |
