Data Dictionary
>
FPSAPP Tables
> FPSAPP.MSO_EXTL_TAG_CONDITION_CTX
Table FPSAPP.MSO_EXTL_TAG_CONDITION_CTX"
This table has the user defined context of the tag condition loaded via an external source. A single tag condition can have multiple conditions defined. Each row for a single tag_condition_name, 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 a null value means we ignore that column. When loading at least one of the context columns must be defined.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
TAG_CONDITION_NAME |
VARCHAR2(64) |
N |
Unique name identifying the external tag condition. (* from FPSINPUT.MSO_EXTL_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 |
VARCHAR2(32) |
Lots that have a matching lot id will be tagged or never be tagged depending on the condition type selected. |
|
|
LOT_GROUP |
VARCHAR2(8) |
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 null the check is ignored. |
|
|
LOT_MSO_GROUP |
VARCHAR2(8) |
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 null the check is ignored. |
|
|
LOT_PARAMETER_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_PARAMETER_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. |
|
|
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. |
|
|
PLAN_PRIORITY |
VARCHAR2(7) |
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 null the check is ignored. |
|
|
PRD |
VARCHAR2(64) |
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 null the check is ignored. |
|
|
PRD_MSO_GROUP |
VARCHAR2(64) |
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 null the check is ignored. |
|
|
ROUTE |
VARCHAR2(256) |
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 null the check is ignored. |
|
|
ROUTE_MSO_GROUP |
VARCHAR2(64) |
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 null the check is ignored. |
|
|
UPDATED_INST |
DATE |
Time when the record was updated according to the source data. Note this is not the time when the record was actually updated in this table - it will almost always be earlier. (* from FPSINPUT.GEN_FACILITIES) |