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