Data Dictionary
>
FPSAPP Tables
> FPSAPP.ADM_LOAD_HIST
Table FPSAPP.ADM_LOAD_HIST"
Detailed history of all ADM_LOAD transactions for all of the different load types. All applications which load data insert directly into this table and then a trigger on this table populates ADM_LOAD_STATUS.
-
Schema: FPSAPP
-
Tablespace: FPSDATAHIST
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
APPLICATION |
VARCHAR2(30) |
N |
Application that the user is allowed or able to log events. (* from FPSINPUT.GEN_USERS) |
|
COMPONENT |
VARCHAR2(30) |
N |
|
|
DB_USERNAME |
VARCHAR2(30) |
For CHGLOG and automatic HIST tables, this is populated with the USER system variable. (* from FPSINPUT.EQP_CHAMBERS_CHGLOG) |
|
|
LAST_START_TIME |
TIMESTAMP(6) |
||
|
LONG_MSG |
VARCHAR2(4000) |
||
|
MACHINE |
VARCHAR2(64) |
||
|
METHOD |
VARCHAR2(6) |
Method used to load data in table or execute procedure (* from FPSADMIN.GEN_LOAD_METHODS) |
|
|
MSG_CODE |
VARCHAR2(1) |
N |
|
|
MSG_TIME |
TIMESTAMP(6) |
N |
This column can be used for a DATE or TIMESTAMP associated with the record. If the record is from a different system like APF then this could be the timestamp from the APF repository. Or if we want to record a message about an event inserted in WIP_EVENT_HIST then this could be the INST of that event. Therefore this value could be in a different time zone from SYS_TIME. If the msg_time is not specified then we will fill in with SYSTIMESTAMP. |
|
NUM_DELETES |
NUMBER(7) |
||
|
NUM_INSERTS |
NUMBER(7) |
||
|
NUM_UPDATES |
NUMBER(7) |
||
|
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) |
||
|
OBJ_TYPE |
VARCHAR2(30) |
N |
|
|
OSUSER |
VARCHAR2(30) |
||
|
RPT_DURATION_SEC |
NUMBER(5) |
||
|
SERIAL# |
NUMBER(8) |
||
|
SHORT_MSG |
VARCHAR2(64) |
||
|
SID |
NUMBER(8) |