Data Dictionary
>
FPSBASE Tables
> FPSBASE.GP_C_COMMON_STEP
Table FPSBASE.GP_C_COMMON_STEP"
Goal planner configuration of COMMON_STEP parameters. Used as input when calculating goals for the shift.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: FACILITY, COMMON_STEP
-
Foreign keys: GP_C_COMMON_STEP_FK_FAC: FACILITY REFERENCES FPSINPUT.GEN_FACILITIES (FACILITY)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
FACILITY |
VARCHAR2(6) |
N |
Key field containing the name of the facility where GP scenarios will be run |
|
COMMON_STEP |
VARCHAR2(50) |
N |
key field populated with the common step that will have override data associated to them |
|
COMMENTS |
VARCHAR2(200) |
A comment field allowing a user to document the source or reason of the override values populated in the table |