WORK CENTER Table
View exposing work center reference data used to identify facilities maintenance and operational work groups.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
PLANT_CODE |
Code identifying plant. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WORK_CENTER |
Work center associated with the record. |
VARCHAR2 |
40 |
WORK_CENTER_ACTIVITY |
Work center activity associated with the record. |
VARCHAR2 |
100 |
WORK_CENTER_ACTIVITY_CODE |
Code identifying work center activity. |
VARCHAR2 |
6 |
WORK_CENTER_CODE |
Code identifying work center. |
VARCHAR2 |
8 |
WORK_CENTER_COST_CENTER_ID |
Business identifier for the work center cost center. |
VARCHAR2 |
8 |
WORK_CENTER_COST_CENTER_NAME |
Work center cost center name associated with the record. |
VARCHAR2 |
40 |
WORK_CENTER_KEY |
Surrogate key identifying the work center. |
VARCHAR2 |
8 |
WORK_CENTER_VALID_FROM_DATE |
Date associated with work center valid from. |
DATE |
|
WORK_CENTER_VALID_THRU_DATE |
Date associated with work center valid thru. |
DATE |