Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSBASE.RTG_REF_ALL_PRD_SPLIT_30DAY
This view estimates the fraction of a given source (facility, prd, bank) that continues into each of multiple destinations (facility, prd, bank). Estimation is based on moves over the last 30 days. Originally this view included a ranking of the likelihood that a move from a given source will go to each of multiple possible destinations, or that a move to a given destination will come from each of multiple possible sources. With DWH-2704, we moved this to RTG_PRD_FAC_NEXT_W_BANK so this is now just the raw data. Please note that this includes all moves to a new facility, prd, or bank including moves that are not mapped in RTG_PRD_FACILITY_NEXT so it is left joined in RTG_PRD_FAC_NEXT_W_BANK.
|
Column |
Comment |
|---|---|
|
SOURCE_FACILITY |
First facility in the process flow when a lot visits multiple facilities in sequence. (* inherited from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
SOURCE_PRD |
First prd in the process flow when a lot visits multiple facilities in sequence. (* inherited from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
SOURCE_BANK |
|
|
DEST_FACILITY |
Facility where the lot will go after it completes its route in the current facility. (* inherited from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
DEST_PRD |
Prd which will the lot will assume after it completes its route in the current facility. This could be the same as the current prd. (* inherited from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
DEST_BANK |
|
|
EDGE_MOVES |