FPSBASE.EQP_PORT_MODES

Data Dictionary

>

FPSBASE Tables

> FPSBASE.EQP_PORT_MODES

Table FPSBASE.EQP_PORT_MODES"

List of allowed port modes for the facility and whether each is considered auto.

Schema: FPSBASE
Tablespace: FPSDATA
Primary key: PORT_MODE
Foreign keys: EQP_PORT_MODES_FK_BG_COLOR: PORT_MODE_GROUP_BG_COLOR REFERENCES FPSADMIN.GEN_COLORS (COLOR)

Column	Type	Nullable	Comment
PORT_MODE	VARCHAR2(24)	N	PORT_MODE is the port equivalent to EQP_STATE. Examples might be AUTOMATIC, MANUAL, SEMI-AUTOMATIC, or DOWN. If configured in GEN_FACILITIES, the view DASH_P_TOOL_PORTS can overlay whether the port is occupied along with its carrier and the WIP processing states over the port modes as long as the port mode has is_up set to Y. Therefore it is not necessary to reflect occupied or empty when developing the ETL logic to populate the EQP_PORTS table.
IS_AUTO	CHAR(1)	N	This field shows if the port mode is set to automatically deliver material. If the facility either has automated delivery (aka 300mm) or is using semi-automated delivery (aka NextMove) then a port set to a port_mode where this is N but is_up is Y is considered manual. A manual port means that the delivery system cannot use this port. If all ports are manual then rank will be M (Ports Manual) and ETP will set the state to SBY-RANKM (Standby With All Ports in Manual). In addition, we report auto_pct by summarizing the port states in auto and manual.
IS_UP	CHAR(1)	N	This field shows if the port mode of the stations is considered up or down. If all ports are down then rank will be R (Ports Down) and ETP will set the state to SBY-RANKR (Standby With All Ports Down).
PORT_MODE_DISPLAY	VARCHAR2(48)	N	The name of the port_mode displayed on all dashboards and reports. We allow a longer more descriptive name here although often this will be the same as the port_mode.
PORT_MODE_GROUP	VARCHAR2(24)	N	Grouping field of the port mode for reporting. If port modes are not particularly specific then this might be the same as the port mode.
PORT_MODE_GROUP_BG_COLOR	VARCHAR2(24)		Color assigned to the port_mode_group.
SORT_ORDER	NUMBER(4)	N	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)
UPDATED_INST	DATE		Time when the record was updated according to the source data. Note this is not the time when the record was actually updated in this table - it will almost always be earlier. (* from FPSINPUT.GEN_FACILITIES)