Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_LOAD_STATUS_ACTIVE
ADM_LOAD_STATUS includes objects which are not actively loading and we often want to query the status of the objects which are actively loading only. This view does this and although it does include objects which are disabled at least it sorts them at the bottom. We use this view in SYSMNTR_ERRORS and ADM_TURN_ETL_OFF plus we frequently query it directly.
|
Column |
Comment |
|---|---|
|
LOAD_JOB |
Name of load job (* inherited from FPSADMIN.CFG_JOBS) |
|
LOAD_ORDER |
Order of objects to load within the load job (* inherited from FPSADMIN.CFG_SCHED) |
|
IS_OBSOLETE |
|
|
IS_DISABLED |
|
|
ERROR_MSG |
|
|
OBJECT_NAME |
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). (* inherited from FPSADMIN.CFG_DISABLED) |
|
APPLICATION |
Application that the user is allowed or able to log events. (* inherited from FPSINPUT.GEN_USERS) |
|
COMPONENT |
|
|
OBJ_OWNER |
|
|
OBJ_TYPE |
|
|
METHOD |
Method used to load data in table or execute procedure (* inherited from FPSADMIN.GEN_LOAD_METHODS) |
|
LAST_MSG_CODE |
|
|
IS_RUNNING |
|
|
LAST_SHORT_MSG |
|
|
LAST_START_TIME |
|
|
LAST_SUCCESS_TIME |
|
|
LAST_FAIL_TIME |
|
|
LAST_WARN_TIME |
|
|
LAST_NUM_UPDATES |
|
|
LAST_NUM_INSERTS |
|
|
LAST_NUM_DELETES |
|
|
OWNER |
|
|
LAST_SID |
|
|
LAST_RPT_DURATION_SEC |
|
|
LOAD_JOB_FOR_JOB |
|
|
LAST_LONG_MSG |
|
|
MSG_CODE_DESCRIPTION |
|
|
WARN_DURATION_SEC |
|
|
WARN_DURATION_SEC_MSG |