Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WTW INSTRUCTOR ROLE Table


View exposing instructor role reference data used in the Who's Teaching What teaching data model, including roles such as lecturer, recitation instructor, lab instructor, and teaching assistant.


Field Name

Description

Data Type

Length

INSTRUCTOR_ROLE_FORMAT_SORT

Instructor role format sort associated with the record.

NUMBER

10

INSTRUCTOR_ROLE_FORMAT_TYPE

Instructor role format type associated with the record.

VARCHAR2

15

INSTRUCTOR_ROLE_FUNCTION

Instructor role function associated with the record.

VARCHAR2

30

INSTRUCTOR_SECTION_ROLE_ID

Business identifier for the instructor section role.

NUMBER

8

TEACHING_ROLE

Teaching role associated with the record.

VARCHAR2

50

TEACHING_ROLE_SORT_ORDER

Teaching role sort order associated with the record.

NUMBER

3

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

WTW_INSTRUCTOR_ROLE_KEY

Surrogate key identifying the wtw instructor role.

VARCHAR2

24