Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSBASE.CAL_WORK_WEEKS_LAST_N
Get last n weeks where n=0 is the current week, n=1 is last week, etc. Distinct is to attempt to force database to run this first when executing.
|
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 |
|
|
N |