Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.ETP_L6_ADDL_SBY_STATES
Table FPSINPUT.ETP_L6_ADDL_SBY_STATES"
Most standby states are set used the best rank of available WIP and that information is all in RTG_AUTO_RANKS and RTG_PERM_RANKS but these states are set later in ETP_SBY_STATE view so we need an additional table.
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: SBY_OR_CSC_STATE_SUFFIX
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
SBY_OR_CSC_STATE_SUFFIX |
VARCHAR2(5) |
N |
|
|
IS_ACTIVE |
CHAR(1) |
Flag to enable or disable the tag condition. (* from FPSBASE.MSO_TAG_CONDITIONS) |
|
|
LONG_DESCRIPTION |
VARCHAR2(1000) |
N |
|
|
OBJECT_NAME_WHERE_SET |
VARCHAR2(30) |
||
|
OVR_BG_COLOR |
VARCHAR2(24) |
This column feeds to the ETP_STATE_DIAGRAM to allow chosen L6 background colors to be overridden for displays on the Dashboard and other applications. |
|
|
RELEVANT_COLUMN_NAME |
VARCHAR2(30) |
||
|
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. (* from FPSADMIN.RTG_PERM_RANKS) |
|
SBY_OR_CSC_SHORT_DISP_SUFFIX |
VARCHAR2(7) |
N |
|
|
SBY_PRECEDENCE |
NUMBER(3) |
N |
This column fits these ranks in with RANK_SORT for the other standby states to give the overall standby precedence. This value has be unique including not matching any in RTG_RANKS. |
|
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. (* from FPSADMIN.RTG_PERM_RANKS) |