FPSBASE.MHS_DELIVERY_NEXT

LOT

VARCHAR2(32)

N

A lot is a group of units that process together. Usually lot_id or lot_number in MES. All units in a lot are in the same carrier but there may be multiple lots in a carrier. (* from FPSINPUT.WIP_LOTS_STATIC)

BLDG_INPUT_STATION

VARCHAR2(32)

BLDG_OUTPUT_STATION

VARCHAR2(32)

CARRIER

VARCHAR2(32)

N

RFID of the cassette or FOUP the lot is currently in. (* from FPSINPUT.MHS_CARRIERS)

CURR_BAY

VARCHAR2(12)

Current bay of carrier. See column comment on BAY in FPSINPUT.MHS_BAYS for more information.

CURR_BUILDING

VARCHAR2(12)

Current building of carrier. See column comment on BUILDING in FPSINPUT.MHS_BUILDINGS for more information.

CURR_LOC

VARCHAR2(32)

Current location of carrier. See column comment on LOCATION in FPSINPUT.MHS_RACK_LOCATIONS for more information.

CURR_LOC_TYPE

VARCHAR2(64)

Current location type of carrier. See view MHS_LOCATIONS for more information.

CURR_STATION

VARCHAR2(32)

See column comment on STATION in FPSINPUT.MHS_STATION_ALTERNATES for more information.

CURR_STATION_TYPE

VARCHAR2(32)

Current station type of carrier. See view MHS_LOCATIONS for more information.

DEST_STATION

VARCHAR2(32)

The final destination the lot is required to move. Typically the reserved tool but also can be the scheduled tool if the client wants too, but this should be with caution as the scheduled tool can change

DIRECT_DELIVERY_BAY

VARCHAR2(12)

DURABLE_CARRIER

VARCHAR2(32)

The durable carrier ID of the durable required for this carrier to process.

DURABLE_LOCATION

VARCHAR2(32)

The location of the durable.

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)

INPUT_STATION

VARCHAR2(32)

Bay input rack assigned to the carrier based on either reserved or scheduled tool

IS_DEST_BAY_NEAR

CHAR(1)

IS_DURABLE_AT_DESTINATION

CHAR(1)

NextMove flag indicating if the durable location is the same as the tool the carrier needs to process on.

IS_DURABLE_REQUIRED

CHAR(1)

NextMove flag indicating if the carrier requires a durable to process.

IS_N2

CHAR(1)

Flag to display N2 icon in NextMove if lot requires N2 (nitrogen purged) storage. In a future version we will allow more generic AMHS-related flags but this is specific to N2 for now.

IS_QUEUE_TIMER

CHAR(1)

Flag to display queue timer icon in NextMove if lot is in queue time loop.

IS_RESERVED

CHAR(1)

This flag indicates if the carrier has been reserved to a tool.

LAST_KNOWN_DURABLE_LOC

VARCHAR2(32)

The previous location of the durable.

LAST_KNOWN_LOCATION

VARCHAR2(32)

Often when a carrier is in transit we do not know exactly where it is but we only know where it came from. In this case we might set the location to something generic like TRANSIT and the last known location to where it came from. (* from FPSINPUT.MHS_CARRIERS)

LAST_KNOWN_LOCATION_INST

DATE

Time when the last_known_location was originally updated as the location of this carrier. This column and last_known_location are both updated by trigger. (* from FPSINPUT.MHS_CARRIERS)

NEXT_STATION

VARCHAR2(32)

OUTPUT_STATION

VARCHAR2(32)

Bay output rack assigned to the carrier if it reserved to a tool that is not nearby or not scheduled to run soon to move to an overflow area.

OVERFLOW_STATION

VARCHAR2(32)

Rack to send the carrier when it is not reserved or scheduled to run soon

SCHED_TRANSIT_SEC

NUMBER(6)

The transit time from the carriers current location to the destination

STAGE_STATION

VARCHAR2(32)

Staging rack for the reserved or scheduled tool if a staging rack exists.

TIME_TO_NEXT_MOVE_OVR

DATE

This column allows for sites to control the NextMove countdown timers. Normally we do not populate this but for certain use cases clients may want to change this value based on certain criteria.

TOOL_FOR_TTS

VARCHAR2(16)

TTS for tool is greatest(last start plus EET of last start, data_date). TTS for first lot not started is the same as the TTS for tool but we need to store TTS for tool because tool might not have any reserved lots. TTS for subsequent lots cums the EET of each lot after the first lot. (* from FPSBASE.WIP_STEP_FUTURE_SCHED)

TRANSPORT_MODE

VARCHAR2(10)

Name of the standard FPS transport mode which represents how material is moved from one location to another. (* from FPSINPUT.MHS_EXTERNAL_TRANSPORT_MODES)

TTS_BAY

VARCHAR2(12)

Bay of the tool where this carrier is reserved or scheduled.

UPDATED_INST

DATE

Time when the record was updated according to the source data. Note this is not the time when the record was actually updated in this table - it will almost always be earlier. (* from FPSINPUT.GEN_FACILITIES)

VEHICLE_SUB_ROUTE

VARCHAR2(36)

Sub route associated to a cart or carts within a vehicle route. (* from FPSINPUT.MHS_VEHICLE_SUB_ROUTES)