TEACHING FACULTY Table
View exposing faculty teaching and thesis-supervision detail including MIT identifier, names, Kerberos username, email, payroll rank, administrative department, appointment indicators, up to four departmental appointments, teaching indicators, and anonymous identifier.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_TERMS_KEY |
Surrogate key identifying the academic terms. |
VARCHAR2 |
6 |
ADMIN_DEPARTMENT |
Admin department associated with the record. |
VARCHAR2 |
75 |
ADMIN_POSITION_TITLE |
Admin position title associated with the record. |
VARCHAR2 |
50 |
ANONYMOUS_ID |
Business identifier for the anonymous. |
VARCHAR2 |
17 |
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 |
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_TEACHING |
Indicator identifying whether teaching (Y/N). |
VARCHAR2 |
1 |
IS_THESIS_SUPERVISOR |
Indicator identifying whether thesis supervisor (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 |
TEACHING_FACULTY_KEY |
Surrogate key identifying the teaching faculty. |
VARCHAR2 |
15 |
THESIS_SUPERVISOR_KEY |
Surrogate key identifying the thesis supervisor. |
VARCHAR2 |
15 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |