| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date the Course mutual exclusion information was updated for this course. Source field: SCRMEXC_ACTIVITY_DATE. |
| Course_Id Indexed - yes
Format - Varchar2(9)
May be Null? Y | A concatentation of the Subject code and the Course Number. Used to join tables in queries. |
| Course_Level Indexed - no
Format - Varchar2(2)
May be Null? Y | Course Level of the course identified by SUBJECT and COURSE_NUM. Source field: SCRMEXC_LEVL_CODE. Source validation table: STVLEVL. Warehouse validation table: V_LEVEL. |
| Course_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | Four digit number that, along with the Subject, identifies the course. Source field: SCRMEXC_CRSE_NUMB. |
| Crse_Mutual_Excl_Pk Indexed - yes
Format - Varchar2(66)
May be Null? N | Internal warehouse primary key, based on source primary key and term. |
| Effective_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | First term of this version of this mutual exclude record. In the source system, courses are stored by effective term. Source field: SCRMEXC_EFF_TERM. Source validation table: STVTERM. Data Warehouse validation table: V_TERM. |
| End_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | End term for the mutually exclusive course definition. Source field: SCRMEXC_END_TERM. |
| Grade_Excl Indexed - no
Format - Varchar2(6)
May be Null? Y | Minimum grade for the mutual exclusion restriction. Source field: SCRMEXC_GRDE_CODE. |
| Mutual_Excl_Course_Id Indexed - yes
Format - Varchar2(9)
May be Null? Y | A concatentation of the Subject code and the Course Number of the course that is mutually exclusive with the course identified in the COURSE_ID field. |
| Mutual_Excl_Crse_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | Four digit number that, along with the MUTUAL_EXCL_SUBJECT, identifies the mutually excluded course. Source field: SCRMEXC_CRSE_NUMB_MEXC. |
| Mutual_Excl_Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | Subject area of the course that is mutually excluded, that is, cannot be taken along with the course identified by SUBJECT and COURSE_NUM in this row. Source field: SCRMEXC_SUBJ_CODE_MEXC. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date this warehouse table was refreshed. |
| Source_Pk Indexed - no
Format - Number
May be Null? Y | Primary key in the term-effective source table. |
| Start_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Start term for the mutually exclusive course definition. Source field: SCRMEXC_START_TERM. |
| Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | Subject area of the course. Source field: SCRMEXC_CRSE_NUMB. Source validation table: STVSUBJ. Warehouse validation table: V_SUBJECT. |
| Term Indexed - yes
Format - Varchar2(6)
May be Null? Y | A term in which this course mutual exclude record is in effect. The term-effective records in the source are turned into term-by-term records in the Data Warehouse extract/load process. |
