Data Dictionary
>
FPSBASE Tables
> FPSBASE.SCH_G_EVALUATIONS
Table FPSBASE.SCH_G_EVALUATIONS"
This table is used to setup all basic evaluations that will be used on the sched group weights.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: EVALUATION_ID
-
Referenced by: FPSAPP.SCH_C_EVALUATIONS (EVALUATION_ID) FPSAPP.SCH_G_CFG_SCHED_GROUPS_EVL (EVALUATION_ID)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
EVALUATION_ID |
VARCHAR2(50) |
N |
|
|
CALCULATION_METHOD |
VARCHAR2(500) |
||
|
DEFAULT_INPUT_DESC |
NVARCHAR2(2000) |
||
|
DEFAULT_INPUT_DISPLAY |
VARCHAR2(500) |
||
|
DEFAULT_INPUT_ID |
VARCHAR2(50) |
||
|
DEFAULT_WEIGHTS |
NUMBER |
||
|
EVALUATION_TYPE |
VARCHAR2(36) |
||
|
MAX_WEIGHTS |
NUMBER |
used to determine the maximum weight for eachF evaluation |
|
|
MIN_WEIGHTS |
NUMBER |
used to determine the minimum weight for each evaluation |
|
|
SHOULD_APPLY_TO_STAGING_STEP |
CHAR(1) |
This is to indicate if this evaluation item should be applied to the staging step while the scheduler is compiling the lot score on the lot level. usually any evaluation releated to the tool should be set to N. |