Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL
Table FPSINPUT.RTG_QUEUE_TIMERS_LOT_MANUAL"
Table allows ETL to manually populate the time when each lot started a queue sequence. If this table has any records then it will be used exclusively. If empty then we will use FPSBASE.RTG_QUEUE_TIMERS_LOT_AUTO.
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: LOT, TIMER_ID
-
Foreign keys: RTG_QUEUE_T_LOT_MAN_ID_FK: TIMER_ID REFERENCES FPSINPUT.RTG_QUEUE_TIMERS (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. |
|
|
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. |
|
|
DISPATCH_INST_OF_START_STEP |
DATE |
Time when the lot was dispatched to the tool at the step which starts the queue timer. |
|
|
END_PROC_INST_OF_START_STEP |
DATE |
Time when the lot ended processing on the tool at the step which starts the queue timer. |
|
|
RQD_BEG_PROC_INST_OF_END_STEP |
DATE |
Time when the lot must start processing on the tool at the step which ends the queue timer. |
|
|
RQD_COMP_INST_OF_END_STEP |
DATE |
Time when the lot must complete (also referred to as move out of) the step which ends the queue timer. |
|
|
RQD_DISPATCH_INST_OF_END_STEP |
DATE |
Time when the lot must dispatch to the tool at the step which ends the queue timer. |