WTW OLD TEACHING DETAIL Table
This table contains the detail of the OLD Who-is-Teaching-What data, from Fall 1999 ("2000FA") through Spring 2009 ("2009SP"). Used the "KEY" field in this table to join to the same-name tables (ie. Joining from this table to the WTW_OLD_SUBJECT_SECTION table using the WTW_OLD_SUBJECT_SECTION_KEY field, and joining from this table to the WTW_OLD_INSTRUCTOR table using the WTW_OLD_INSTRUCTOR_KEY field, and joining from this table to the WTW_OLD_INSTRUCTOR_ROLE table using the WTW_OLD_INSTRUCTOR_ROLE_KEY, and joining from this table to the WTW_ACADEMIC_TERM table using the WTW_ACADEMIC_TERM_KEY) to get the instructor 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 |
SLOT_INDEX |
A number indicating the relative position of each instructor within a given role of a subject. |
NUMBER |
3 |
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_OLD_INSTRUCTOR_KEY |
Use this field to join together tables WTW_OLD_TEACHING_DETAIL and WTW_OLD_INSTRUCTOR to get the information about the instructors for the teaching data in the OLD Who-is-Teaching-What data model. |
VARCHAR2 |
15 |
WTW_OLD_INSTRUCTOR_ROLE_KEY |
Use this field to join together tables WTW_OLD_TEACHING_DETAIL and WTW_OLD_INSTRUCTOR_ROLE to get the roles of the instructors in the subjects. |
VARCHAR2 |
24 |
WTW_OLD_SUBJECT_SECTION_KEY |
Use this field to join together tables WTW_OLD_TEACHING_DETAIL and WTW_OLD_SUBJECT_SECTION to get the information about the subjects and sections for the teaching or instructor role data in the OLD Who-is-Teaching-What data model. |
VARCHAR2 |
16 |