WTW OLD INSTRUCTOR ROLE Table
This is a dimension table used in the OLD Who-is-Teaching-What data model. The table contains all the instructor roles -- example: Lecturer, Administration, Recitation Instructor, Lab Instructor, etc.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
INSTRUCTOR_ROLE |
One of the roles an instructor of a subject holds: LECTUR (lecturer), LAB (lab instructor), RECIT (recitation instructor), GRADE (grader), TUTOR, etc. |
VARCHAR2 |
6 |
INSTRUCTOR_ROLE_CODE |
The code of an instructor role in the OLD Who's Teaching What data. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
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 |