data-dictionary
data-dictionary
Breadcrumbs

FPSBASE.WIP_LOT_FAMILIES

Data Dictionary

>

FPSBASE Tables

> FPSBASE.WIP_LOT_FAMILIES

Table FPSBASE.WIP_LOT_FAMILIES"

The purpose of lot family is for goal planning. We set goals by family and are allowed to switch goals for different lots of different types within the family. We also report goal performance by family.

  • Schema: FPSBASE

  • Tablespace: FPSDATA

  • Primary key: LOT_FAMILY

  • Foreign keys: WIP_LOT_FAMILIES_FK_GROUP: LOT_GROUP REFERENCES FPSINPUT.WIP_LOT_GROUPS (LOT_GROUP)

  • Referenced by: FPSINPUT.WIP_LOT_TYPES (LOT_FAMILY)


Column

Type

Nullable

Comment

LOT_FAMILY

VARCHAR2(24)

N

Lot_family is a grouping of lot_type which is mainly use for goal planning. We set goals by family and are allowed to switch goals for different lots of different types within the family. We also report goal performance by family.

DESCRIPTION

VARCHAR2(256)

Tool desciption. This value is only used to display in the Dashboard. (* from FPSINPUT.EQP_TOOLS)

LOT_GROUP

VARCHAR2(8)

N

Lot_group is a grouping of lot_family and is the highest grouping in the lot type hierarchy. There should be only a few values for lot_group, i.e. Prod, Dev, TW. We group WIP and moves by lot_group on the dashboard and we group cycle time calculations by lot_group so this is an important field. (* from FPSINPUT.WIP_LOT_GROUPS)

SORT_ORDER_IN_GROUP

NUMBER(2)

N

Sort order for the lot_family within the lot_group