Data Dictionary
>
FPSAPP Tables
> FPSAPP.GP_C_PROCESS_ROUTE
Table FPSAPP.GP_C_PROCESS_ROUTE"
Goal planner configuration of PROCESS parameters that apply to specified ROUTESs. Used as input when calculating goals for the shift.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: FACILITY, PROCESS, ROUTE
-
Foreign keys: GP_C_PROCESS_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 |
|
PROCESS |
VARCHAR2(50) |
N |
Key field containing the process 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 process 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 |