sp105_activity_types

This table contains details of all of the different activity types. An activity is anything that can be displayed on the Gantt. This includes Standard Activities (e.g. Holiday, Sick, Training) and Job Types.

Table Definition

Field	Type	Default	Nullable
activity_type	number(2)
category	number(4)
analysis_type	varchar2(2)
description	varchar2(30)
colour	varchar2(30)
display_sequence	number(2)
sa_dispatch	number(1)
sa_subsume_breaks	number(1)
field_id	varchar2(100)

Keys

primary key (activity_type)
foreign key (category) references sp101_activity_categories (category)
foreign key (field_id) references sp900_language_translation (field_id)

Primary Key Referenced From

Column Descriptions

Field	Description
activity_type	ServiceOptimizer unique identifier
category	The category of this activity type.
analysis_type	The job analysis type (maybe redundant?)
description	Depreciated - Text describing the activity. This text is displayed on the activity bars in the Gantt chart.
colour	The colour used to display activity bars in the Gantt chart for activities of this type.
display_sequence	A number used to order the sequence in which activity types are listed in Gantt chart menus.
sa_dispatch	Field indicating that this type of standard activity is dispatchable.
sa_subsume_breaks	Field is not used at present. Added for future use .
field_id	key to language translations for description.