Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TIP MATERIAL STATUS Table


View exposing instructional material-status reference data including status code, status description, and warehouse load date.


Field Name

Description

Data Type

Length

TIP_MATERIAL_STATUS

Tip material status associated with the record.

VARCHAR2

50

TIP_MATERIAL_STATUS_CODE

Code identifying tip material status.

VARCHAR2

4

TIP_MATERIAL_STATUS_KEY

Surrogate key identifying the tip material status.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE