data-dictionary
data-dictionary
Breadcrumbs

FPSBASE.GP_C_COMMON_STEP_ROUTE

Data Dictionary

>

FPSBASE Tables

> FPSBASE.GP_C_COMMON_STEP_ROUTE

Table FPSBASE.GP_C_COMMON_STEP_ROUTE"

Goal planner configuration of COMMON_STEP parameters that apply to specified ROUTEs. Used as input when calculating goals for the shift.

  • Schema: FPSBASE

  • Tablespace: FPSDATA

  • Primary key: FACILITY, COMMON_STEP, ROUTE

  • Foreign keys: GP_C_COMMON_STEP_ROUTE_FK_FAC: FACILITY REFERENCES FPSINPUT.GEN_FACILITIES (FACILITY)


Column

Type

Nullable

Comment

FACILITY

VARCHAR2(6)

N

Key field and must be populated with the facility name where the GP scenario will run

COMMON_STEP

VARCHAR2(50)

N

Key field containing the COMMON_STEP name within the route specified where override values will be set

ROUTE

VARCHAR2(256)

N

Key field containing the name for the sequence of steps that the lot must go through where override values will be set

COMMENTS

VARCHAR2(200)

A comment field allowing a user to document the source or reason of the values populated in the table

DRUM_QTY

NUMBER(5)

Desired shift run rate for a COMMON_STEP by route

TARGET_WIP_MULTIPLIER

NUMBER(4,2)

Multiplier applied to the auto-calculated target WIP quantity to determine the effective WIP quantitiy. For example, if target WIP quantity is 100 and the multiplier is 1.5, then the effective target WIP quantitiy will be 150. Used to increase or decrease WIP buffer levels from normal level