Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSAPP.WF_P_SHIFT_CNTS
View is used to know the shifts for history. The WF_P_H_FLUSH table is just a snapshot of the WIP_FLUSH table which is refreshed every shift at some sites and every day at others. Because it just takes a snapshot, it cannot fill in old data like WIP_END_SHIFT_HIST or ETP_TOOL_SHIFT_HIST that is compiling from another history table. Therefore WF_P_H_FLUSH will not include duplicate records for the same shift (and PK of WIP_FLUSH) but it is also not guaranteed to have every shift. The labels say shift throughout the code and UI but only show shifts that have data. Therefore WF_P_SHIFT_CNTS must only include shifts in WF_P_H_FLUSH to guarantee that only valid shifts are in the dropdown. We were somewhat concerned about the speed of this view but it seems to take less than half a second.
|
Column |
Comment |
|---|---|
|
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) |
|
SHIFT |
Name of shift must be unique and can be in any format as long as it is display friendly since this is what we show everywhere. We prefer that other tables should reference start_shift rather than shift in case we want to change the naming convention for the shift. (* inherited from FPSINPUT.CAL_SHIFTS) |
|
NUM_SHIFTS |