Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.DASH_G_GANTT_LEGEND_ITEMS
Table FPSINPUT.DASH_G_GANTT_LEGEND_ITEMS"
Table to configure the colors for each additional display values for the Gantt charts. It is possible that different sites might use different colors.
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: ITEM_DISPLAY
-
Foreign keys: DASH_G_GANTT_L_BG_COLOR_FK: BG_COLOR REFERENCES FPSADMIN.GEN_COLORS (COLOR)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
ITEM_DISPLAY |
VARCHAR2(27) |
N |
|
|
BG_COLOR |
VARCHAR2(24) |
N |
Background color assigned. BG_COLOR is in English like red or blue or light green and we look up the HTML color like #FF0000 in the GEN_COLORS table. BG_COLOR must be set manually but the FPSADMIN view BLD_POPULATE_COLORS will generate queries to randomly set bg_color for all values in a table. (* from FPSINPUT.GEN_CUSTOMERS) |
|
ITEM_HOVER_MSG |
VARCHAR2(63) |