FPSADMIN.GP_REF_B_ROUTE_STEPS

>

> FPSADMIN.WIP_WAFER_HIST_LOOP

View FPSAPP.GP_REF_B_ROUTE_STEPS

This view determines drum rate per shift, day, or rolling period and target WIP levels by route and step. The drum rate is calculated based on target cycle time and current WIP within each route-route_section. Target WIP is calculated based on step process time and crurent WIP within each route-route_section, then adjusted based on historical sampling rates, target WIP multipliers, and directly provided target WIP values that are specified in the Goal Planner configuration. These multipliers and values are usually set to buffer more WIP in front of bottleneck toolsets. There are separate views for each level of detail which was deemed easier to manage than using one larger query with many more partitions and joins at the different levels of detail. Changes made in one view should likely be made in the others.