FPSAPP.RTG_PERM_RANKS

RANK

VARCHAR2(1)

N

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.

DESCRIPTION

VARCHAR2(256)

Tool desciption. This value is only used to display in the Dashboard. (* from FPSINPUT.EQP_TOOLS)

OLD_SBY_STATE

VARCHAR2(9)

N

OVR_ETP_STATE_BG_COLOR

VARCHAR2(24)

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. (* from FPSADMIN.RTG_AUTO_RANKS)

OVR_SBY_STATE_LONG_DESC

VARCHAR2(1000)

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.

OVR_SBY_STATE_TECH_DETAILS

VARCHAR2(1000)

Normally the technical details for the standby and missed cascade states associated with this rank are automatically generated but this field allows override.

PROC_STATE_IF_WAIT

VARCHAR2(5)

N

RANK_DISPLAY

VARCHAR2(24)

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.

RANK_SORT

NUMBER(3)

N

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.

SBY_OR_CSC_DISPLAY_SUFFIX

VARCHAR2(33)

N

The ETP_STATE_DISPLAY for the standby and missed cascade states associated with this rank will be Standby/Missed Cascade followed by this suffix.

SBY_OR_CSC_SHORT_DISP_SUFFIX

VARCHAR2(7)

N

SBY_TRANSITION_STATE

VARCHAR2(48)

N

The transition state for the standby and missed cascade states associated with this rank will be SBY/PRD-CSC followed by this suffix.

SHOW_NEAR_FAR_IN_ETP

CHAR(1)

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.