Data element |
Definition |
Activity_Date Indexed - no Format - Date May be Null? Y | The latest date the record was updated in the source. Source field: SCRRTST_ACTIVITY_DATE. |
Concurrency_Ind Indexed - no
Format - Varchar2(1) May be Null? Y | Indicates that the course and the pre-requisite course can be taken at the same time. Source field: SCRRTST_CONCURRENCY_CDE. |
Course_Id Indexed - yes
Format - Varchar2(9) May be Null? Y | Subject area and Course Number concatenated, with no space between the subject and course number. |
Course_Id_Prereq Indexed - yes
Format - Varchar2(9) May be Null? Y | Similar format as Course_ID: Subject Area and Course Number of the prerequisite course. |
Course_Num Indexed - no
Format - Varchar2(5) May be Null? Y | Four digit number that, along with the Subject, identifies the course. Source field: SCRRTST_CRSE_NUMB. |
Course_Num_Prereq Indexed - no
Format - Varchar2(5) May be Null? Y | Four digit course number that, along with the SUBJECT_PREREQ, defines the pre-requisite course. Source field: SCRRTST_CRSE_NUMB_PREQ. |
Crse_Prereq_Pk Indexed - yes
Format - Varchar2(24) May be Null? N | Internal warehouse primary key, based on Subject, Course Number, Term, pre-requisite Subject, and pre-requisite Course Number. |
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: SCRRTST_EFF_TERM. Source validation table: STVTERM. Data Warehouse validation table: V_TERM. |
Min_Grade Indexed - no
Format - Varchar2(6) May be Null? Y | Minimum grade that can be used to meet the pre-requisite. Source field: SCRRTST_MIN_GRDE. |
Prereq_Level Indexed - no
Format - Varchar2(2) May be Null? Y | Level code for the grade received in the pre-requisite course. Source field: SCRRTST_LEVL_CODE. Source validation table: STVLEVL. Data Warehouse validation table: V_STDNT_LEVEL. |
Refresh_Date Indexed - no Format - Date May be Null? Y | The latest date this warehouse table was refreshed. |
Sequence_Num Indexed - no Format - Number May be Null? Y | Internal sequence number used to define the presentation order in the source system. |
Subject Indexed - yes
Format - Varchar2(4) May be Null? Y | Subject area of the course. Source field: SCRRTST_SUBJ_CODE. Source validation table: STVSUBJ. Data Warehouse validation table: V_SUBJECT. |
Subject_Prereq Indexed - no
Format - Varchar2(4) May be Null? Y | Subject area of the pre-requisite course. Source field: SCRRTST_SUBJ_CODE_PREQ. Source validation table: STVSUBJ. Data Warehouse validation table: V_SUBJECT. |
Term Indexed - yes
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. |