Data Dictionary
>
FPSADMIN Tables
> FPSADMIN.GP_C_COMMON_STEP_ROUTE
Table FPSADMIN.GP_C_COMMON_STEP_ROUTE"
Goal planner configuration of COMMON_STEP parameters that apply to specified ROUTEs. Used as input when calculating goals for the shift.
-
Schema: FPSADMIN
-
Tablespace: FPSDATA
-
Primary key: FACILITY, COMMON_STEP, ROUTE
-
Foreign keys: GP_C_COMMON_STEP_ROUTE_FK_FAC: FACILITY REFERENCES FPSINPUT.GEN_FACILITIES (FACILITY)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
FACILITY |
VARCHAR2(6) |
N |
Key field and must be populated with the facility name where the GP scenario will run |
|
COMMON_STEP |
VARCHAR2(50) |
N |
Key field containing the COMMON_STEP name within the route specified where override values will be set |
|
ROUTE |
VARCHAR2(256) |
N |
Key field containing the name for the sequence of steps that the lot must go through where override values will be 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 COMMON_STEP by route |
|
|
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 |