Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSAPP.ECTFL_P_FINISHED_PERIODS
View to get information about each finished period in the queries.
|
Column |
Comment |
|---|---|
|
FINISHED_PERIOD |
|
|
START_PERIOD |
|
|
END_PERIOD |
|
|
PERIOD_TYPE |
|
|
PERIOD_SORT_ORDER |
This column is only to sort the periods in the FLCT application. Normally this will match the period_start_inst but when sites has multiple period types like months and years then it is nice to be able to control the sort order. (* inherited from FPSINPUT.WIP_CTM_FORECAST) |
|
PLAN_YEAR |
Name of plan year 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_plan_year rather than plan_year in case we want to change the naming convention for the plan_year. (* inherited from FPSINPUT.CAL_PLAN_YEARS) |