FPSADMIN.RECENT_LOAD_SINCE_DDL

Data Dictionary

FPSADMIN Views

> FPSADMIN.WIP_WAFER_HIST_LOOP

View FPSADMIN.RECENT_LOAD_SINCE_DDL

This view shows the recent load history for a table since it was modified or since the view/procedure that loads it was modified. It uses RECENT_LOAD_HIST so this only goes back for the last 3 days and therefore only includes tables which have been modified or had their load view/procedure modified in the last three days

Column	Comment
OWNER
TABLE_NAME
LAST_DDL_TIME
METHOD	Method used to load data in table or execute procedure (* inherited from FPSADMIN.GEN_LOAD_METHODS)
LOAD_OBJECT_NAME
LOAD_OBJ_DDL_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)
LAST_START_TIME
SYS_TIME	This is always SYSTIMESTAMP when the record was inserted in the MSO_MES_INTERACTION_HIST table. (* inherited from FPSBASE.MSO_MES_INTERACTION_HIST)
COMPONENT
MSG_CODE
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)