Data Dictionary
>
FPSADMIN Tables
> FPSADMIN.SCH_G_CFG_SCHED_GROUPS_KPI
Table FPSADMIN.SCH_G_CFG_SCHED_GROUPS_KPI"
This table contains the default Scheduler KPI configuration for each sched_group
-
Schema: FPSADMIN
-
Tablespace: FPSDATA
-
Primary key: SCHED_GROUP, KPI_ID
-
Foreign keys: SCH_G_CFG_SGPS_KPI_FK_KID: KPI_ID REFERENCES FPSAPP.SCH_G_KPIS (KPI_ID)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
SCHED_GROUP |
VARCHAR2(36) |
N |
This is the grouping of tools and processes which the FPS Scheduler schedules together. Since this is a parent of tool via tool->process_group and a parent of process via process->process_group, by definition each tool and each process can only be in one sched group. We need all related tools and processes to be in the same sched group for efficient scheduling. One example is sinks and furnaces because of queue times and batching. Another example is for smaller facilities like Assembly or Test where we might schedule the entire facility together. (* from FPSINPUT.RTG_PROCESS_GROUPS) |
|
KPI_ID |
VARCHAR2(50) |
N |