Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EMPLOYEE DIRECTORY FULL Table


A more basic version of DEPARTMENT_EMPLOYEE_DIRECTORY


Field Name

Description

Data Type

Length

ALTERNATE_OFFICE_ADDRESS

The person's secondary office address

VARCHAR2

40

ALTERNATE_OFFICE_PHONE

The telephone extension in the person's secondary office

VARCHAR2

14

ALT_OFFICE_ADDRESS_MIT_SITE

The person's alternate MIT office address

VARCHAR2

14

DIRECTORY_FULL_NAME

XXX

VARCHAR2

85

DIRECTORY_ORG_UNIT_NAME

same as Department name

VARCHAR2

50

DIRECTORY_ORG_UNIT_NUMBER

same as Department number

VARCHAR2

12

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

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

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

OFFICE_ADDRESS

Employee's primary office address, for example, W92-101, LL-B 341

VARCHAR2

40

OFFICE_ADDRESS_MIT_SITE

The person's primary office address on the main MIT campus (as opposed, e.g., to Lincoln Lab)

VARCHAR2

14

OFFICE_ADDR_SITE

The employee's site code, for example, LL (Lincoln Lab), MC (Main Campus), OS (other site)

VARCHAR2

2

OFFICE_PHONE

The person's primary office telephone number at MIT.

VARCHAR2

20