Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSADMIN.SYSMNTR_MISS_EVENTS
This view summarizes count of DIFF and MISS events in the last 24 hours for both WIP and EQP which indicate less than perfection with ETL.
|
Column |
Comment |
|---|---|
|
UNION_SORT |
|
|
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) |
|
NUM_MISSES |
|
|
HRS_IN_QUERY |
|
|
EVENT |
This is the event registered in the MES. This is for the historical record and display only. Each event is mapped to an FPS event_type and the event_type is what is used by FPS applications. (* inherited from FPSINPUT.WIP_EVENTS) |
|
LAST_START_TIME |
|
|
COMPONENT |
|
|
STATUS |