FPSBASE.MHS_BAYS

BAY

VARCHAR2(12)

A bay is a physical area within the building. The bay is important for estimating travel time for a carrier to reach its destination as we usually store these estimates as a matrix of bay-to-bay and assume that the estimated time from any location within one bay to any location within another bay is approximately the same.

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)

IN_BAY_TRANSPORT_MODE

VARCHAR2(10)

Bay level in bay transport mode. If no other mode is specified, this will be the value used to direct wip within a bay internally.

MAP_COORD_X

NUMBER(4)

This is the x coordinate of the bay on a map of the building. MHS_BAY_TO_BAY_MATRIX_PLUS uses the distance to estimate the bay-to-bay transit time if it is not specifically populated in MHS_BAY_TO_BAY_MATRIX.

MAP_COORD_Y

NUMBER(4)

This is the y coordinate of the bay of a map of the building. See MAP_COORD_X comment for more details.