Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSBASE.RTG_QUEUE_TIMERS_LOT_START
This view shows either FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL if that table has any rows or FPSBASE.RTG_QUEUE_TIMERS_LOT_AUTO if the FPSINPUT table is empty.
|
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) |
|
TIMER_ID |
Unique number representing the queue timer to index with other tables. Automatically populated with RTG_QUEUE_TIMERS_ID_SEQ sequence. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
STARTED_ON_RWK_ROUTE |
|
|
DISPATCH_INST_OF_START_STEP |
Time when the lot was dispatched to the tool at the step which starts the queue timer. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL) |
|
BEG_PROC_INST_OF_START_STEP |
Time when the lot started processing on the tool at the step which starts the queue timer. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL) |
|
END_PROC_INST_OF_START_STEP |
Time when the lot ended processing on the tool at the step which starts the queue timer. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL) |
|
COMP_INST_OF_START_STEP |
Time when the lot completed (also referred to as moved out of) the step which starts the queue timer. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL) |
|
RQD_DISPATCH_INST_OF_END_STEP |
Time when the lot must dispatch to the tool at the step which ends the queue timer. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL) |
|
RQD_BEG_PROC_INST_OF_END_STEP |
Time when the lot must start processing on the tool at the step which ends the queue timer. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL) |
|
RQD_END_PROC_INST_OF_END_STEP |
|
|
RQD_COMP_INST_OF_END_STEP |
Time when the lot must complete (also referred to as move out of) the step which ends the queue timer. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL) |
|
SOURCE_TABLE |