FPSBASE.CTR_E_PRD_BY_PROC_STATE

>

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSAPP.CTR_E_PRD_BY_PROC_STATE

This view exists only as an example of the query used in the website to get data for the single facility view when grouped by process state and filtered by criteria not including process family nor module nor bank. It is both for reference and to ensure it does not become invalid. This query is similar to the all facilities query except it uses a different view, has a facility filter, and treats commit/target a bit differently since they are totals across the series (which is process state). IMPORTANT NOTE: The total lots in this view is NOT the total number of finished lots for the relevant filtering when we have a ctm_series with multiple ctm_series_seq_in_fac values. When we have these ordered series, only the last seq actually finishes the facility while the first seq are merged into the prds in the last seq. To account for this, we just take the minimum of the num_lots from all seq in the series as the num_lots of the series.