WTW OLD INSTRUCTOR Table
View exposing instructor records used in the old Who's Teaching What teaching data model.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
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 |
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_OLD_INSTRUCTOR_KEY |
Surrogate key identifying the wtw old instructor. |
VARCHAR2 |
15 |