Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSADMIN.CHK_LOAD_CFG
This view checks that all FPSINPUT/BASE/APP tables are accounted for in CFG_TABLES. Tables loaded manually need to be listed as MANUAL. We also check if there are any records in CFG_TABLES which do not exist. Please note that this view must use DBF_xxx views if permissions are granted to FPSAPP for SYSMNTR because FPSAPP does not see all objects when querying DBF_xxx views since it does not have permission on everything. Since the only reason to use DBF_xxx is to grant to other users then we just use DBF_xxx.
|
Column |
Comment |
|---|---|
|
PROBLEM |
|
|
OWNER |
|
|
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) |
|
METHOD |
Method used to load data in table or execute procedure (* inherited from FPSADMIN.GEN_LOAD_METHODS) |
|
LOAD_JOB |
Name of load job (* inherited from FPSADMIN.CFG_JOBS) |
|
NULL |
|
|
DELETE |