data-dictionary

FPSAPP.MSO_LOT_TAG_CONDITIONS

Data Dictionary

>

FPSAPP Tables

> FPSAPP.MSO_LOT_TAG_CONDITIONS

Table FPSAPP.MSO_LOT_TAG_CONDITIONS"

This tag conditions table allows users to place lot specific tag conditions. This allows for setting if a lot can be tagged or not to a given metrology step.

  • Schema: FPSAPP

  • Tablespace: FPSDATA

  • Primary key: FACILITY, LOT, TO_MSO_PROCESS_NA


Column

Type

Nullable

Comment

FACILITY

VARCHAR2(6)

N

Facility of the lot.

LOT

VARCHAR2(32)

N

Lot that the tag condition will apply to.

TO_MSO_PROCESS_NA

VARCHAR2(100)

N

The MSO Processes associated to the metrology step the tag condition will apply to. If this value is set to NA then the tag condition will apply to all metrology step for the lot.

IS_ACTIVE

CHAR(1)

Flag to turn on/off the lot level tag condition.

TAG_CONDITION_TYPE

VARCHAR2(32)

For lot level tag conditions the only options are to ALWAYS measure or NEVER measure at the metrology step. ALWAYS ensures that the lot will be tagged to measure to the corresponding metrology steps. NEVER ensures the lot not be tagged to measure at the corresponding metrology step.

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)