Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSADMIN.DBF_TABLES_PLUS
This view adds information from CFG_TABLES to DBF_TABLES. Having this as a separate view rather than refreshed into DBF_TABLES means that this view will immediately reflect changes from CFG_TABLES without having to refresh DBF_TABLES.
|
Column |
Comment |
|---|---|
|
OWNER |
|
|
TABLE_NAME |
|
|
TABLESPACE_NAME |
Tablespace to configure the SysMonitor alert limits. (* inherited from FPSAPP.SYSMNTR_C_TABLESPACE_ALERT) |
|
NUM_ROWS |
|
|
LAST_ANALYZED |
|
|
PARTITIONED |
|
|
TEMPORARY |
|
|
METHOD |
Method used to load data in table or execute procedure (* inherited from FPSADMIN.GEN_LOAD_METHODS) |
|
OTHER_TABLE_WHERE_LOADED |
Some of our APF reports load multiple tables in the same report. It is required to pick one of those tables to name the update. The other tables will have the method of OTHTAB with the name of the other table whose job loads it in this column. (* inherited from FPSADMIN.CFG_TABLES) |
|
PURGE_COLUMN_NAME |
This must be the name of a DATE or TIMESTAMP column which is the first column in an index. See PURGE_DAYS.COLUMN_NAME comment for purge details. (* inherited from FPSADMIN.CFG_TABLES) |
|
PURGE_DAYS |
All history tables must have the PURGE_COLUMN_NAME and PURGE_DAYS set. We automatically purge data older than DAYS to keep the history tables to a reasonable size. We must keep at least 10 days worth of data in all tables (except DASH_P_H_SHIFT_SUMMARY) with the logic being that gives us 3 days to append from the raw table to the week history. If you do not want to purge then set DAYS to 9999. (* inherited from FPSADMIN.CFG_TABLES) |
|
CHGLOG_TABLE_NAME |
|
|
PURGE_CHGLOG_DAYS |
|
|
PREFIX |
|
|
TOKEN2 |
|
|
DML_SCOPE |
|
|
APD_OR_REF_VIEW |
|
|
COMMENTS_FROM_APD_OR_REF_VIEW |
|
|
KEY_NAME |
|
|
KEY_TYPE |
|
|
PARTITIONED_COLUMN_NAME |
|
|
PARTITIONED_INTERVAL |
|
|
PARTITIONED_INCREMENTAL_PARM |
|
|
IS_CHGLOG_PERM_DISABLED |
Our FPSINPUT tables have the capability to record all changes in a CHGLOG table as built by BLD_CHGLOG. You can disable this by setting this to Y. (* inherited from FPSADMIN.CFG_TABLES) |
|
IS_CHGLOG_ADDL_ENABLED |
This column allows us to enable CHGLOG table/trigger functionality on additional tables which would not otherwise have it based on our normal manual table or manual columns logic. (* inherited from FPSADMIN.CFG_TABLES) |