Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSADMIN.DBF_REF_DEV_ONLY_OBJECTS
We do not want dev only objects in our normal DBF tables including DBF_OBJECTS but we want to include those which are invalid in SYSMNTR_ERRORS and we want to store them in GrimRepo via DBF_SCHEMA_SCOPE. In order to be able to grant that view, we need to avoid querying any DBA views so we have to refresh these into a table.
|
Column |
Comment |
|---|---|
|
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) |
|
SUBOBJECT_NAME |
|
|
OBJECT_ID |
|
|
OBJECT_TYPE |
|
|
CREATED |
|
|
STATUS |
|
|
TABLE_NAME |
|
|
TYPECODE |
|
|
LAST_DDL_TIME |
|
|
SCHEMA_REPOSITORY |