TEACHING FACULTY Table
This table contains a record for an instructor per academic term in which the instructor was teaching a class/subject and/or a graduate thesis supervisor. Users will need to have the authorizations to view both subject enrollment and teaching data in order to access data in this table.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_TERMS_KEY |
Use this field to join to the ACADEMIC_TERMS table to get information about the academic term(s). |
VARCHAR2 |
6 |
ADMIN_DEPARTMENT |
administrative department. |
VARCHAR2 |
50 |
ADMIN_POSITION_TITLE |
The title of the position of the administrative appointment |
VARCHAR2 |
50 |
ANONYMOUS_ID |
XXX |
VARCHAR2 |
17 |
DEPARTMENT_1 |
The department where the position is held. |
VARCHAR2 |
4 |
DEPARTMENT_2 |
The department where position #2 is held, if applicable. |
VARCHAR2 |
4 |
DEPARTMENT_3 |
The department where position #3 is held, if applicable. |
VARCHAR2 |
4 |
DEPARTMENT_4 |
The department where position #4 is held, if applicable. |
VARCHAR2 |
4 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
HAS_ADDITIONAL_APPOINTMENT |
'Y'=the person (instructor) has more than one appointment/position. 'N' otherwise. |
VARCHAR2 |
1 |
HAS_DUAL_APPOINTMENT |
An indicator that the employee has a dual appointment, Y or N. |
VARCHAR2 |
1 |
IS_TEACHING |
XXX |
VARCHAR2 |
1 |
IS_THESIS_SUPERVISOR |
XXX |
VARCHAR2 |
1 |
KERBEROS_NAME |
The Kerberos username of the person. If this field starts with a dollar sign ($), then it is not a real Kerberos username, but an algorithmically generated pseudo Kerberos username, used as a placeholder in the EHS system. |
VARCHAR2 |
8 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
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 |
Rank of instructors. Eg.: Professor, Teaching Assistant, Lecturer, Assistant Professor, Associate Professor with tenure, Research Assistant, Grad Student Fellow, Associate Professor w/o tenure, Instructor, senior Lecturer, Technical Instructor, etc. |
VARCHAR2 |
30 |
POSITION_TITLE_1 |
Position title. |
VARCHAR2 |
50 |
POSITION_TITLE_2 |
Position title #2, if applicable. |
VARCHAR2 |
50 |
POSITION_TITLE_3 |
Position title #3, if applicable. |
VARCHAR2 |
50 |
POSITION_TITLE_4 |
Position title #4, if applicable. |
VARCHAR2 |
50 |
TEACHING_FACULTY_KEY |
XXX |
VARCHAR2 |
15 |
THESIS_SUPERVISOR_KEY |
XXX |
VARCHAR2 |
15 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |