Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSAPP.DASH_P_FACILITY_SHUTDOWNS
This view gets all shutdown periods not including normally scheduled shutdowns to show on the Dashboard Lot page progress chart. The tricky logic here is to compare adjacent shutdowns into a single period of shutdown for the Dashboard. For example, if the table has a record from 01/01 06:00 to 01/02 06:00 and has another record from 01/02 06:00 to 01/03 06:00 then this logic will combine those two records into a single row in this view from 01/01 06:00 to 01/03 06:00.