Data Dictionary
>
FPSADMIN Tables
> FPSADMIN.GP_C_RSEC_COMMON_STEP_ROUTE
Table FPSADMIN.GP_C_RSEC_COMMON_STEP_ROUTE"
Goal planner configuration of ROUTE_SECTION parameters that apply to specified ROUTEs for each COMMON_STEP. Used as input when calculating goals for the shift.
-
Schema: FPSADMIN
-
Tablespace: FPSDATA
-
Primary key: FACILITY, ROUTE_SECTION, ROUTE_OR_EACH
-
Foreign keys: GP_C_RSEC_COMSTEP_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 COMMON_STEP |
|
|
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 |