LAB MGMNT DIRECTORY Table
EH&S lab management personnel directory information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_TYPE |
In the various APPOINTMENT tables (ie, MIT Employees): For Faculty, identifies whether they have a 9-, 10-, 11-, or 12-month appointment. This information is used to position faculty members with their peers in salary reviews; also determines whether they are eligible to receive summer salary (1, 2, or 3 months). For other MIT employees, specifies whether the appointment is Regular, Term (= has a specified end date), Temporary (normally of more than 2 and less than 12 months duration), or Summer only. In the GRADUATE AWARD tables, specifies the type of Graduate Student Appointment: RA, TA, etc. In the KRB_PERSON table, indicates whether the appointment is Primary or Secondary. |
VARCHAR2 |
30 |
DATE_LAST_UPDATED |
The date on which the warehouse data was last updated. |
DATE |
8 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
EMPLOYEE_TITLE |
The person's job title, from HR. |
VARCHAR2 |
51 |
EMPLOYEE_UNIT_ID |
The 6-digit HR org unit number (sometimes matches the profit center number) of the department where the trainee works. |
VARCHAR2 |
6 |
EMPLOYEE_UNIT_NAME |
The name of the DLC where the contact person works, according to HR. |
VARCHAR2 |
50 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
HOME_PHONE |
The person's home telephone number. |
VARCHAR2 |
20 |
KRB_NAME_UPPERCASE |
The Kerberos username of a person, in uppercase. |
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 |
PRIMARY_OFFICE_LOCATION |
The primary office building-room number of the person. |
VARCHAR2 |
30 |
PRIMARY_OFFICE_PHONE |
The primary office phone number of the person. |
VARCHAR2 |
20 |
SECONDARY_OFFICE_LOCATION |
The secondary office building-room number of the person, where listed. |
VARCHAR2 |
30 |
SECONDARY_OFFICE_PHONE |
The secondary office phone of the person, where listed. |
VARCHAR2 |
20 |
STUDENT_DEPARTMENT |
For students, the course number of the student's major. |
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 |
SUPPRESS_EMPL_HOME |
XXX |
VARCHAR2 |
1 |
TYPE |
Identifies the type of person (Employee, Student, Other). |
VARCHAR2 |
8 |