Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSADMIN.CHK_ALL_NO_REFRESH
This view uses the function CHK_ALL_TO_TABLE to query all of the CHK and SYSMNTR views at once. Unlike the normal CHK_ALL, this view does not refresh the DBL tables so it is very fast but only pulls up the last run of CHK_ALL rather than the realtime updated information.
|
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 |