14.1 sp130_gantt_timescales
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
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. |