Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSADMIN.RECENT_TREND_SPECIFIED_OBJECTS
Useful query to plot trends of specific objects over a period of time. Just use like this: select * from recent_trend_specified_objects where object_name = 'WIP_CURR_LOTS_TOOLS'; select * from recent_trend_specified_objects where object_name in ('WIP_LOTS_STATIC','WIP_LOTS_VERIFY'); We suggest that you copy paste this directly into Excel and make a PivotTable with object_name on the left side and round_time along the top. For a longer time period, remove the HH from the trunc to group by day instead of hour.
|
Column |
Comment |
|---|---|
|
ROUND_TIME |
|
|
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) |
|
N |
|
|
AVG_SEC |
|
|
STDDEV_SEC |
|
|
MIN_SEC |
|
|
PERC10 |
|
|
PERC20 |
|
|
PERC30 |
|
|
PERC40 |
|
|
MED_SEC |
|
|
PERC60 |
|
|
PERC70 |
|
|
PERC80 |
|
|
PERC90 |
|
|
MAX_SEC |
|
|
OBJECT_AVG |