Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SPACE PERSON SUPVR SNAPSHOT Table


XXX


Field Name

Description

Data Type

Length

COUNT

XXX

NUMBER

LAST_UPDATE_BY

XXX

VARCHAR2

8

LAST_UPDATE_TIME

XXX

TIMESTAMP(6)

MIT_ID

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

VARCHAR2

9

RELATION_DLC_KEY

XXX

VARCHAR2

50

SUPERVISOR_ID

XXX

VARCHAR2

9

TIME_MONTH_KEY

Key used only for joining the TIME_MONTH table to other tables, NOT for reporting.

VARCHAR2

6

WAREHOUSE_INSERT_TIMESTAMP

XXX

TIMESTAMP(6)