Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSAPP.CTA_P_H_LOT_STEP
Query to use for drilldown to individual lot-step records. CTA has three drill downs: 1) From lot to all steps for lot with filter on lot. 2) From process to all lot-steps for process with filter on facility and process. 3) From bank to all lots for bank with filter on facility and bank This view is extremely sensitive to speed for both #2 and #3 so we did extensive testing to determine that this syntax was the fastest. Please be very careful making any changes to this view.
|
Column |
Comment |
|---|---|
|
BANK |
Lots which are not on a route are considered in a bank and the bank name indicates why the lot is off route. Bank must be NA for lots which are on a route. Our standard filter for active lots is bank = NA. (* inherited from FPSINPUT.RTG_BANKS) |