Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR PERSON ACCESSIBLE Table


View exposing accessible person reference data including person identifiers and core attributes available for general reporting use.


Field Name

Description

Data Type

Length

FIRST_NAME

Column FIRST_NAME.

VARCHAR2

40

FULL_NAME

Column FULL_NAME.

VARCHAR2

100

LAST_NAME

Column LAST_NAME.

VARCHAR2

40

MIDDLE_INITIAL

Column MIDDLE_INITIAL.

VARCHAR2

10

MIDDLE_NAME

Column MIDDLE_NAME.

VARCHAR2

40

MIT_ID

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

VARCHAR2

9