Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSBASE.RTG_REF_PRD_FAC_NEXT_W_BANK
RTD_PRD_FACILITY_NEXT describes the product routing through multiple facilities including assembly. Its PK is both the source and destination (facility, prd). In between facilities, WIP also moves through end banks defined for each (facility, prd) and listed in RTD_PRD_END_BANKS. Normally these end-banks are sequential, so that WIP is routed through each of them in sequence in between the source (facility, prd) and the destination (facility, prd) This ref-view includes the movement through the end banks. If there is a route from (fac1, prd1)->(fac2, prd2) in RTG_PRD_END_BANKS, and there are 2 end-banks (bk1, bk2) in between, then the following 3 rows will appear in this view: (S_F S_P S_B) (D_F D_P D_B) FIRST_BANK --- --- --- --- --- --- ---------- fac1 prd1 NA fac1 prd1 bk1 bk1 fac1 prd1 bk1 fac1 prd1 bk2 bk1 fac1 prd1 bk2 fac2 prd2 NA bk1 The FIRST_BANK column is also included to account for the special case of non-sequential/optional end-banks, which are used at Bosch in the PKG facility. In this special case, all the END_BANK_SEQ_NUM are 1 for this (source_facility, source_prd). This ref-view is used to draw the edges and nodes of a directed graph describing multi-product routing, including end-banks.
|
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 |
|
|
SOURCE_END_BANK_SEQ_NUM |
|
|
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 |
|
|
DEST_END_BANK_SEQ_NUM |
|
|
DEST_MAIN_ROUTE |
|
|
FIRST_BANK |
|
|
END_BANK_STRUCTURE |
Indicates the ordering and structure of end-banks for a given PRD: if SEQUENTIAL, then WIP moves from the PRD route through the N end-banks in sequence (END_BANK_SEQ_NUM=1..N); if PARALLEL, then WIP moves from the PRD route to only of of the N end-banks (END_BANK_SEQ_NUM=1). (* inherited from FPSINPUT.RTG_PRD_END_BANKS) |
|
SOURCE_PRD_NUM |
When we have multiple source products for a next product, this indicates whether multiple sources are required or whether we choose between them. If four source products are 1, 2, 2, 3 that means we will assemble three products together but for the second product we can choose between the two. Perhaps this second product has an old and a new version. (* inherited from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
SOURCE_PRD_NUM_PREFERENCE |
We can have multiple source products with the same source_prd_num, indicating a choice among them. At most sites, the HIGHEST-numbered src_prd_num_preference represents the most recent version of a functionally equivalent product, and thus the most preferred option. (* inherited from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
DEST_PREFERENCE |
When a source product has multiple options for its next product this field indicates the preference. Usually this is 1. (* inherited from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
OVR_DEST_PLANPRD |
If this is blank we assume the planprd does not change when a lot moves to the next facility and/or prd. If the planprd changes then this is the new planprd. (* inherited from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
QTY_NEEDED |
The number of units needed of the source product for each unit in the next product. Typically this is 1 but occasionally we might assemble 2 A and 1 B together to make 1 C. (* inherited from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
CONSUMABLE_TYPE |
For assembly only, this optional field stores what type of consumable is being assembled into another part. (* inherited from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
SOURCE_WIP_QTY |
|
|
DEST_WIP_QTY |
|
|
EDGE_MOVES |
|
|
FRAC_OF_ALL_FROM_SOURCE |
|
|
FRAC_OF_ALL_TO_DEST |
|
|
LAST |
|
|
END |
|
|
DEST_PREFERENCE |
When a source product has multiple options for its next product this field indicates the preference. Usually this is 1. (* inherited from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
END |
|
|
DESC |
|
|
LAST |
|
|
END |
|
|
DESC |
|
|
FLUSH_RN |
|
|
DESC |
|
|
LAST |
|
|
DESC |
|
|
DESC |
|
|
REVERSE_RN |
|
|
REASON_WHY_NOT_FLUSH |
|
|
REASON_WHY_NOT_REVERSE |