Data element |
Definition |
Activity_Date Indexed - no Format - Date May be Null? Y | The last date any part of this record was updated. Source field: SCRSCHD_ACTIVITY_DATE |
Adj_Workload Indexed - no Format - Number May be Null? Y | Source field: SCRSCHD_ADJ_WORKLOAD |
Course_Id Indexed - yes
Format - Varchar2(9) May be Null? Y | Subject area and Course number displayed together, with no spaces between subject and number. |
Course_Num Indexed - no
Format - Varchar2(5) May be Null? Y | Number associated with the Subject, that identifies the course. Source field: SCRSCHD_CRSE_NUMB. |
Crse_Sched_Type_Pk Indexed - yes
Format - Varchar2(18) May be Null? N | internal warehouse primary key: based on SUBJ_CODE, CRSE_NUMB, TERM and SCHD_CODE |
Effective_Term Indexed - no
Format - Varchar2(6) May be Null? Y | Effective term for this course record. Source field: SCRSCHD_EFF_TERM. |
Instructional_Method Indexed - no
Format - Varchar2(5) May be Null? Y | Source field: SCRSCHD_INSR_CODE |
Refresh_Date Indexed - no Format - Date May be Null? Y | The lastest date this warehouse table was refreshed. |
Sched_Type_Code Indexed - yes
Format - Varchar2(3) May be Null? Y | Code for the schedule type. Schedule types are the activities that can be used when offering the course. Examples: LEC - Lecture, SEM - Seminar, FLD - Field Work, DIS - DIssertation, etc. Source field: SCRSCHD_SCHD_CODE. Source validation table: STVSCHD. Warehouse validation table: V_SCHED_TYPE. |
Sched_Type_Desc Indexed - yes
Format - Varchar2(30) May be Null? Y | Description of the schedule type code. Source: STVSCHD_DESC. Warehouse validation table: V_SCHED_TYPE. |
Sched_Type_Contact_Hrs Indexed - no Format - Number May be Null? Y | Contact Hours for the specified Schedule Type. Source field: SCRSCHD_WORKLOAD |
Subject Indexed - no
Format - Varchar2(4) May be Null? Y | Subject area of the course. Source field: SCRSCHD_SUBJ_CODE. |
Term Indexed - yes
Format - Varchar2(6) May be Null? Y | A term in which this course version is in effect. |
Workload_Max_Enroll Indexed - no Format - Number May be Null? Y | Source field: SCRSCHD_MAX_ENRL |