FPSAPP.RTG_PRD_FACILITY_NEXT

Data Dictionary

FPSAPP Tables

> FPSAPP.RTG_PRD_FACILITY_NEXT

Table FPSAPP.RTG_PRD_FACILITY_NEXT"

Mapping of product routing through multiple facilities including assembly. PK is both source and next facility/prd for two reasons. First is that multiple source prds can be used to make the next prd. This is indicated by all source prds having the same source_prd_num. Also in this case the source prds should have the same planprd. Second is that assembled prds require multiple source prds. This is indicated by each source prd having a different source_prd_num. Note you could have a combination of these two cases as well.

Schema: FPSAPP
Tablespace: FPSDATA
Primary key: SOURCE_FACILITY, SOURCE_PRD, DEST_FACILITY, DEST_PRD

Column	Type	Nullable	Comment
SOURCE_FACILITY	VARCHAR2(6)	N	First facility in the process flow when a lot visits multiple facilities in sequence.
SOURCE_PRD	VARCHAR2(64)	N	First prd in the process flow when a lot visits multiple facilities in sequence.
DEST_FACILITY	VARCHAR2(6)	N	Facility where the lot will go after it completes its route in the current facility.
DEST_PRD	VARCHAR2(64)	N	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.
CONSUMABLE_TYPE	VARCHAR2(36)		For assembly only, this optional field stores what type of consumable is being assembled into another part.
DEST_PREFERENCE	NUMBER(3)		When a source product has multiple options for its next product this field indicates the preference. Usually this is 1.
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.
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.
SOURCE_PRD_NUM	NUMBER(3)	N	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.
SOURCE_PRD_NUM_PREFERENCE	NUMBER(3)	N	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.