Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSADMIN.CHK_ALL
This view uses the function CHK_ALL_TO_TABLE to first refresh all DBF tables and then query all of the CHK and SYSMNTR views at once. Because it refreshes the tables first the records returned from this view are realtime but this takes about a minute. To simply bring up the results without refreshing just query CHK_ALL_NO_REFRESH.
|
Column |
Comment |
|---|---|
|
SYSMNTR_OR_CHK_NAME |
|
|
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) |
|
TABLE_OR_COMPONENT |
|
|
COLUMN_OR_STATUS |
|
|
PROBLEM |
|
|
LAST_START_TIME |
|
|
REMAINING_COLS |
|
|
SQL_QUERY |
|
|
RN |