Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSADMIN.SYSMNTR_HEALTH
We want CHK_ALL to show us everything we need to know about the DWH in one query. The other SYSMNTR views shows us if anything is wrong but we also want to check on the load intervals and trends so this view adds some important information: -Always return one row listing the DWH version -Always return one row summarizing the performance of the job including WIP_EVENT_HIST with average last hour, max last hour, and average last day. -Always return one row summarizing the performance of the job including MHS_CARRIERS
|
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) |
|
PROBLEM |
|
|
LAST_START_TIME |
|
|
COMPONENT |
|
|
STATUS |
|
|
SQL_QUERY |