FPSBASE.STD_LOAD_CAL_BASE

>

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSINPUT.STD_LOAD_CAL_BASE

This view generates calendar information from shift and day all the way up to year. It is not normalized. This is admittedly a bit of circular logic because the output of view should look exactly like the output of the FPSBASE views CAL_SHIFTS_PLUS and CAL_PLAN_DAYS_PLUS. We normally copy this view as FPSINPUT.LOAD_CAL_BASE with the parameters in the first section set appropriately and then use our FPS standard set of CAL_APD views stored in STD_CAL_APD_VIEWS to populate the individual normalized FPSINPUT CAL tables so that we can enforce referential integrity. Then we use the CAL_SHIFTS_PLUS and CAL_PLAN_DAYS_PLUS views to combine them again. Since some sites have completely custom calendars with different shift lengths and different shifts each day, we must leave this as an FPSINPUT.STD view to allow for the possibility of fully customized ETL but for most facilities this standard logic will work quite well and is very easy to configure and use. At the end of STD_CAL_APD_VIEWS we have a script to load and check the CAL tables.