WTW INSTRUCTOR ROLE Table
This is a dimension table used in the Who-is-Teaching-What data model. It contains all the teaching roles (eg. Lecturer, Recitation Instructor, Teaching Assistant, Writing Instructor, etc.)
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
INSTRUCTOR_ROLE_FORMAT_SORT |
Use this field to sort instructor role records by Instructor Role Format. |
NUMBER |
3 |
INSTRUCTOR_ROLE_FORMAT_TYPE |
The format of the subject section in which the instructor teaches. Format types include: Lecture, Lab, Recitation, Discussion, Large Ensemble, Tutorial, etc. |
VARCHAR2 |
15 |
INSTRUCTOR_ROLE_FUNCTION |
Function of the instructor's role -- Delivers primary instruction, Assists with instruction, etc. |
VARCHAR2 |
30 |
INSTRUCTOR_SECTION_ROLE_ID |
A number identifies the instructor role in a section of a subject. |
NUMBER |
8 |
TEACHING_ROLE |
Teaching roles, eg. Lecturer, Recitation Lecturer, Lab Instructor, Teaching Assistant, Writing Instructor, etc. |
VARCHAR2 |
50 |
TEACHING_ROLE_SORT_ORDER |
Use this field to sort instructor role records by Teaching Role. |
NUMBER |
3 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
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 |