FPSINPUT.MHS_STOCKER_PORTS

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. (* from FPSINPUT.MHS_RACK_LOCATIONS)

BARE_DRBL_CAPACITY

NUMBER(4)

Maximum number of bare durables that can be stored. Bare durables are durables which are not in a pod. (* from FPSINPUT.MHS_RACK_LOCATIONS)

BARE_WFR_CAPACITY

NUMBER(4)

Maximum number of bare wafers that can be stored. Bare wafers are lots which are not in a cassette. (* from FPSINPUT.MHS_RACK_LOCATIONS)

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)

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. (* from FPSINPUT.MHS_RACK_LOCATIONS)

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. (* from FPSINPUT.MHS_RACK_LOCATIONS)

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)

PORT

VARCHAR2(5)

Port is the short name of the port on the tool like P1 or LLA. This field is unique within the given tool and is used to save space when we already know the tool, for example in the dashboard tool hover where we show the status of each port. This column is in contrast to the location field which is the full name of the port. Location is unique within the entire facility and almost always includes the tool name like ET99P1 or ET99LLA. In addition, location is usually available from the MES or AMHS as this must be an exact match with the location in MHS_CARRIERS if this gets set when a carrier is placed on the port. On the other hand, the shorter port column is often not available in the MES so we either populate manually or with some complex if-then logic in the ETL based on the naming standards. (* from FPSINPUT.EQP_PORTS)

STOCKER

VARCHAR2(16)

N

Stocker is effectively similar to a rack except that it stores carriers internally and has input and output ports. (* from FPSINPUT.MHS_STOCKERS)