WTW TEACHING DETAIL Table
This table contains the detail of the Who-is-Teaching-What data since Fall Term 2009 (ie. 2010FA). Used the "KEY" field in this table to join to the same-name table (eg. Joining from this table to the WTW_SUBJECT_SECTION table using the WTW_SUBJECT_SECTION_KEY field, and joining from this table to the WTW_INSTRUCTOR table using the WTW_INSTRUCTOR_KEY field, and joining from this table to the WTW_INSTRUCTOR_ROLE table using the WTW_INSTRUCTOR_ROLE_KEY, and joining from this table to the WTW_ACADEMIC_TERM table using the WTW_ACADEMIC_TERM_KEY) to get the teaching roles of each of the instructors in the different terms, subjects and sections.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
WTW_ACADEMIC_TERM_KEY |
Use this field to join together tables WTW_TEACHING_DETAIL and WTW_ACADEMIC_TERM to get the academic term information for the teaching data. |
VARCHAR2 |
6 |
WTW_INSTRUCTOR_KEY |
Use this field to join together tables WTW_TEACHING_DETAIL and WTW_INSTRUCTOR to get information about the instructors. |
VARCHAR2 |
15 |
WTW_INSTRUCTOR_ROLE_KEY |
Use this field to join together tables WTW_TEACHING_DETAIL and WTW_INSTRUCTOR_ROLE to get information about the various teaching roles of the instructors. |
VARCHAR2 |
24 |
WTW_SUBJECT_SECTION_KEY |
Use this field to join together tables WTW_TEACHING_DETAIL and WTW_SUBJECT_SECTION to get information about the subjects and sections for the teaching data. |
VARCHAR2 |
16 |