Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP INVESTIGATOR Table


OSP Proposal Investigator information


Field Name

Description

Data Type

Length

DEPARTMENT_NAME

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

VARCHAR2

50

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

FULL_NAME

The full name of the person.

VARCHAR2

90

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

NON_MIT_ORG_NAME

XXX

VARCHAR2

50

NON_MIT_TITLE

XXX

VARCHAR2

30

OFFICE_ADDRESS

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

VARCHAR2

40

OFFICE_PHONE

The person's primary office telephone number at MIT.

VARCHAR2

20

OSP_INVESTIGATOR_KEY

XXX

VARCHAR2

12