WTW INSTRUCTOR Table
This table includes all instructors in the Who-is-Teaching-What data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_DEPARTMENT |
administrative department. |
VARCHAR2 |
50 |
ADMIN_POSITION_TITLE |
The title of the position of the administrative appointment |
VARCHAR2 |
50 |
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 |
DIRECTORY_TITLE |
A person's position title as listed in the MIT directory; this will be the person's "preferred" title if they specify a descriptive title that differs from their official MIT title (Primary_Title). |
VARCHAR2 |
50 |
ELIGIBLE_TO_REG |
A flag indicating the student is eligible to register for the term. Values include Y or N. NOTE: this flag means that the student has basic eligibility to register from the Registrar's perspective, i.e., s/he has been admitted for this term, is returning from a leave of absence or is a continuing student and has not graduated and has NOT been forced to withdraw for disciplinary or academic reasons. It does NOT MEAN that the student HAS NO HOLDS, financial, medical, or otherwise. |
VARCHAR2 |
1 |
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_FIRST_YEAR_GRAD |
Flag indicates whether the instructor is a first year graduate student for the academic term. Y=yes, N=no. |
VARCHAR2 |
1 |
IS_REGISTERED |
"Y" indicates that the student is currently registered. "N" indicates that the student is not currently registered. In the FINAID AID APPLICANT and FINAID APPLICANT tables, a "Y" in this field indicates that the student has registered for any one of the terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not registered in any one of the three terms of the aid year. |
VARCHAR2 |
1 |
IS_STUDENT |
In the STUDENT and STUDENT_ALL table, this flag indicates whether the person has ever been a student at MIT. In the WTW_INSTRUCTOR and WTW_OLD_INSTRUCTOR tables, this flag indicates whether this instructor was a current student, Y or N, for the specific term. In Payroll Person, indicates whether the person is currently a student, Y or N (i.e., the person may or may not have been a student in a past payroll period). |
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 |
STUDENT_HOME_DEPARTMENT |
The student's home department |
VARCHAR2 |
4 |
STUDENT_YEAR |
The student's primary year of degree for the current term. Values include 1,2,3,4 (for freshman through senior), G for Graduate, and U for Special Undergraduate. If the student is in the graduate school and also is still an undergraduate student, then this field should always contain a "G". The undergraduate year is then stored in the Undergraduate Year (UG YEAR) field, if applicable. |
VARCHAR2 |
1 |
TERM_CODE |
** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
WTW_INSTRUCTOR_KEY |
Use this field to join together tables WTW_TEACHING_DETAIL and WTW_INSTRUCTOR to get information about the instructors. |
VARCHAR2 |
15 |