Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WORK REQUEST DAMAGE Table


View exposing reference values describing damage classifications associated with facilities work requests.


Field Name

Description

Data Type

Length

DAMAGE_CODE

Code identifying damage.

VARCHAR2

40

DAMAGE_GROUP_CODE

Code identifying damage group.

VARCHAR2

13

DAMAGE_GROUP_NAME

Damage group name associated with the record.

VARCHAR2

100

DAMAGE_NAME

Damage name associated with the record.

VARCHAR2

40

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

WORK_REQUEST_DAMAGE_KEY

Surrogate key identifying the work request damage.

VARCHAR2

13