| Data element |
Definition |
| Attribute_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for the attribute associated with this course record. Source field: SCRATTR_ATTR_CODE. Source validation table: STVATTR. Data Warehouse validation table: V_CRSE_PROG_ATTR. |
| Course_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | Subject area and course number displayed together (no space added). |
| 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: SCRATTR_CRSE_NUMB. |
| Crse_Attribute_Pk Indexed - yes
Format - Varchar2(19)
May be Null? N | Internal warehouse primary key, based on the subject code, course number, term, and attribute code. |
| Effective_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | First term of this version of this course record. In the source system, courses are stored by effective term. Source field: SCRATTR_EFF_TERM. Source validation table: STVTERM. Data Warehouse validation table: V_TERM. |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date the Course Attribute information was updated in the source table SCRATTR. |
| 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: SCRATTR_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. |
