sp120_scale_factors
This table defines the scale factors that can be used to scale the Gantt display.
Â
Table Definition
Field | Type | Default | Nullable |
---|---|---|---|
scale_name | Â varchar2(20) | Â | Â |
 scale_numerator |  number(2) |  |  |
scale_denominator | number(2) | Â | Â |
display_sequence | number(2) | Â | Â |
field_id | varchar2(100) | Â | Â |
KeysÂ
primary key (scale_name)Â
foreign key (field_id) references sp900_language_translation (field_id)
Column Descriptions
Field | Description |
---|---|
scale_name | Depreciated - Name of scale as displayed on the Gantt's Scale Factor menu. |
scale_numerator | See scale_denominator. |
scale_denominator | Together with scale_numerator, defines the scale as the ratio of the number of operative days per screen. E.g. scale_numerator = 3; scale_denominator = 1 gives 3 operative days per screen. E.g. scale_numerator = 1; scale_denominator = 2 gives ½ an operative day per screen. |
display_sequence | A number used to order the sequence in which scale factors are listed on the Gantt. |
Field_id | Key to language translations for scale_name. |