Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP WORKLOAD SIM UNIT ASSIGN Table


View exposing osp workload sim unit assign data.


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

40

SIM_ID

Business identifier for the sim.

NUMBER

SIM_UNIT_ASSIGNMENTS_ID

Business identifier for the sim unit assignments.

NUMBER

12

UNIT_NUMBER

Unit number associated with the record.

VARCHAR2

8

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