data-dictionary

FPSADMIN.ADM_LOAD_STATUS

Data Dictionary

>

FPSADMIN Tables

> FPSADMIN.ADM_LOAD_STATUS

Table FPSADMIN.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: FPSADMIN

  • 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)