Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSBASE.WIP_DEL_LOTS_COLS_NO_DD_PRTN
This is a fast view to delete records from this table without the complex logic of the REF view. Please note that the REF view joins WIP_LOTS_REALTIME with WIP_LOTS_STATIC but we use only WIP_LOTS_STATIC here for speed reasons. It is possible that a lot could be deleted from WIP_LOTS_REALTIME by an event before it is deleted from WIP_LOTS_STATIC by ETL. In this case, the recently deleted lot would not be deleted from WIP_LOTS_COLS_NO_DD_PRTN but that is acceptable because this table is only used in the WIP_LOTS_PLUS view where it is joined with WIP_LOTS_REALTIME. Then the record will soon be deleted on an upcoming refresh after it is deleted from WIP_LOTS_STATIC.
|
Column |
Comment |
|---|---|
|
LOT |
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. (* inherited from FPSINPUT.WIP_LOTS_STATIC) |