Data Dictionary
>
FPSBASE Tables
> FPSBASE.GP_C_RSEC_PROCESS_ROUTE
Table FPSBASE.GP_C_RSEC_PROCESS_ROUTE"
Goal planner configuration of ROUTE_SECTION parameters that apply to specified ROUTEs for each PROCESS. Used as input when calculating goals for the shift.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: FACILITY, ROUTE_SECTION, ROUTE_OR_EACH
-
Foreign keys: GP_C_RSEC_PROCESS_ROUTE_FK_FAC: FACILITY REFERENCES FPSINPUT.GEN_FACILITIES (FACILITY)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
FACILITY |
VARCHAR2(6) |
N |
Key field containing the facility name for any values applied in this table |
|
ROUTE_SECTION |
VARCHAR2(32) |
N |
Key field containing the section value for any of the override values set in this table |
|
ROUTE_OR_EACH |
VARCHAR2(256) |
N |
Key field set to either EACH for every route value within a given facility, or a specific Route value where any override values are set |
|
COMMENTS |
VARCHAR2(200) |
A comment field allowing a user to document the source or reason of the values populated in the table |
|
|
DRUM_QTY |
NUMBER(5) |
Desired shift run rate for a route section by route and process |
|
|
TARGET_WIP_MULTIPLIER |
NUMBER(4,2) |
Multiplier applied to the auto-calculated target WIP quantity to determine the effective WIP quantitiy. For example, if target WIP quantity is 100 and the multiplier is 1.5, then the effective target WIP quantitiy will be 150. Used to increase or decrease WIP buffer levels from normal level |