Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSBASE.CHK_CALENDARS
This view combines many sanity checks on the CAL tables that originally were check constraints into a CHK view. The constraints were annoying because they would prevent insert and update so it was really difficult to figure out what was wrong and fix it. After creating or modifying the calendars you should check this view and it should have no rows.
|
Column |
Comment |
|---|---|
|
TABLE_NAME |
|
|
PROBLEM |
|
|
START_CAL_PERIOD |
|
|
END_CAL_PERIOD |
|
|
SQL_QUERY |