Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WORK ORDER CRAFT Table


View exposing reference values describing craft classifications used in facilities work orders and maintenance reporting.


Field Name

Description

Data Type

Length

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

WORK_ORDER_CRAFT

Work order craft associated with the record.

VARCHAR2

30

WORK_ORDER_CRAFT_CODE

Code identifying work order craft.

VARCHAR2

13

WORK_ORDER_CRAFT_KEY

Surrogate key identifying the work order craft.

VARCHAR2

13