Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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