Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSAPP.DASH_P_RANKS
This view will be used primarily for the rank order when we display the tools allowed on dashboard.
|
Column |
Comment |
|---|---|
|
RANK |
Rank is a single character like P for primary or A for alternate or S for setup. The ranks defined in perm, temp, extl_rank columns in RTG_TOOL_ASSIGNMENTS tables are in RTG_PERM_RANKS. The ranks defined automatically in WIP_STEP_FUT_ASGN views are in RTG_CURR_RANKS. All ranks are defined by FPS and the specific values are used in the Scheduler therefore we must translate in the ETL to assign to the most appropriate perm_rank. (* inherited from FPSADMIN.RTG_PERM_RANKS) |
|
RANK_SORT |
This is an important field because we sort the allowed tools for a lot by the rank_sort and choose the first one as the best tool for the lot which determines the process state. Rank_sort is unique across the union of RTG_PERM_RANKS and RTG_AUTO_RANKS so that the RTG_RANKS view has a unique rank_sort. (* inherited from FPSADMIN.RTG_PERM_RANKS) |
|
RANK_DISPLAY |
The name of the rank displayed on all dashboards and reports. Rank must be a single character so we allow a longer more descriptive name here. For example Primary might be the rank_display for the rank P. (* inherited from FPSADMIN.RTG_PERM_RANKS) |
|
DESCRIPTION |
Tool desciption. This value is only used to display in the Dashboard. (* inherited from FPSINPUT.EQP_TOOLS) |
|
USE_IN_SCHED |