Data Dictionary
>
FPSBASE Tables
> FPSBASE.ADM_LOAD_STATUS
Table FPSBASE.ADM_LOAD_STATUS"
Current status of all objects loaded by ADM_LOAD. This table is populated by a trigger on ADM_LOAD_HIST and is never updated directly.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: OBJECT_NAME
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
OBJECT_NAME |
VARCHAR2(30) |
N |
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). (* from FPSADMIN.CFG_DISABLED) |
|
APPLICATION |
VARCHAR2(30) |
N |
Application that the user is allowed or able to log events. (* from FPSINPUT.GEN_USERS) |
|
COMPONENT |
VARCHAR2(30) |
N |
|
|
LAST_FAIL_TIME |
TIMESTAMP(6) |
||
|
LAST_LONG_MSG |
VARCHAR2(4000) |
||
|
LAST_MSG_CODE |
VARCHAR2(1) |
N |
|
|
LAST_NUM_DELETES |
NUMBER(7) |
||
|
LAST_NUM_INSERTS |
NUMBER(7) |
||
|
LAST_NUM_UPDATES |
NUMBER(7) |
||
|
LAST_RPT_DURATION_SEC |
NUMBER(5) |
||
|
LAST_SERIAL# |
NUMBER(8) |
||
|
LAST_SHORT_MSG |
VARCHAR2(64) |
||
|
LAST_SID |
NUMBER(8) |
||
|
LAST_START_TIME |
TIMESTAMP(6) |
N |
|
|
LAST_SUCCESS_TIME |
TIMESTAMP(6) |
||
|
LAST_WARN_TIME |
TIMESTAMP(6) |
||
|
OBJ_OWNER |
VARCHAR2(30) |