Data Dictionary
>
FPSBASE Tables
> FPSBASE.ADM_CHK_SUMMARY_CFG
Table FPSBASE.ADM_CHK_SUMMARY_CFG"
In this configuration table, we set the minimum number of rows required for each CHK_xxx views in order for it to be included in the alert message. We can also disable the view from being included in the alert. For example, if set 50 as the minimum for CHK_EQP_HIST then the ADM_CHK_SUMMARY email will include a row for CHK_EQP_HIST only if the view has more than 50 rows. In general, we will most of the FPSADMIN CHK views to 0 and the FPSBASE views to a higher minimum.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: OWNER, VIEW_NAME
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
OWNER |
VARCHAR2(30) |
N |
|
|
VIEW_NAME |
VARCHAR2(30) |
N |
The name of the view uses for this check which starts with SYSMNTR_P_CHK. (* from FPSAPP.SYSMNTR_C_CHECKS) |
|
IS_DISABLED |
CHAR(1) |