Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSBASE.CAL_QUARTERS_LAST_N
Get last n quarters where n=0 is the current quarter, n=1 is last quarter, etc. Distinct is to attempt to force database to run this first when executing.
|
Column |
Comment |
|---|---|
|
WORK_QUARTER |
Name of work quarter 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_quarter rather than work_quarter in case we want to change the naming convention for the work_quarter. (* inherited from FPSINPUT.CAL_WORK_QUARTERS) |
|
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) |
|
END_WORK_QUARTER |
It is critical that this field equal the start_work_quarter of the next work quarter. (* inherited from FPSINPUT.CAL_WORK_QUARTERS) |
|
START_WORK_YEAR |
This is the work year not the calendar year. Start of the work year must be the start of a work quarter and each work quarter must be within a single work year. (* inherited from FPSINPUT.CAL_WORK_YEARS) |
|
N |