WORK ORDER EQUIPMENT Table
View exposing equipment records associated with facilities work orders and related maintenance activity.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CURRENT_FUNCTIONAL_LOCATION |
Current functional location associated with the record. |
VARCHAR2 |
30 |
EQUIPMENT_CATEGORY |
Equipment category associated with the record. |
VARCHAR2 |
100 |
EQUIPMENT_CATEGORY_CODE |
Code identifying equipment category. |
VARCHAR2 |
1 |
EQUIPMENT_MANUFACTURER |
Equipment manufacturer associated with the record. |
VARCHAR2 |
30 |
EQUIPMENT_MODEL_NUMBER |
Equipment model number associated with the record. |
VARCHAR2 |
20 |
EQUIPMENT_SERIAL_NUMBER |
Equipment serial number associated with the record. |
VARCHAR2 |
30 |
EQUIPMENT_SYSTEM_STATUS |
Equipment system status associated with the record. |
VARCHAR2 |
40 |
EQUIPMENT_TYPE |
Equipment type associated with the record. |
VARCHAR2 |
100 |
EQUIPMENT_TYPE_CODE |
Code identifying equipment type. |
VARCHAR2 |
10 |
EQUIPMENT_VALID_FROM_DATE |
Date associated with equipment valid from. |
VARCHAR2 |
8 |
EQUIPMENT_VALID_THRU_DATE |
Date associated with equipment valid thru. |
VARCHAR2 |
8 |
LONG_TEXT_FLAG |
Indicator identifying whether long text (Y/N). |
VARCHAR2 |
1 |
PLANT_CODE |
Code identifying plant. |
VARCHAR2 |
4 |
SUPERIOR_EQUIPMENT |
Superior equipment associated with the record. |
VARCHAR2 |
1 |
SUPERIOR_EQUIPMENT_CODE |
Code identifying superior equipment. |
VARCHAR2 |
18 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WORK_ORDER_EQUIPMENT |
Work order equipment associated with the record. |
VARCHAR2 |
45 |
WORK_ORDER_EQUIPMENT_CODE |
Code identifying work order equipment. |
VARCHAR2 |
18 |
WORK_ORDER_EQUIPMENT_KEY |
Surrogate key identifying the work order equipment. |
VARCHAR2 |
18 |