Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSAPP.WFM_P_RTG_PRD_FACILITY_NEXT
This view will replicate fpsinput.rtg_prd_facility_next
|
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_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) |
|
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_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) |