Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FPR PEOPLE RECORD Table


XXX


Field Name

Description

Data Type

Length

MIT_ID

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

VARCHAR2

9

PERSONNEL_KEY

Key field used to join to the PERSONNEL table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

8

WAREHOUSE_LOAD_DATE

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

DATE