Data Dictionary
>
FPSAPP Tables
> FPSAPP.GP_C_PROCFAM
Table FPSAPP.GP_C_PROCFAM"
Goal planner configuration of GP_SUBFAMILY parameters. Used as input when calculating goals for the shift.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Foreign keys: GP_C_PROCFAM_FK_FAC: FACILITY REFERENCES FPSINPUT.GEN_FACILITIES (FACILITY)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
FACILITY |
VARCHAR2(6) |
Key field and must be populated with the facility of the process family value that exists in the table |
|
|
GP_SUBFAMILY_OR_EACH |
VARCHAR2(36) |
Key field populated by either the word EACH when referring to the entire data set or a specific process family set by the GP administrator |
|
|
COMMENTS |
VARCHAR2(200) |
A comment field allowing a user to document the source or reason of the override values populated in the table |
|
|
OVR_CAP_MINS |
NUMBER(6) |
Override Capacity Minutes is an optional setting to allow the GP to use different values than the normal FPS Capacity value calculated by process family |
|
|
OVR_PLAN_AVAIL |
NUMBER(5,2) |
Override Plan Availability is an optional setting to allow the GP to use different values than the normal FPS Availability value calculated by process family |
|
|
OVR_PLAN_UTIL |
NUMBER(5 |
Override Plan Utilization is an optional settion to allow the GP to use different values than the normal FPS Utilization value calculated by process family |