FPSBASE.RM_P_DURABLES_IRL

FACILITY

Facility is included in almost every join in the DWH so this represents a definitive split. A route must have all steps on tools in the same facility. A tool must process all lots in the same facility. If your site has multiple buildings where lots run on routes using tools in multiple buildings then everything should be one facility. For example, multiple Fab buildings. But if your site has independent facilities like Fab and Test and Assembly where lot may progress from one to the next but on different routes then these should be different facilities. Since this column is in virtually every table it is critical that the value here is exactly matches what is in the MES if the MES has facility. Use facility_display for the display friendly name displayed in applications. See site_name comment for client/site/facility example. (* inherited from FPSINPUT.GEN_FACILITIES)

CARRIER

RFID of the cassette or FOUP the lot is currently in. (* inherited from FPSINPUT.MHS_CARRIERS)

CARRIER_CLASS

Carrier class indicates what the carrier is able to carry. It is also an important field in EQP_PORTS but each port has a single defined carrier class and only carriers of this class should go to the port. The value must be one of those defined by FPS in FPSADMIN.MHS_CARRIER_CLASSES which include POD or CAST or BOX. This would be used as a filter on what carriers could be selected when a carrier is needed. For example, when a lot is split we need to find another carrier for the split lot and we select the best carrier in the carrier_class of CAST. But if we need to unload a reticle then we select the best carrier in the carrier_class of POD. (* inherited from FPSINPUT.MHS_CARRIERS)

CAPACITY

In EQP_PORTS, capacity is the number of carriers allowed on the port, which is usually 1. In MHS_CARRIERS, when carrier_class is set to POD then capacity is the number of durables that the pod can hold, which is usually either 1 or 6. This field is only used in MHS_CARRIERS for pods therefore when CARRIER_CLASS is CAST then capacity should be set to the default value of 1. (* inherited from FPSINPUT.EQP_PORTS)

CARRIER_ASGN_TOOL

LOCATION

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

STATION

The rack, bay, building, tool, cart, or stocker which has alternately acceptable stations (* inherited from FPSINPUT.MHS_STATION_ALTERNATES)

STATION_TYPE

SLOT_NUM

The slot number the durable is occupying in its pod. This applies when a durable is stored in a pod that can hold multiple durables. (* inherited from FPSINPUT.RTG_DURABLES)

CURR_DURABLE

CURR_DURABLE_STATE

CURR_DURABLE_STATE_DISPLAY

CURR_DRBL_ACTION_TOOL

CURR_DRBL_NEW_MOVE_ACTION

CURR_DRBL_NEW_MOVE_SCHEDULE

NEXT_DURABLE

NEXT_DURABLE_STATE

NEXT_DURABLE_STATE_DISPLAY

NEXT_DRBL_ACTION_TOOL

NEXT_DRBL_NEW_MOVE_ACTION

NEXT_DRBL_NEW_MOVE_SCHEDULE

NEXT_DRBL_CURR_CARRIER

NEXT_DRBL_CURR_CARRIER_CLASS

NEXT_DRBL_CURR_CARR_ASGN_TOOL

NEXT_DRBL_CURR_LOCATION

NEXT_DRBL_CURR_STATION

NEXT_DRBL_CURR_STATION_TYPE

FIRST_DISP_INST

DRBL_FIRST_DISP_INST

POD_FIRST_DISP_INST

SCHED_KIT_INST

SCHED_LOTS