Data Dictionary
>
FPSADMIN Tables
> FPSADMIN.ETP_L6_DETAILED_STATES
Table FPSADMIN.ETP_L6_DETAILED_STATES"
Level 5 is FPS Enhanced Tool Performance states. ETP only modifies the eqp_state when it is PRD or SBY so we only include the etp_states to which will modify. ENG, SDT, UDT, and NST states are not included because we keep the eqp_state.
-
Schema: FPSADMIN
-
Tablespace: FPSDATA
-
Primary key: ETP_STATE
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
ETP_STATE |
VARCHAR2(48) |
N |
If entity is down then use eqp_state directly. If entity is up then determine etp_state from proc_state and sby_state. (* from FPSBASE.ETP_STATUS) |
|
ETP_STATE_DISPLAY |
VARCHAR2(48) |
N |
|
|
ETP_STATE_SHORT_DISPLAY |
VARCHAR2(12) |
N |
|
|
IS_HIST_ONLY |
CHAR(1) |
N |
|
|
LONG_DESCRIPTION |
VARCHAR2(1000) |
N |
|
|
OBJECT_NAME_WHERE_SET |
VARCHAR2(30) |
||
|
OVR_BG_COLOR |
VARCHAR2(24) |
This column defines the color used in the reports for displaying WIP qtys by ECT state. Since hold groups are an ECT state this color will be the color used in the Dashboard reports for the associated hold group. (* from FPSINPUT.WIP_HOLD_GROUPS) |
|
|
RELEVANT_COLUMN_NAME |
VARCHAR2(30) |
||
|
SORT_WITHIN_TRANSITION |
NUMBER(3) |
N |
Unique sort order within the transition_state. This is not particularly critical but the idea is that 1 is worse (i.e. closer to NST) and the highest number is best (i.e. closer to PRD). (* from FPSINPUT.EQP_L6_DETAILED_STATES) |
|
TECHNICAL_DETAILS |
VARCHAR2(1000) |
N |
Technical description of how ETP works to cause an entity to enter this L6 state. |