WORK ORDER CATEGORY Table
View exposing reference values describing facilities work order categories used for maintenance classification and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WORK_ORDER_CATEGORY_CODE |
Code identifying work order category. |
VARCHAR2 |
20 |
WORK_ORDER_CATEGORY_DESC |
Description of work order category. |
VARCHAR2 |
40 |
WORK_ORDER_CATEGORY_KEY |
Surrogate key identifying the work order category. |
VARCHAR2 |
7 |
WORK_ORDER_SUBCATEGORY_CODE |
Code identifying work order subcategory. |
VARCHAR2 |
20 |
WORK_ORDER_SUBCATEGORY_DESC |
Description of work order subcategory. |
VARCHAR2 |
40 |
WORK_ORDER_TYPE |
Work order type associated with the record. |
VARCHAR2 |
4 |
WORK_REQUEST_TYPE |
Work request type associated with the record. |
VARCHAR2 |
2 |