Data Dictionary
>
FPSAPP Tables
> FPSAPP.GP_C_PROCFAM_PROCESS_ROUTE
Table FPSAPP.GP_C_PROCFAM_PROCESS_ROUTE"
Goal planner configuration of GP_SUBFAMILY parameters that apply to specified ROUTEs for each PROCESS. Used as input when calculating goals for the shift.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: FACILITY, GP_SUBFAMILY_OR_EACH, ROUTE_OR_EACH
-
Foreign keys: GP_C_PROCFAM_PROCESS_RO_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 |
|
GP_SUBFAMILY_OR_EACH |
VARCHAR2(36) |
N |
Key field containing the subfamily name or EACH when all values are specified for the values specified 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 process family 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 |