data-dictionary
data-dictionary
Breadcrumbs

FPSBASE.SCH_G_CFG_SCHED_GROUPS_KPI

Data Dictionary

>

FPSBASE Tables

> FPSBASE.SCH_G_CFG_SCHED_GROUPS_KPI

Table FPSBASE.SCH_G_CFG_SCHED_GROUPS_KPI"

This table contains the default Scheduler KPI configuration for each sched_group

  • Schema: FPSBASE

  • 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