Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSBASE.CAL_MONTHS_LAST_N
Get last n months where n=0 is the current month, n=1 is last month, etc. Distinct is to attempt to force database to run this first when executing.
|
Column |
Comment |
|---|---|
|
WORK_MONTH |
Name of work month 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_work_month rather than work_month in case we want to change the naming convention for the work_month. (* inherited from FPSINPUT.CAL_WORK_MONTHS) |
|
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) |
|
END_WORK_MONTH |
It is critical that this field equal the start_work_month of the next work month. (* inherited from FPSINPUT.CAL_WORK_MONTHS) |
|
START_WORK_QUARTER |
This is the work quarter not the calendar quarter. Start of the work quarter must be the start of a work month and each work month must be within a single work quarter. (* inherited from FPSINPUT.CAL_WORK_QUARTERS) |
|
N |