FPSINPUT.RTG_REF_RANKS | inficon-demo

Data Dictionary

FPSINPUT Views

> FPSINPUT.WIP_WAFER_HIST_LOOP

View FPSBASE.RTG_REF_RANKS

A simple view to combine current and permanent ranks which separated so that we can set foreign key on RTG_PERM_RANKS. The rank_sort is used for two different purposes which are critical. First is to determine the curr_rank of a particular lot on a particular tool. For this, we want the "worst" rank so the highest rank_sort is used. For example, if the tool is down (sort 12) and is inhibited (sort 33) and requires a setup (sort 5) then the rank is I for inhibited since that is the worst option as determined by the highest rank_sort. Second is to determine which tool is the best for the lot. For this, the lowest rank_sort is used. For example, if tool T1 is down (sort 12) and tool T2 is inhibited (sort 33) and tool T3 requires a setup (sort 5) then the "best" tool is T3 as determined by the lowest rank_sort. Since we agree that lots which are both DOWN and BLOCK should have the process state of BLOCK, we must ensure that all ranks where process_state is BLOCK have a higher rank_sort than ranks R and D where process state is DOWN. Similarly all ranks where process state is WAIT should have a lower rank_sort than R and D. We set the rank_sort for all ranks in FPSADMIN tables so we have full control over this in our DWH and are not dependent on FPSINPUT.

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
PROC_STATE_IF_WAIT
SHOW_NEAR_FAR_IN_ETP	If this flag is set to Y then we will set the standby state for lots of this rank to either NEAR or FAR based on location rather than the normal RANKx. By default, this is only set for P and A but it is allowed for any rank where use_in_sched = Y and proc_state_if_wait = WAIT. (* inherited from FPSADMIN.RTG_PERM_RANKS)
SOURCE_TABLE
SBY_TRANSITION_STATE	The transition state for the standby and missed cascade states associated with this rank will be SBY/PRD-CSC followed by this suffix. (* inherited from FPSADMIN.RTG_PERM_RANKS)
SBY_OR_CSC_DISPLAY_SUFFIX	The ETP_STATE_DISPLAY for the standby and missed cascade states associated with this rank will be Standby/Missed Cascade followed by this suffix. (* inherited from FPSADMIN.RTG_PERM_RANKS)
SBY_OR_CSC_SHORT_DISP_SUFFIX
OVR_SBY_STATE_LONG_DESC	Normally the long description for the standby and missed cascade states associated with this rank are automatically generated using description but this field allows override. (* inherited from FPSADMIN.RTG_PERM_RANKS)
OVR_SBY_STATE_TECH_DETAILS	Normally the technical details for the standby and missed cascade states associated with this rank are automatically generated but this field allows override. (* inherited from FPSADMIN.RTG_PERM_RANKS)
OVR_ETP_STATE_BG_COLOR	This column feeds to the ETP_STATE_DIAGRAM to allow chosen SBY-RANK{rank} background colors to be overridden for displays on the Dashboard and other applications. SBY ETP_STATES for these ranks are automatically built, so overriding them in L6_DETAILED states is not possible. (* inherited from FPSADMIN.RTG_AUTO_RANKS)