FPSBASE.ADM_LOAD_DAILY_HIST

Data Dictionary

FPSBASE Tables

> FPSBASE.ADM_LOAD_DAILY_HIST

Table FPSBASE.ADM_LOAD_DAILY_HIST"

See comments in ADM_APD_LOAD_DAILY_HIST view.

Column	Type	Nullable	Comment
DAY	DATE	N
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)
OBJ_OWNER	VARCHAR2(30)	N
OBJ_TYPE	VARCHAR2(30)	N
APPLICATION	VARCHAR2(30)	N	Application that the user is allowed or able to log events. (* from FPSINPUT.GEN_USERS)
COMPONENT	VARCHAR2(30)	N
AVG_NUM_DELETES	NUMBER(8,1)
AVG_NUM_INSERTS	NUMBER(8,1)
AVG_NUM_UPDATES	NUMBER(8,1)
AVG_RPT_DURATION_SEC	NUMBER(6,1)
AVG_SEC	NUMBER(7,2)
MAX_LONG_MSG	VARCHAR2(4000)
MAX_SEC	NUMBER(7,2)
MAX_SHORT_MSG	VARCHAR2(64)
MED_SEC	NUMBER(7,2)
METHOD	VARCHAR2(6)		Method used to load data in table or execute procedure (* from FPSADMIN.GEN_LOAD_METHODS)
MIN_SEC	NUMBER(7,2)
NUM_A	NUMBER(7)
NUM_C	NUMBER(7)
NUM_D	NUMBER(7)
NUM_E	NUMBER(7)
NUM_F	NUMBER(7)
NUM_I	NUMBER(7)
NUM_P	NUMBER(7)
NUM_R	NUMBER(7)
NUM_S	NUMBER(7)
NUM_V	NUMBER(7)
NUM_W	NUMBER(7)
PERC10	NUMBER(7,2)
PERC20	NUMBER(7,2)
PERC30	NUMBER(7,2)
PERC40	NUMBER(7,2)
PERC60	NUMBER(7,2)
PERC70	NUMBER(7,2)
PERC80	NUMBER(7,2)
PERC90	NUMBER(7,2)
STDDEV_SEC	NUMBER(7,2)