FPSINPUT.RECENT_SLOWEST_INST

Data Dictionary

FPSINPUT Views

> FPSINPUT.WIP_WAFER_HIST_LOOP

View FPSADMIN.RECENT_SLOWEST_INST

Lists all jobs which were in progress at the time when the 3min load was the slowest. This uses RECENT_WEH_LOAD_HIST to determine this slowest_inst so as written this view applies to APF ETL clients. However it is easy to simply replace slowest_inst with a specific time that you want to investigate.

Column	Comment
START_TIME
END_TIME
DURATION_SEC	Duration in seconds of the period to be used to run the APF report. Used only for CLR, CLRA, and QE. (* inherited from FPSADMIN.CFG_TABLES)
COMPONENT
OBJECT_NAME	This could be an object name (we will disable loading of that object in the scheduled jobs), a load job (we will disable loading of all objects in that scheduled job), an FPSAPP prefix (we will disable loading of all objects with that prefix), a constraint (we can explain why it is permanently disabled), or a trigger (technically an object so we can get away with omitting this from the column name and also to explain why it is permanently disabled). (* inherited from FPSADMIN.CFG_DISABLED)
MSG_CODE
METHOD	Method used to load data in table or execute procedure (* inherited from FPSADMIN.GEN_LOAD_METHODS)
SHORT_MSG
NUM_UPDATES
NUM_INSERTS
NUM_DELETES
RPT_DURATION_SEC
LONG_MSG
OBJ_OWNER
OBJ_TYPE
APPLICATION	Application that the user is allowed or able to log events. (* inherited from FPSINPUT.GEN_USERS)
OSUSER
MACHINE
DB_USERNAME	For CHGLOG and automatic HIST tables, this is populated with the USER system variable. (* inherited from FPSINPUT.EQP_CHAMBERS_CHGLOG)
SID
MSG_TIME	This column can be used for a DATE or TIMESTAMP associated with the record. If the record is from a different system like APF then this could be the timestamp from the APF repository. Or if we want to record a message about an event inserted in WIP_EVENT_HIST then this could be the INST of that event. Therefore this value could be in a different time zone from SYS_TIME. If the msg_time is not specified then we will fill in with SYSTIMESTAMP. (* inherited from FPSADMIN.ADM_LOAD_HIST)