sp808_role_definition

Entries within this table define individual authorisation roles. Each role must have a name and an identifier; it can also have zero or more permissions associated with it.

Table Definition

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

Keys

primary key (role_id)
unique (name)
foreign key (field_id) references sp900_language_translation (field_id)

Primary Key Referenced From

Column Descriptions

Field	Description
role_id	Role identifier.
name	Name of this role (e.g. Service Resource, or Planner).
field_id	Key to language translations for name.

Predefined values

ROLE_ID	NAME	Comment
1	Service Resource (Subcontractor)	Can see own team and own data and full access to some own Unavailability Periods
2	Service Resource (Sole Trader)	Can only see and have full access to some own data
3	Service Resource (Permanent)	Can see own team and full access to some own data
4	Service Resource Manager (Subcontractor)	Can see own team and full access to all own data
5	Service Resource Manager (Permanent)	Can see all FRUs and full access to all data for all operatives in one FRU
6	Planner (Gantt)	Can see all FRUs and full access to one FRU
7	Planner (Team Leader)	Can see all FRUs and full access to all data for all operatives in one FRU
8	Business Data Administrator (Operations)	Full access to all user admin data
9	Business Data Administrator (Business)	Can see all FRUs and full access to all data for all operatives in one FRU plus full access to all user admin data
10	System Administrator	Full access to all system admin data