FPSADMIN.MHS_VEHICLES

VEHICLE

VARCHAR2(24)

Field that uniquely identifies a vehicle.

BUILDING

VARCHAR2(12)

N

Building is the top of our MHS hierarchy at each site. It is independent of facility which is at the top of our EQP/RTG hierarchy. It is possible for a building to include multiple facilities and for a facility to include multiple buildings but we do not even need to define these relationships because EQP_TOOLS determines this by the combination of the facility and bay columns (since bay points to building). (* from FPSINPUT.MHS_BUILDINGS)

CAST_CAPACITY

NUMBER(3)

Maximum number of cassettes that can be stored. We define cassette as a carrier for a lot. (* from FPSINPUT.MHS_RACK_LOCATIONS)

HOME_BAY

VARCHAR2(12)

Assign vehicle to a home bay for the normal place where the cart resides. If you assign a home bay, then the transit times for lots on the vehicle will be determined using the bay to bay matrix with the home bay as the from bay.

IS_AMHS

CHAR(1)

This field indicates if the stocker is part of the Automated Material Handling System. (* from FPSINPUT.MHS_STOCKERS)

IS_AUTO_SLOT_ASSIGNMENT

CHAR(1)

Y means automatically assign lot locations on carts. N means let the user assign the slot by scanning the lot then scanning the location.

IS_LAST_LOC_UNLOAD

CHAR(1)

Y means the last activity for the vehicle was a load. N means it was an unload.

LAST_LOCATION

VARCHAR2(32)

Last location of vehicle is set by trigger based on the previous location of the carrier most recently loaded from/to the vehicle.

LAST_LOCATION_INST

DATE

Time when the vehicle last loaded or unloaded a carrier.

MNT_FACILITY

VARCHAR2(6)

Stockers and vehicles are locations but they are also maintenance entities. Location is independent of facility so the mnt_facility is not relevant as far as location. But maintenance entities needed a facility and this mnt_facility column is used exclusively for that purpose. (* from FPSINPUT.MHS_STOCKERS)

MNT_FAMILY

VARCHAR2(50)

MNT_FAMILY is assigned to each EQP_TYPE. Tools in the same MNT_FAMILY are similar and share the same maintenance schedule. (* from FPSINPUT.EQP_MNT_FAMILIES)

MNT_MODULE

VARCHAR2(12)

MNT_MODULE is the module responsible for maintaining the tool and is a property of MNT_FAMILY. See comments on the module column in GEN_MODULES for how it relates to eqp_module and mnt_module. (* from FPSINPUT.EQP_MNT_FAMILIES)

POD_CAPACITY

NUMBER(3)

Maximum number of pods that can be stored. We define pod as a carrier for a durable. (* from FPSINPUT.MHS_RACK_LOCATIONS)

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_DISPLAY

VARCHAR2(32)

N

Optional column to show a user friendly vehicle name on the NextMove GUI which is different that the vehicle name on the barcode.

VEHICLE_ROUTE

VARCHAR2(36)

A route that vehicles (carts) can take to pick up and drop off carriers around the site. (* from FPSINPUT.MHS_VEHICLE_ROUTES)

VEHICLE_STATE

VARCHAR2(36)

The state of the vehicle, which is typically used for determining whether it can be used or not.

VEHICLE_STATE_DISPLAY

VARCHAR2(128)

N

The name of the vehicle state displayed on all dashboards and reports. Vehicle_state must match the FPS list defined in MHS_VEHICLE_STATES but this display field might be formatted in a more familiar way to the users.