14.1 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)

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

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.