FPSBASE.BLD_VS_PROC_CT_BY_ROUTE

>

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSADMIN.BLD_VS_PROC_CT_BY_ROUTE

This useful view compares the Finished CT on three databases, the old method for Dynamic CT on all three databases, TCT (from our Throughput Calculations) on all three databases, and the new method for Dynamic CT on this database. It is critical to choose a set of filters that return only one set of records from CTM_SUMMARY. By one set, I mean an entire prd but just one record for each step. In other words, this should filter by the primary key except for step. To use this, just find/replace for FFF, PPP, GGG, and @yourdblink plus 'Prod' if your production lot_group is not Prod.