This table contains the timescales which have been defined by the system administrator. A timescale is used by the Gantt client to minimise the amount of off-shift time displayed.

If end_time is less than start_time then the periods the Gantt displays are over midnight and start on the days specified. For example, if start time is 20:00 (1200 minutes), end time is 10:00 (600 minutes) and the days shown are Saturday and Sunday. Then the times displayed will be Sat 20:00 to Sun 10:00 and Sun 20:00 to Mon 10:00.

By default 4 timescales are set up called '24 hour', 'Day', 'Night' and 'Weekend'.

Table Definition

Field	Type	Default	Nullable
timescale_name	varchar2(30)
display_sequence	number(2)
start_time	number(4)
end_time	number(4)
show_monday	number(1)
show_tuesday	number(1)
show_wednesday	number(1)
show_thursday	number(1)
show_friday	number(1)
show_saturday	number(1)
show_sunday	number(1)
field_id	varchar2(100)

Keys

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

Column Descriptions

Field	Description
timescale_name	Depreciated - The name of the pattern - this text is used on the Gantt display.
display_sequence	A number used to order the sequence in which timescales are listed on the Gantt
start_time	The time of day at which the display period starts. This is expressed as a number of minutes since the start of the day and is in the range 0 to 1440. (00:00 to 24:00)
end_time	The time of day at which the display period ends. This is expressed as a number of minutes since the start of the day and is in the range 0 to 1440 (00:00 to 24:00)
show_monday	A value of 1 indicates that the day is included in the timescale. A value of 0 indicates it is not.
show_tuesday	A value of 1 indicates that the day is included in the timescale. A value of 0 indicates it is not.
show_wednesday	A value of 1 indicates that the day is included in the timescale. A value of 0 indicates it is not.
show_thursday	A value of 1 indicates that the day is included in the timescale. A value of 0 indicates it is not.
show_friday	A value of 1 indicates that the day is included in the timescale. A value of 0 indicates it is not.
show_saturday	A value of 1 indicates that the day is included in the timescale. A value of 0 indicates it is not.
show_sunday	A value of 1 indicates that the day is included in the timescale. A value of 0 indicates it is not.
field_id	Key to language translations for timescale_name.

Browser not supported