Document toolboxDocument toolbox

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)  (error)
 scale_numerator number(2)  (error)
scale_denominatornumber(2)  (error)
display_sequencenumber(2)  (error)
field_idvarchar2(100)  (error)

Keys 

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

Column Descriptions

FieldDescription
scale_nameDepreciated - Name of scale as displayed on the Gantt's Scale Factor menu.
scale_numeratorSee scale_denominator.
scale_denominatorTogether 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_sequenceA number used to order the sequence in which scale factors are listed on the Gantt.
Field_idKey to language translations for scale_name.