FPSBASE.DASH_P_TOOL_WIP_NEXT_30D

Data Dictionary

>

FPSBASE Tables

> FPSBASE.DASH_P_TOOL_WIP_NEXT_30D

Table FPSBASE.DASH_P_TOOL_WIP_NEXT_30D"

See comments in DASH_REF_P_TOOL_WIP_NEXT_30D view.

Schema: FPSBASE
Tablespace: FPSDATA
Primary key: TOOL, START_INST

Column	Type	Nullable	Comment
TOOL	VARCHAR2(16)	N	Tool is generally just the main tool. The exception is when different entities on the tool run completely independently and it is physically impossible to run wafers of the same lot across multiple entities. In this exception case, we may want to assign the entities to different eqp_types and therefore we should define each entity as a tool. Please note that when we do this there is no indication whatsoever that these different entities are on the same tool. (* from FPSINPUT.EQP_TOOLS)
START_INST	DATE	N	Time when the lot started. (* from FPSINPUT.WIP_STARTS)
BG_COLOR	VARCHAR2(24)		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)
END_INST	DATE		The time the even is scheduled to end (* from FPSINPUT.EQP_SCHED_EVENTS_MANUAL)
QTY_COMP_PER_SHIFT	NUMBER
QTY_ENDWIP_AVG_TOOL	NUMBER
QTY_ENDWIP_AVG_TOTAL	NUMBER
QTY_ENDWIP_STDDEV_TOOL	NUMBER
QTY_ENDWIP_STDDEV_TOTAL	NUMBER
QTY_FUT_AVG_TOOL	NUMBER
QTY_FUT_AVG_TOTAL	NUMBER
QTY_FUT_NOW	NUMBER
QTY_FUT_STDDEV_TOOL	NUMBER
QTY_FUT_STDDEV_TOTAL	NUMBER
QTY_FUT_TOOL	NUMBER
START_INST_MAX	DATE
WIP_FORECAST_HOVER_MSG	VARCHAR2(2000)