FPSBASE.STD_FAKE_EQP_MNT_FUTURE

Data Dictionary

FPSBASE Views

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSINPUT.STD_FAKE_EQP_MNT_FUTURE

This view fakes two upcoming maintenance events for every entity. It created some PMs and some Quals. It does some tools time-based and other tools counted-based. So this just gives some reasonable data to show on a demo Dashboard for sites where you cannot get upcoming maintenance data immediately. To use this, create two views selecting from this view. First create EQP_REF_MNT_FUTURE selecting all columns except for counter_curr. Then create the EQP_APD_MNT_COUNTER_HIST view selecting only facility, event_id, operator, counter_value, data_date as inst. Finally if it does not already exist you will need to create the EQP_MNT_COUNTER_HIST_INSERT procedure which you can either copy from most other sites or build from BLD_TABLE_INSERT_PROCEDURE.

Column	Comment
PERIOD
DAYS
COUNTER_UNITS	Unit for the maintenance counter. Common examples include wafers or hours or kWh. (* inherited from FPSINPUT.EQP_MNT_FUTURE)
COUNTER_DUE	Counter value when the maintenance event will be due or expected. See `counter_early` and `counter_late` for the window of values in which the maintenance can be performed. (* inherited from FPSINPUT.EQP_MNT_FUTURE)