data-dictionary
data-dictionary
Breadcrumbs

FPSBASE.MHS_RACK_LOCATIONS

Data Dictionary

>

FPSBASE Tables

> FPSBASE.MHS_RACK_LOCATIONS

Table FPSBASE.MHS_RACK_LOCATIONS"

This table includes locations on racks. Populating this table is optional and depends on the specificity of the carrier tracking. If carrier tracking sets to location to the specific spot on each rack then we must populate this table will all of these specific locations. But if the carrier location is set only to rack then the location would be the rack and there is no reason to populate this table. When NextMove determines that a carrier should move to a rack, the destination will always be the rack and never a specific location on that rack. This is why we have curr_location and dest_station.

  • Schema: FPSBASE

  • Tablespace: FPSDATA

  • Primary key: LOCATION

  • Foreign keys: MHS_RACK_LOCATIONS_FK_RACK: RACK REFERENCES FPSINPUT.MHS_RACKS (RACK)


Column

Type

Nullable

Comment

LOCATION

VARCHAR2(32)

N

Location of a carrier or lot or durable which comes directly from the tracking system used at the site. This could be a port or internal tool location or tool or rack or stocker or zero footprint storage or room or really anywhere. Many non-automated sites allow users to manually enter locations into their system. Therefore unless we know for sure that the source data implements a size limitation, it is recommended to always trim the value in the ETL to 32 characters to fit into the column size and avoid load errors. For ports, location is the full name of the port which is unique across the entire site and usually includes the tool name. Please see the comment in the port column which explains the difference between location and port. Rack locations are similar.

BARE_DRBL_CAPACITY

NUMBER(4)

Maximum number of bare durables that can be stored. Bare durables are durables which are not in a pod.

BARE_WFR_CAPACITY

NUMBER(4)

Maximum number of bare wafers that can be stored. Bare wafers are lots which are not in a cassette.

CAST_CAPACITY

NUMBER(3)

Maximum number of cassettes that can be stored. We define cassette as a carrier for a lot.

COORD_X

NUMBER(2)

This is the x coordinate position of the location within its station, in other words horizontal position. The maximum coord_x is the width of the station. This is optional and is often used for racks and sometimes for carts so we can determine the exact position of the carrier to make it easier to find.

COORD_Y

NUMBER(2)

This is the y coordinate position of the location within its station, in other words vertical position or shelf number. The maximum coord_y is the height of the station. This is optional and is often used for racks and sometimes for carts so we can determine the exact position of the carrier to make it easier to find.

COORD_Z

NUMBER(1)

This is the z coordinate position of the location within its station, in other words front-to-back position. This is usually 1. The maximum coord_z is the depth of the station. This is optional and is often used for racks and sometimes for carts so we can determine the exact position of the carrier to make it easier to find.

IS_DISPLAY_SLOT

CHAR(1)

Identifies slot on smart rack where the tablet is positioned, so a lot is unable to be stored there.

LOC_ON_RACK

VARCHAR2(5)

This is the short name of the location on the rack, probably a combination of the x, y, and z coordinates. This field is unique within the given rack and is used to save space when we already know the rack, for example on the rack NextMove screen. If the rack is the location then this should be blank. This column is in contrast to the location field which is the full name of the location. Location is unique within the entire site and almost always includes the rack name. Location is what is in MHS_CARRIERS and gets set when the carrier arrives as the location.

POD_CAPACITY

NUMBER(3)

Maximum number of pods that can be stored. We define pod as a carrier for a durable.

RACK

VARCHAR2(32)

N

Rack is the parent of location and is where we ask to send the carrier. (* from FPSINPUT.MHS_RACKS)