FPSAPP.CAL_SHIFT_LAST | inficon-demo

Data Dictionary

FPSAPP Views

> FPSAPP.WIP_WAFER_HIST_LOOP

View FPSBASE.CAL_SHIFT_LAST

Get one line of information for the last shift. All of the max functions are unnecessary but they tell the compiler that there is only row which makes queries using this view infinitely faster. Using (END_SHIFT - START_SHIFT) allows this view to work for any length shift.

Column	Comment
SHIFT	Name of shift 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_shift rather than shift in case we want to change the naming convention for the shift. (* inherited from FPSINPUT.CAL_SHIFTS)
START_SHIFT	Shifts can be of any length and it is important that all queries get the shift length based on start_shift and end_shift rather than assuming a set number of hours. (* inherited from FPSINPUT.CAL_SHIFTS)
END_SHIFT	End of shift must be equal to the start of the next shift. Please note that the exact time which is both of the end of the previous shift and the start of the next shift is included in the next shift. In other words, start_shift <= inst < end_shift. (* inherited from FPSINPUT.CAL_SHIFTS)
START_WORK_DAY	Work days must be 24 hours in length and the start of the work day must be the start of one of the shifts. Contrast this to plan day which is independent of shift. (* inherited from FPSINPUT.CAL_WORK_DAYS)
CALENDAR_DAY	When we choose this day on a website calendar we will associate with work_days of this day. Typically this is the day of the start_day but not always. For example, start_day might be 17:00 and represent the following calendar_day. (* inherited from FPSINPUT.CAL_WORK_DAYS)
WORK_PERIOD
WORK_GROUP	Identifies the workforce on the shift so that we can compare performance of the different shifts. If the same people constantly work the same schedule this is the same as work_period. (* inherited from FPSINPUT.CAL_SHIFTS)
START_LAST_SHIFT
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)
WORK_WEEK	Name of work week must be unique and can be in any format as long as it is display friendly since this is what we show everywhere. (* inherited from FPSINPUT.CAL_WORK_WEEKS)
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)
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)