Document toolboxDocument toolbox

sp150_std_act_categories

Owned by Jason Andrew
Oct 02, 2024
1 min read

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_idnumber   (error)
namevarchar2(50)   (error)
field_idvarchar2(100)  (error)

Keys 

primary key (name) unique (category_id)

foreign key (field_id) references sp900_language_translation (field_id)

Primary Key Referenced From

 

Column Descriptions

FieldDescription
category_id Standard Activity category identifier.
name Name for this category (e.g. Sickness).
field_idKey to language translation in sp900 for name.