Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSAPP.WFM_P_RTG_PRD_FAC_NEXT_W_BANK
This view will replicate RTG_PRD_FAC_NEXT_W_BANK
|
Column |
Comment |
|---|---|
|
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) |
|
DEST_BANK |
|
|
DEST_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_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_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) |
|
FIRST_BANK |
|
|
IS_FLUSH_PATH |
|
|
IS_REVERSE_PATH |
|
|
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) |
|
SOURCE_BANK |
|
|
SOURCE_END_BANK_SEQ_NUM |
|
|
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_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) |