Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP WORKLOAD SIM FLEXIBILITY Table


View exposing osp workload sim flexibility data.


Field Name

Description

Data Type

Length

FLEXIBILITY

Flexibility associated with the record.

NUMBER

4,2

MIT_ID

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

VARCHAR2

40

SIM_FLEXIBILITY_ID

Business identifier for the sim flexibility.

NUMBER

12

SIM_ID

Business identifier for the sim.

NUMBER

SPONSOR_GROUP

Sponsor group associated with the record.

VARCHAR2

50

UPDATE_TIMESTAMP

Timestamp associated with update.

DATE

UPDATE_USER

Update user associated with the record.

VARCHAR2

60

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE