FPSAPP.WFM_P_TOP_PRD_BANK_INFO

DEST_FACILITY

VARCHAR2(6)

N

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)

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

FACILITY

VARCHAR2(6)

N

Facility is included in almost every join in the DWH so this represents a definitive split. A route must have all steps on tools in the same facility. A tool must process all lots in the same facility. If your site has multiple buildings where lots run on routes using tools in multiple buildings then everything should be one facility. For example, multiple Fab buildings. But if your site has independent facilities like Fab and Test and Assembly where lot may progress from one to the next but on different routes then these should be different facilities. Since this column is in virtually every table it is critical that the value here is exactly matches what is in the MES if the MES has facility. Use facility_display for the display friendly name displayed in applications. See site_name comment for client/site/facility example. (* from FPSINPUT.GEN_FACILITIES)

PRD

VARCHAR2(64)

N

Prd determines the route which is used to process the lot in the facility and what tools, recipes, durables, etc. can be used at each step. Prd also determines the next facility for the lot when it finishes its route. For detailed information on prd vs. planprd see table comments in RTG_PLANPRDS. (* from FPSINPUT.RTG_PRDS)

BANK

VARCHAR2(36)

N

Lots which are not on a route are considered in a bank and the bank name indicates why the lot is off route. Bank must be NA for lots which are on a route. Our standard filter for active lots is bank = NA. (* from FPSINPUT.RTG_BANKS)

AVG_DEMAND_PER_DAY_NEXT_MO1

NUMBER

AVG_DEMAND_PER_DAY_NEXT_MO2

NUMBER

AVG_DEMAND_PER_DAY_NEXT_MO3

NUMBER

AVG_START_PER_DAY_NEXT_MO1

NUMBER

AVG_START_PER_DAY_NEXT_MO2

NUMBER

AVG_START_PER_DAY_NEXT_MO3

NUMBER

CT_DAYS_7D_MED

NUMBER

CT_DAYS_7D_WAVG

NUMBER

CT_DAYS_FULL_WAVG

NUMBER

DEMAND_BACKLOG

NUMBER

DEST_END_BANK_SEQ_NUM

NUMBER

DRUM_PER_DAY_USING_7D_AVG

NUMBER

DRUM_PER_DAY_USING_7D_MEDIAN

NUMBER

DRUM_PER_DAY_USING_FULL_WAVG

NUMBER

N_LOTS

NUMBER

OUTSIDE_SOURCE

VARCHAR2(50)

For all PRDs that are externally sourced (e.g. purchased or produced at an external site), this field describes their source. (* from FPSINPUT.RTG_PRDS)

PLANPRD

VARCHAR2(64)

Planning product used for all planning purposes. All lots with the same planprd are interchangeable to ship to the customer regardless of their prd, route, technology, wafer size, etc. For detailed information on prd vs. planprd see table comments in RTG_PLANPRDS. (* from FPSINPUT.RTG_PLANPRDS)

QTY_IN

NUMBER

QTY_OUT

NUMBER

QTY_UNIT

VARCHAR2(12)

N

Defines the unit used to measure number of quantity. The key here is that this quantity must be known throughout the entire route through the facility. For example in a sort facility where lots enter in wafers and are broken into die but the number of wafers is still known when the lot completes the facility then the qty_unit must be wafer. It cannot be die because die is not known when the lot enters so die will be the sec_qty_unit. Similarly at a final test facility where the lots enter with both wafers and die known but only die are known when the lot completes the facility then the qty_unit must be die. It cannot be wafer because wafer is not known when the lot completes so wafer will be the sec_qty_unit. Please note the entire process from only wafers to only die must be split into at least two facilities because of this requirement. (* from FPSINPUT.GEN_FACILITIES)

REVERSE_FLUSH_SEQ_NUM

NUMBER

TOTAL_COMMIT_CT_DAYS

NUMBER

TOTAL_QTY

NUMBER

TOTAL_QTY_ENDED

NUMBER

TOTAL_QTY_HOLD

NUMBER

TOTAL_QTY_PROC

NUMBER