sp314_gantt_colours

This table specifies the colours to be used for the Same Site Report and the Jeopardy Report on the Gantt.

Table Definition

Field	Type	Default	Nullable
gantt_item_name	varchar2(30)
red_value	number(3)
blue_value	number(3)
green_value	number(3)
opacity	number(3)
field_id	varchar2(100)

Keys

primary key (gantt_item_name)
foreign key (field_id) references sp900_language_translation (field_id)

Column Descriptions

Field

Description

gantt_item_name

The key recognised by the Gantt client to identify the chart item to be coloured.

red_value,

blue_value,

green_value,

opacity

Define the colour that the client will render.

field_id

Key to language translations for gantt_item_name.

Preset Values

Each red/green/blue value must be in the range 0 – 255. The gantt_item_name (rows 1 to 7, named ssr<>) refers to one of the areas described in the User Guide for the Same Site Report. Rows 8 to 10 (e.g. jeopRed) refer to the colours used on the Jeopardy Report. Items 11 and 12 refer to the textual colour used within the activity bar dependent upon whether the status of the job bar is cleared or not.

By default the Jeopardy Report Colouring is disabled. To enable the feature, the system parameter gantt_jeop_amber_days must appear in the database (sp083_system_parameters) and have a value other than NULL or zero

gantt_item_name	red	green	blue	opacity
ssrPrimary1	255	255	200	255
ssrPrimary2	199	240	240	255
ssrSecondary1	255	255	150	255
ssrSecondary2	150	200	250	255
ssrSelected1	240	240	153	100
ssrSelected2	199	240	240	100
ssrSameSiteHeader	255	175	175	255
jeopRed	255	0	0	100
jeopAmber	255	0	200	100
jeopGreen	0	255	0	100
barTextDefault	0	0	0	255
barTextCleared	192	192	192	255