WTW INSTRUCTOR Table
View exposing instructor records used in the Who's Teaching What teaching data model for subject, section, and evaluation reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_DEPARTMENT |
Admin department associated with the record. |
VARCHAR2 |
75 |
ADMIN_POSITION_TITLE |
Admin position title associated with the record. |
VARCHAR2 |
50 |
DEPARTMENT_1 |
Department 1 associated with the record. |
VARCHAR2 |
75 |
DEPARTMENT_2 |
Department 2 associated with the record. |
VARCHAR2 |
75 |
DEPARTMENT_3 |
Department 3 associated with the record. |
VARCHAR2 |
75 |
DEPARTMENT_4 |
Department 4 associated with the record. |
VARCHAR2 |
75 |
DIRECTORY_TITLE |
Directory title associated with the record. |
VARCHAR2 |
50 |
ELIGIBLE_TO_REG |
Indicator identifying whether eligible to reg (Y/N). |
VARCHAR2 |
1 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
100 |
FIRST_NAME |
First name associated with the person or organization. |
VARCHAR2 |
40 |
FULL_NAME |
Full name associated with the person or organization. |
VARCHAR2 |
100 |
HAS_ADDITIONAL_APPOINTMENT |
Indicator identifying whether additional appointment (Y/N). |
VARCHAR2 |
1 |
HAS_DUAL_APPOINTMENT |
Indicator identifying whether dual appointment (Y/N). |
VARCHAR2 |
1 |
IS_FIRST_YEAR_GRAD |
Indicator identifying whether first year grad (Y/N). |
VARCHAR2 |
1 |
IS_REGISTERED |
Indicator identifying whether registered (Y/N). |
VARCHAR2 |
1 |
IS_STUDENT |
Indicator identifying whether student (Y/N). |
VARCHAR2 |
1 |
KERBEROS_NAME |
Kerberos name associated with the record. |
VARCHAR2 |
30 |
LAST_NAME |
Last name associated with the person or organization. |
VARCHAR2 |
60 |
MIDDLE_NAME |
Middle name associated with the person or organization. |
VARCHAR2 |
40 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PAYROLL_RANK |
Payroll rank associated with the record. |
VARCHAR2 |
30 |
POSITION_TITLE_1 |
Position title 1 associated with the record. |
VARCHAR2 |
50 |
POSITION_TITLE_2 |
Position title 2 associated with the record. |
VARCHAR2 |
50 |
POSITION_TITLE_3 |
Position title 3 associated with the record. |
VARCHAR2 |
50 |
POSITION_TITLE_4 |
Position title 4 associated with the record. |
VARCHAR2 |
50 |
STUDENT_HOME_DEPARTMENT |
Student home department associated with the record. |
VARCHAR2 |
30 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
4 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WTW_INSTRUCTOR_KEY |
Surrogate key identifying the wtw instructor. |
VARCHAR2 |
15 |