14.1 sp150_std_act_categories

This table describes all of the available standard activity categories that are defined for use within the authorisation library. Note that this table is not set up by default but must be set up manually. If it is not set up ServiceManager will fail to work correctly.

Table Definition

Field	Type	Default	Nullable
category_id	number
name	varchar2(50)
field_id	varchar2(100)

Keys

primary key (name) unique (category_id)

foreign key (field_id) references 14.1 sp900_language_translation (field_id)

Primary Key Referenced From

14.1 sp151_std_act_cat_types

Column Descriptions

Field	Description
category_id	Standard Activity category identifier.
name	Name for this category (e.g. Sickness).
field_id	Key to language translation in sp900 for name.