FPSADMIN.RTG_PRD_FAC_NEXT_W_BANK

SOURCE_FACILITY

VARCHAR2(6)

First facility in the process flow when a lot visits multiple facilities in sequence. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT)

SOURCE_PRD

VARCHAR2(64)

First prd in the process flow when a lot visits multiple facilities in sequence. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT)

SOURCE_BANK

VARCHAR2(36)

DEST_FACILITY

VARCHAR2(6)

Facility where the lot will go after it completes its route in the current facility. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT)

DEST_PRD

VARCHAR2(64)

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. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT)

DEST_BANK

VARCHAR2(36)

CONSUMABLE_TYPE

VARCHAR2(36)

For assembly only, this optional field stores what type of consumable is being assembled into another part. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT)

DEST_END_BANK_SEQ_NUM

NUMBER(2)

DEST_MAIN_ROUTE

VARCHAR2(256)

DEST_PREFERENCE

NUMBER(3)

When a source product has multiple options for its next product this field indicates the preference. Usually this is 1. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT)

DEST_WIP_QTY

NUMBER(9)

EDGE_MOVES

NUMBER(10)

END_BANK_STRUCTURE

VARCHAR2(11)

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). (* from FPSINPUT.RTG_PRD_END_BANKS)

FIRST_BANK

VARCHAR2(36)

FLUSH_RN

NUMBER(3)

FRAC_OF_ALL_FROM_SOURCE

NUMBER(4,3)

FRAC_OF_ALL_TO_DEST

NUMBER(4,3)

OVR_DEST_PLANPRD

VARCHAR2(64)

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. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT)

QTY_NEEDED

NUMBER(2)

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. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT)

REASON_WHY_NOT_FLUSH

VARCHAR2(43)

REASON_WHY_NOT_REVERSE

VARCHAR2(20)

REVERSE_RN

NUMBER(3)

SOURCE_END_BANK_SEQ_NUM

NUMBER(2)

SOURCE_PRD_NUM

NUMBER(3)

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. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT)

SOURCE_PRD_NUM_PREFERENCE

NUMBER(3)

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. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT)