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