WORK REQUEST WORK CATEGORY Table
View exposing reference values describing work categories associated with facilities work requests.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WORK_CATEGORY_CODE |
Code identifying work category. |
VARCHAR2 |
40 |
WORK_CATEGORY_GROUP_CODE |
Code identifying work category group. |
VARCHAR2 |
13 |
WORK_CATEGORY_GROUP_NAME |
Work category group name associated with the record. |
VARCHAR2 |
100 |
WORK_CATEGORY_NAME |
Work category name associated with the record. |
VARCHAR2 |
40 |
WORK_REQUEST_WORK_CATEGORY_KEY |
Surrogate key identifying the work request work category. |
VARCHAR2 |
13 |