FPSAPP.MHS_BUILDINGS

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).

BG_COLOR

VARCHAR2(24)

Background color assigned. BG_COLOR is in English like red or blue or light green and we look up the HTML color like #FF0000 in the GEN_COLORS table. BG_COLOR must be set manually but the FPSADMIN view BLD_POPULATE_COLORS will generate queries to randomly set bg_color for all values in a table. (* from FPSINPUT.GEN_CUSTOMERS)

DEF_BAY_TO_BAY_TRANSPORT_MODE

VARCHAR2(10)

Default building level bay to bay transport mode. If no other mode is specified, this will be the value used to direct wip within a building from bay to bay.

DEF_CAST_TRANSIT_SEC_BAY_CART

NUMBER(5)

Default transit time for a cassette to move from a cart to any bay in the same building.

DEF_CAST_TRANSIT_SEC_NEAR_BAY

NUMBER(5)

Default transit time for a cassette to move to a nearby bay.

DEF_CAST_TRANSIT_SEC_SAME_BAY

NUMBER(5)

Default transit time for a cassette to move to a different station in the same bay.

DEF_CAST_TRANSIT_SEC_SAME_BLDG

NUMBER(5)

Default transit time for a cassette to move to another bay in the same building.

DEF_IN_BAY_TRANSPORT_MODE

VARCHAR2(10)

DEF_POD_TRANSIT_SEC_BAY_CART

NUMBER(5)

Default transit time for a pod to move from a cart to any bay in the same building.

DEF_POD_TRANSIT_SEC_NEAR_BAY

NUMBER(5)

Default transit time for a pod to move to a nearby bay.

DEF_POD_TRANSIT_SEC_SAME_BAY

NUMBER(5)

Default transit time for a pod to move to different station in the same bay.

DEF_POD_TRANSIT_SEC_SAME_BLDG

NUMBER(5)

Default transit time for a pod to move to another bay in the same building

SORT_ORDER

NUMBER(4)

This is used to sort within the grouping. SORT_ORDER always has a deferrable unique key to ensure uniqueness while allowing the user to make changes without erroring until the commit is attempted. Because of this you must be careful to not violate the unique key otherwise you will lose all of your edits. (* from FPSINPUT.GEN_FACILITIES)