Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSBASE.CAL_WEEK_CURR_AND_LAST
Get two lines of information for current and last weeks. Distinct is to attempt to force database to run this first when executing. This logic works for any length of week.
|
Column |
Comment |
|---|---|
|
WORK_WEEK |
Name of work week must be unique and can be in any format as long as it is display friendly since this is what we show everywhere. (* inherited from FPSINPUT.CAL_WORK_WEEKS) |
|
START_WEEK |
Work weeks must be 7 days in duration and the start of the work week must be the start of one of the work days. (* inherited from FPSINPUT.CAL_WORK_WEEKS) |
|
END_WEEK |
It is critical that this field equal the start_week of the next work work. (* inherited from FPSINPUT.CAL_WORK_WEEKS) |
|
START_WORK_MONTH |
This is the work month not the calendar month. Start of the work month must be the start of a work week and each work week must be within a single work month. (* inherited from FPSINPUT.CAL_WORK_MONTHS) |
|
START_LAST_WEEK |