Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSBASE.CHK_LOT_SHIFT_CTM
This view checks that all lots which exist at the start and end of the shift have a total cycle time equal to the length of the shift. This is another validation for cycle time.
|
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) |
|
START_SHIFT |
Shifts can be of any length and it is important that all queries get the shift length based on start_shift and end_shift rather than assuming a set number of hours. (* inherited from FPSINPUT.CAL_SHIFTS) |
|
END_SHIFT |
End of shift must be equal to the start of the next shift. Please note that the exact time which is both of the end of the previous shift and the start of the next shift is included in the next shift. In other words, start_shift <= inst < end_shift. (* inherited from FPSINPUT.CAL_SHIFTS) |
|
ENDWIP_SEC |
|
|
STEP_SEC |
Step Sec (* inherited from FPSAPP.SCH_W_H_S_LOTS) |
|
SHIFT_SEC |