data-dictionary

FPSAPP.WFM_P_RTG_PRD_FAC_NEXT_W_BANK

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)