Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSADMIN.RECENT_TREND_BY_OBJECT
Useful query to plot trends of each object in the 3min job over a period of time. 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 |
|
|
OVERALL_OBJECT_AVG |