Data Dictionary
>
FPSBASE Views
> FPSBASE.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) |