data-dictionary
data-dictionary
Breadcrumbs

FPSBASE.WIP_STARTS_BY_LOT

Data Dictionary

>

FPSBASE Views

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSBASE.WIP_STARTS_BY_LOT

When WIP_STARTS has a record with a qty greater than 25 wafers (note 1) then this view distributes those starts into individual "lots" of 25 wafers each (note 2) with start times ranging evenly throughout the week (note 3). This view is gets used by the WIP_FLUSH and WIP_STEP_FUTURE so both of those objects get the distributed starts by lot as desired. For example, if we have 160 wafers recorded to start in a particular week then we would show 25 on each day Mon-Sat and then the remaining 10 on Sunday. Note 1: Technically speaking we use the max_qty_per_carr value for GEN_FACILITIES which is usually 25 for wafer facilities but for backend facilities measuring qty in die it is obviously much larger. Note 2: Note that the last lot will have less than 25 wafers unless the start qty is an exact multiple of 25. Note 3: Most sites record the starts in WIP_STARTS by week but technically this works for any period.

Column

Comment

FACILITY

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

LOT_OR_ALT_ID

This is the primary key of this table which is the actual lot ID if available or an alternate ID if not. That alternate ID would likely be a combination of the product and start date range. Note that we can record starts representing more than one lot with a single record in this table. For example, we might have 200 starts for a product during an upcoming work week and we would enter 200 as start_qty and the start of the work week as inst and the end of the work week as start_range_end_inst. Then we would assume those starts would be distributed in lots matching the max_qty_in_carrier for the facility across the entire work week. Alternatively we might record single lot starts with a specific start time by entering the lot as lot_or_alt_id and the qty as start_qty and the start time as inst and leave start_range_end_inst blank. (* inherited from FPSINPUT.WIP_STARTS)

TARGET_CARRIER

This is the carrier that the future start lots planned to be assigned. (* inherited from FPSINPUT.WIP_STARTS)

PRD

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

PLANPRD

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

ROUTE

Route that has threading requirements (* inherited from FPSINPUT.RTG_STEP_THREADING)

LOT_TYPE

Lot_type is the base of the hierarchy that determines lot_family then lot_group. Ideally lot_type will come straight from the MES with little modification. (* inherited from FPSINPUT.WIP_LOT_TYPES)

PLAN_PRIORITY

Permanent priority of the lot set in the MES generally by planning. (* inherited from FPSINPUT.WIP_EVENT_HIST)

START_QTY

See comments in LOT_OR_ALT_ID. (* inherited from FPSINPUT.WIP_STARTS)

NUM_LOTS

NUM_IN_START_RECORD

QTY

Quantity of units in the lot according the qty_unit defined for the facility. It is required for all lots in each facility to have their qty defined in the same units therefore the change in the unit is critical to defining the facility. For example, a pretest facility might have a sort step in the middle where we learn the qty of die. Prior to this step we know only the wafer qty but after this step we know both wafer and die. Since wafer is the only qty we know throughput the flow then wafer must be defined as the qty unit for this facility. Die can then be populated as sec_qty when it is known. Similarly the wafer saw facility might have a step in the middle where we cut the wafers into die. After this step we no longer know the number of wafers which means that die must be the qty unit for this facility and wafers can be the sec_qty prior to the saw step. Please note that a lot with qty of 0 is allowed but only if the sec_qty is greater than 0. This is unusual but one case is where we know the wafers will be scrapped but cannot be scrapped quite yet. (* inherited from FPSINPUT.WIP_EVENT_HIST)

INCLUDE_IN_WSF

Indicates whether this start should be included in the WIP_STEP_FUTURE table. Please only set this to Y for starts within a week or two because a larger WIP_STEP_FUTURE table can impact the speed of the RealTime job and the overall database. Plus there is no need to have starts in the distant future in WIP_STEP_FUTURE. (* inherited from FPSINPUT.WIP_STARTS)

ORIG_START_INST

Original Start Date of this lot. Normally it is the same of START_INST, but it can also be different since it was supposed to start earlier but it was not. (* inherited from FPSINPUT.WIP_STARTS)

START_RANGE_END_INST

If populated this means that the starts will occur across a range of time. If blank this means the start will occur at the specific inst. See comments in LOT_OR_ALT_ID for examples. (* inherited from FPSINPUT.WIP_STARTS)

DISTRIBUTED_END_INST

START_INST

Time when the lot started. (* inherited from FPSINPUT.WIP_STARTS)