Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FACULTY DIRECTORY Table


Faculty directory


Field Name

Description

Data Type

Length

DEPARTMENT_NAME

The name of the department, school, center, or lab.

VARCHAR2

50

DEPARTMENT_NUMBER

The Institute-assigned identification number of a department, school, center, or lab.

VARCHAR2

6

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

EMPLOYEE_TYPE

The categorization of MIT employees based on PERSONNEL_SUBAREA, but not as specific. Examples: Faculty, Other Academics, or Medical.

VARCHAR2

30

FIRST_NAME

The person's first name.

VARCHAR2

30

FULL_NAME

The full name of the person.

VARCHAR2

90

KRB_NAME

Kerberos Name

VARCHAR2

8

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

OFFICE_LOCATION

The person's primary office address at MIT.

VARCHAR2

30

OFFICE_PHONE

The person's primary office telephone number at MIT.

VARCHAR2

20

PERSONAL_URL

The employee's personal URL.

VARCHAR2

241

PERSONNEL_SUBAREA

Text that further identifies the personnel area into sub groupings of Positions,e.g., Admin Staff, Support Staff. Similar to the old Rank Lists values.

VARCHAR2

30

PRIMARY_TITLE

A person's primary appointment title.

VARCHAR2

51

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8