Data Dictionary
>
FPSAPP Tables
> FPSAPP.RTG_QUEUE_TIMERS_LOT_AUTO
Table FPSAPP.RTG_QUEUE_TIMERS_LOT_AUTO"
Table stores the time when each lot started a queue sequence for faster querying. Records are inserted and deleted by a trigger on WIP_STEP_HIST. This table is ignored if FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL is populated.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: LOT, TIMER_ID
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
LOT |
VARCHAR2(32) |
N |
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. (* from FPSINPUT.WIP_LOTS_STATIC) |
|
TIMER_ID |
NUMBER(9) |
N |
Unique number representing the queue timer to index with other tables. Automatically populated with RTG_QUEUE_TIMERS_ID_SEQ sequence. (* from FPSINPUT.RTG_QUEUE_TIMERS) |
|
BEG_PROC_INST_OF_START_STEP |
DATE |
Time when the lot started processing on the tool at the step which starts the queue timer. (* from FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL) |
|
|
COMP_INST_OF_START_STEP |
DATE |
Time when the lot completed (also referred to as moved out of) the step which starts the queue timer. (* from FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL) |
|
|
DISPATCH_INST_OF_START_STEP |
DATE |
Time when the lot was dispatched to the tool at the step which starts the queue timer. (* from FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL) |
|
|
END_PROC_INST_OF_START_STEP |
DATE |
Time when the lot ended processing on the tool at the step which starts the queue timer. (* from FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL) |