14.1 sp101_activity_categories
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table is a simple look-up table containing descriptions of the different categories of activity, viz. installation, maintenance and other.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| category | number(4) |  | |
| description | varchar2(30) | | |
| colour | varchar2(30) | 'red' | |
| field_id | varchar2(100) | |
Keys
primary key (category)
foreign key (field_id) references sp900_language_translation (field_id)
Primary Key Referenced From
Column Descriptions
| Field | Description |
|---|---|
| category | ServiceOptimizer unique identifier 0 = installations; 1 = faults; 2 = other. |
| description | Deprecated - Text describing the category |
| colour | Default colour to be used on the Gantt display for activity types of this category. |
| field_id | Key to language translations for description |