Data Dictionary
>
FPSADMIN Tables
> FPSADMIN.WIP_LOT_PARAMETERS
Table FPSADMIN.WIP_LOT_PARAMETERS"
Table stores MES parameters and the respective value for a lot. Multiple parameters can be stored per lot.
-
Schema: FPSADMIN
-
Tablespace: FPSDATA
-
Primary key: LOT, PARAMETER_NAME
-
Foreign keys: WIP_LOT_PARAMETERS_FK_NAME: PARAMETER_NAME REFERENCES FPSINPUT.WIP_PARAMETERS (PARAMETER_NAME)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
LOT |
VARCHAR2(32) |
N |
A lot is a group of units that process together. Usually lot_id or lot_number in MES. All units in a lot are in the same carrier but there may be multiple lots in a carrier. (* from FPSINPUT.WIP_LOTS_STATIC) |
|
PARAMETER_NAME |
VARCHAR2(50) |
N |
The name of the parameter. |