Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_APD_LOAD_DAILY_HIST
Summary of ADM_LOAD_HIST grouped by day. This allows us to purge ADM_LOAD_HIST and still have past results for the entire life of the database. Obj_owner is allowed to be null in ADM_LOAD_HIST but it is part of the PK of this table therefore we have to do an nvl.
|
Column |
Comment |
|---|---|
|
DAY |
|
|
VERSION |
|
|
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) |
|
OBJ_OWNER |
|
|
OBJ_TYPE |
|
|
APPLICATION |
Application that the user is allowed or able to log events. (* inherited from FPSINPUT.GEN_USERS) |
|
COMPONENT |
|
|
METHOD |
Method used to load data in table or execute procedure (* inherited from FPSADMIN.GEN_LOAD_METHODS) |
|
NUM_C |
|
|
AVG_SEC |
|
|
STDDEV_SEC |
|
|
MIN_SEC |
|
|
PERC10 |
|
|
PERC20 |
|
|
PERC30 |
|
|
PERC40 |
|
|
MED_SEC |
|
|
PERC60 |
|
|
PERC70 |
|
|
PERC80 |
|
|
PERC90 |
|
|
MAX_SEC |
|
|
NUM_S |
|
|
NUM_F |
|
|
NUM_I |
|
|
NUM_W |
|
|
NUM_R |
|
|
NUM_V |
|
|
NUM_P |
|
|
NUM_D |
|
|
NUM_E |
|
|
NUM_A |
|
|
MAX_SHORT_MSG |
|
|
MAX_LONG_MSG |
|
|
AVG_NUM_UPDATES |
|
|
AVG_NUM_INSERTS |
|
|
AVG_NUM_DELETES |
|
|
AVG_RPT_DURATION_SEC |