Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SHA STUDENT Table


XXX


Field Name

Description

Data Type

Length

CITIZENSHIP_CODE

XXX

VARCHAR2

1

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

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

WAREHOUSE_LOAD_DATE

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

DATE