Data Dictionary
>
FPSBASE Tables
> FPSBASE.WIP_LOT_TYPES
Table FPSBASE.WIP_LOT_TYPES"
The set of possible lot types that can be assigned to various lots.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Foreign keys: WIP_LOT_TYPES_FK_FAM: LOT_FAMILY REFERENCES FPSINPUT.WIP_LOT_FAMILIES (LOT_FAMILY)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
LOT_TYPE |
VARCHAR2(24) |
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. |
|
|
DESCRIPTION |
VARCHAR2(256) |
Tool desciption. This value is only used to display in the Dashboard. (* from FPSINPUT.EQP_TOOLS) |
|
|
HIDE_ON_TOOLS_IN_NMV |
CHAR(1) |
Hides all lots of the test wafer lot type on the NextMove tool page and bay view. This should rarely be used and when it is used it should only be set to Y for specific test wafer lot types that you never want to see on the NextMove screens. |
|
|
IS_SPECIAL_TW |
CHAR(1) |
Specifies if this lot type is a special type of test wafer. This is used a grouping field for reporting. |
|
|
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. (* from FPSINPUT.WIP_LOT_FAMILIES) |
|
LOT_MSO_GROUP |
VARCHAR2(8) |
Grouping of lot types to be used specifically for the MSO application for tag conditions and counter settings. |
|
|
OLD_PROC_STATE |
VARCHAR2(25) |
In previous versions of ETP, this was the proc_state to assign in ETP_STATUS when lot of this type was processing. This column is no longer used except to transition from old version to new version. |
|
|
OVR_IS_SCHED |
CHAR(1) |
This flag overrides value from column is_sched of table wip_lot_groups. |
|
|
SORT_ORDER_IN_FAM |
NUMBER(2) |
N |
Sort order for the lot_type within the lot_family. |