Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MIT STUDENT DIRECTORY Table


View exposing student directory data including names, office location, office phone, email, department, student year, and uppercase full name.


Field Name

Description

Data Type

Length

DEPARTMENT

Department associated with the record.

VARCHAR2

6

EMAIL_ADDRESS

Email address associated with the record.

VARCHAR2

60

FIRST_NAME

First name associated with the person.

VARCHAR2

15

FULL_NAME

Full name associated with the person.

VARCHAR2

93

LAST_NAME

Last name associated with the person.

VARCHAR2

60

MIDDLE_NAME

Middle name associated with the person.

VARCHAR2

15

OFFICE_LOCATION

Office location associated with the record.

VARCHAR2

30

OFFICE_PHONE

Office phone associated with the record.

VARCHAR2

9