data-dictionary

FPSBASE.CM_P_CAL_WEEKS_NEXT_N

Data Dictionary

>

FPSBASE Views

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSAPP.CM_P_CAL_WEEKS_NEXT_N

This view allows next n weeks to be used in queries in code. Don't want to query directly from fpsbase.

Column

Comment

WEEK

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)

MONTH

QUARTER

YEAR

START_LAST_WEEK

N