sp130_gantt_timescales
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
2 min read
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. |