14.1 sp808_role_definition
- Billy Sewell (Unlicensed)
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 14.1 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 |