Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.MSO_TAG_CONDITION_CONTEXT
Table FPSINPUT.MSO_TAG_CONDITION_CONTEXT"
This table has the user defined context of the tag condition. A single tag condition can have multiple conditions defined. Each row for a single tag_condition_id, one case needs to match. For a single row all the defined column values must be true for that context row to be true, where NA means we ignore that column value.
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Foreign keys: MSO_TAG_COND_CONTXT_LOT_FK: TAG_CONDITION_ID REFERENCES FPSBASE.MSO_TAG_CONDITIONS (TAG_CONDITION_ID)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
TAG_CONDITION_ID |
NUMBER(9) |
Unique tag condition identification number. (* from FPSBASE.MSO_TAG_CONDITIONS) |
|
|
YNA_CHILD_LOT |
VARCHAR2(3) |
Lots that are defined as child lots with a value of YES or NO will be tagged or never be tagged depending on the condition type selected. |
|
|
YNA_FIRST_LOT_IN_JOB |
VARCHAR2(3) |
Lots that are defined as first lot in job with a value of YES or NO will be tagged or never be tagged depending on the condition type selected. |
|
|
LOT_NA |
VARCHAR2(16) |
Lots that have a matching lot id will be tagged or never be tagged depending on the condition type selected. |
|
|
LOT_GROUP_NA |
VARCHAR2(8) |
N |
Lots that are of the defined lot mso group will be tagged or never tagged, depending on the condition type that is selected. If the value is NA the check is ignored. |
|
LOT_MSO_GROUP_NA |
VARCHAR2(8) |
N |
This is the counter definition value for lot mso group. If lot mso group is not part of the rule definition and included in the counter then it will be NA, otherwise it will have the lot mso group value. (* from FPSBASE.MSO_PROCESS_HIST) |
|
LOT_PARM_NAME |
VARCHAR2(32) |
Lots that have this MES parameter set with its corresponding value will be tagged or never tagged, depending on the condition type that is selected. If the value is NULL the check is ignored. |
|
|
LOT_PARM_VALUE |
VARCHAR2(32) |
Lots that have this MES parameter value will be tagged or never tagged, depending on the condition type that is selected. If the value is NULL the check is ignored. |
|
|
PLAN_PRIORITY_NA |
VARCHAR2(7) |
N |
Lots that are of the defined plan priority will be tagged or never tagged, depending on the condition type that is selected. If the value is NA the check is ignored. |
|
PRD_NA |
VARCHAR2(64) |
N |
Lots that are of the defined product will be tagged or never tagged, depending on the condition type that is selected. If the value is NA the check is ignored. |
|
PRD_MSO_GROUP_NA |
VARCHAR2(64) |
N |
Lots that are of a product in the defined PRD_MSO_GROUP will be tagged or never tagged, depending on the condition type that is selected. If the value is NA the check is ignored. |
|
ROUTE_NA |
VARCHAR2(256) |
N |
Lots that are of the defined route will be tagged or never tagged, depending on the condition type that is selected. If the value is NA the check is ignored. |
|
ROUTE_MSO_GROUP_NA |
VARCHAR2(64) |
N |
Lots that are of a part in the defined ROUTE_MSO_GROUP will be tagged or never tagged, depending on the condition type that is selected. If the value is NA the check is ignored. |
|
MIN_QTY_PER_LOT |
NUMBER(7) |
Lots with a quantity that is greater than or equal to the value set be tagged or never tagged, depending on the condition type that is selected. |