Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSBASE.CAL_WEEK_LAST
Get one line of information for the last week. All of the max functions are unnecessary but they tell the compiler that there is only row which makes queries using this view infinitely faster. Using (end_week - start_week) allows this view to work for any length week although if a customer has weeks of lengths other than 7 days that would be rather interesting.
|
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 |