Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SPACE PERSON SUPERVISOR Table


View exposing relationships between people and assigned space supervisors by DLC including supervisor identifiers, audit attributes, and count indicators.


Field Name

Description

Data Type

Length

COUNT

Count associated with the record.

CHAR

LAST_UPDATE_BY

Last update by associated with the record.

VARCHAR2

8

LAST_UPDATE_TIME

Time associated with last update.

DATE

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

Surrogate key identifying the relation dlc.

VARCHAR2

50

SUPERVISOR_ID

Business identifier for the supervisor.

VARCHAR2

9