data-dictionary
data-dictionary
Breadcrumbs

FPSADMIN.DASH_REF_P_TOOL_WIP_NEXT_30D

Data Dictionary

>

FPSADMIN Views

> FPSADMIN.WIP_WAFER_HIST_LOOP

View FPSAPP.DASH_REF_P_TOOL_WIP_NEXT_30D

This view calculates the last 30 days of historical WIP by process and then compares that to the coming WIP for the next 30 days and provides a determination as to whether the coming WIP will be low, medium, or high by shift relative to last 30 days. Please note that DASH_B_H_SHIFT_SUMMARY may be configured to purge less than 30 days so if this metric is important to your site then you should increase your purge_days to 30. This will slow down the Dashboard spotlights for the Shift web version so it is important to test if this slow down is significant at your site and manage accordingly. The coming WIP is aggregated by tool and shift using tool assignments and the WIP forecast levels of burndown, high, medium, and low are calcualted dynamically based on the coming WIP data. Burndown is a special level specified if the current WIP is high enough that it's expected to take multiple shifts to return to a normal level.

Column

Comment

TOOL

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

START_INST

Time when the lot started. (* inherited from FPSINPUT.WIP_STARTS)

END_INST

The time the even is scheduled to end (* inherited from FPSINPUT.EQP_SCHED_EVENTS_MANUAL)

WIP_FORECAST_LEVEL

BG_COLOR

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