Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WORK REQUEST CAUSE Table


View exposing reference values describing causes associated with facilities work requests.


Field Name

Description

Data Type

Length

CAUSE_CODE

Code identifying cause.

VARCHAR2

40

CAUSE_GROUP_CODE

Code identifying cause group.

VARCHAR2

13

CAUSE_GROUP_NAME

Cause group name associated with the record.

VARCHAR2

100

CAUSE_NAME

Cause name associated with the record.

VARCHAR2

40

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

WORK_REQUEST_CAUSE_KEY

Surrogate key identifying the work request cause.

VARCHAR2

13