Data Dictionary
>
FPSAPP Tables
> FPSAPP.ETP_L6_OBSOLETE_STATES
Table FPSAPP.ETP_L6_OBSOLETE_STATES"
This table stores old ETP states which are no longer used but may be in ETP_HIST and the various ETP_TOOL/ENTITY_SHIFT/WEEK_HIST tables.
-
Schema: FPSAPP
-
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 |