FPSINPUT.WIP_STARTS

LOT_OR_ALT_ID

VARCHAR2(128)

N

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.

DUE_INST

DATE

To indicate the due date for this futuer start lot

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)

GBL_SORT

NUMBER(38)

Sorting used for dispatching or allocation systems to sort future start lots based on priority, critical ratio, etc.

INCLUDE_IN_WIP_FLUSH

CHAR(1)

Indicates whether this start should be included in the WIP_FLUSH table. Generally this should be Y for near future starts and N for those which are more distant but it is fine to set for all or none depending on your use of WIP_FLUSH.

INCLUDE_IN_WSF

CHAR(1)

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.

LOT_TYPE

VARCHAR2(24)

N

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

ORIG_DUE_INST

DATE

Original Due Date of this lot

ORIG_START_INST

DATE

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.

PLANPRD

VARCHAR2(64)

N

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)

PLAN_PRIORITY

VARCHAR2(7)

N

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

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)

START_INST

DATE

N

Time when the lot started.

START_PARM1

NVARCHAR2(256)

First parameter to store whatever value is desired for the site. These can be used for ETL of other tables or site reports or just storing useful data related to upcoming starts.

START_PARM2

NVARCHAR2(256)

Second parameter to store whatever value is desired for the site. These can be used for ETL of other tables or site reports or just storing useful data related to upcoming starts.

START_PARM3

NVARCHAR2(256)

Third parameter to store whatever value is desired for the site. These can be used for ETL of other tables or site reports or just storing useful data related to upcoming starts.

START_QTY

NUMBER(8)

N

See comments in LOT_OR_ALT_ID.

START_RANGE_END_INST

DATE

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.

TARGET_CARRIER

VARCHAR2(32)

This is the carrier that the future start lots planned to be assigned.