FPSINPUT.ETP_L4_OPPORTUNITY_STATES

Data Dictionary

FPSINPUT Tables

> FPSINPUT.ETP_L4_OPPORTUNITY_STATES

Table FPSINPUT.ETP_L4_OPPORTUNITY_STATES"

Level 4 is FPS Enhanced Tool Performance opportunity states. This level is critical because opportunity state is the default grouping on all Tool Performance charts and determines the color on all views including Dashboard and Gantt charts. This table is slightly different from other FPSADMIN tables in that we do allow sites to make minor modifications to this table, for example adding a new opportunity state SBY-WIPFAR and assigned transition_state Standby With WIP Faraway to this opportunity state so we can give it a different color. Both check and referential constraints are in place to ensure that any changes do not break anything.

Schema: FPSINPUT
Tablespace: FPSDATA
Primary key: OPPORTUNITY_STATE
Referenced by: FPSINPUT.EQP_L5_TRANSITION_STATES (OPPORTUNITY_STATE)

Column	Type	Nullable	Comment
OPPORTUNITY_STATE	VARCHAR2(12)	N	FPS Enhanced Tool Performance group assigned to each transition_state and to each etp_family. This assignment determines the default grouping on all Tool Performance charts and determines the color on all views including Dashboard and Gantt charts. (* from FPSINPUT.EQP_L5_TRANSITION_STATES)
BG_COLOR	VARCHAR2(24)	N	Background color assigned. BG_COLOR is in English like red or blue or light green and we look up the HTML color like #FF0000 in the GEN_COLORS table. BG_COLOR must be set manually but the FPSADMIN view BLD_POPULATE_COLORS will generate queries to randomly set bg_color for all values in a table. (* from FPSINPUT.GEN_CUSTOMERS)
E10_STATE	VARCHAR2(3)	N
EST_CH_SORT	NUMBER(2)	N
INCLUDE_IN_DASH_DOWN	CHAR(1)		This column will hide tools from the Down tools section of the Equipment Dashboard if set to N for this opportunity state
IS_ALLOWED_MNT_FUT_ANY	CHAR(1)
IS_ALLOWED_MNT_FUT_ONLY_ACTUAL	CHAR(1)
LONG_DESCRIPTION	VARCHAR2(1000)
OPPORTUNITY_STATE_DISPLAY	VARCHAR2(48)	N