Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSAPP.DASH_P_WIP_LOT_TYPES
View used to get lot types for web pages.
|
Column |
Comment |
|---|---|
|
LOT_TYPE |
Lot_type is the base of the hierarchy that determines lot_family then lot_group. Ideally lot_type will come straight from the MES with little modification. (* inherited from FPSINPUT.WIP_LOT_TYPES) |
|
LOT_TYPE_DESCRIPTION |
|
|
LOT_FAMILY |
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. (* inherited from FPSINPUT.WIP_LOT_FAMILIES) |
|
SORT_ORDER_IN_FAM |
Sort order for the lot_type within the lot_family. (* inherited from FPSINPUT.WIP_LOT_TYPES) |
|
IS_SPECIAL_TW |
Specifies if this lot type is a special type of test wafer. This is used a grouping field for reporting. (* inherited from FPSINPUT.WIP_LOT_TYPES) |
|
LOT_GROUP |
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. (* inherited from FPSINPUT.WIP_LOT_GROUPS) |
|
DESCRIPTION |
Tool desciption. This value is only used to display in the Dashboard. (* inherited from FPSINPUT.EQP_TOOLS) |