FPSAPP.DASH_P_DATA_LAST_UPDATED

Data Dictionary

FPSAPP Views

> FPSAPP.WIP_WAFER_HIST_LOOP

View FPSAPP.DASH_P_DATA_LAST_UPDATED

Shows the last updated date in the upper right corner of DASH and triggers the refresh of the cache. Even though this view is fast, it must be refreshed into a table because it is critical that it updates only after the DASH tables are refreshed We get the time-weighted average of refresh intervals for the 3-minute load over the past 12 hours as the update_interval_sec. Weighting is done so that more recent observations are counted more heavily.

Column	Comment
UPDATED_INST	Time when the record was updated according to the source data. Note this is not the time when the record was actually updated in this table - it will almost always be earlier. (* inherited from FPSINPUT.GEN_FACILITIES)
COMMIT_INST
PCT_SHIFT_COMPLETED
UPDATE_INTERVAL_SEC
PRTY_GANTT_REFRESH_INST
PLAN_DAY	Name of plan day 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_day rather than plan_day in case we want to change the naming convention for the plan_day. (* inherited from FPSINPUT.CAL_PLAN_DAYS)
PLAN_WEEK	Name of plan 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_PLAN_WEEKS)
PLAN_MONTH	Name of plan 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_plan_month rather than plan_month in case we want to change the naming convention for the plan_month. (* inherited from FPSINPUT.CAL_PLAN_MONTHS)
PLAN_QUARTER	Name of plan 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_plan_quarter rather than plan_quarter in case we want to change the naming convention for the plan_quarter. (* inherited from FPSINPUT.CAL_PLAN_QUARTERS)
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)
START_PLAN_DAY	Plan days must be 24 hours in length and the start of the plan day must be the start of one of the shifts. Contrast this to plan day which is independent of shift. (* inherited from FPSINPUT.CAL_PLAN_DAYS)
START_PLAN_WEEK	Plan weeks must be 7 days in duration and the start of the plan week must be the start of one of the plan days. (* inherited from FPSINPUT.CAL_PLAN_WEEKS)
END_PLAN_WEEK	It is critical that this field equal the start_plan_week of the next plan week. (* inherited from FPSINPUT.CAL_PLAN_WEEKS)
START_PLAN_MONTH	This is the plan month not the calendar month. Start of the plan month must be the start of a plan week and each plan week must be within a single plan month. (* inherited from FPSINPUT.CAL_PLAN_MONTHS)
START_PLAN_QUARTER	This is the plan quarter not the calendar quarter. Start of the plan quarter must be the start of a plan month and each plan month must be within a single plan quarter. (* inherited from FPSINPUT.CAL_PLAN_QUARTERS)
START_PLAN_YEAR	This is the plan year not the calendar year. Start of the plan year must be the start of a plan quarter and each plan quarter must be within a single plan year. (* inherited from FPSINPUT.CAL_PLAN_YEARS)
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)
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)
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)
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)
WORK_YEAR	Name of work 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_work_year rather than work_year in case we want to change the naming convention for the work_year. (* inherited from FPSINPUT.CAL_WORK_YEARS)
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)
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)
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)
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)
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)