14.1 sp083_system_parameters
- Billy Sewell (Unlicensed)
This table contains the names, descriptions and values of all of the various ServiceScheduling system parameters. For scheduler parameters, the actual values are held in the table sp213_scheduler_parameters (because distinct values are held for each responsibility unit).
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
name | varchar2(30) |  | |
| description | varchar2(80) | | |
| value_type | char(1) | | |
| min_value | varchar2(1024) |  | |
| max_value | varchar2(1024) | | |
| nullable | number(1) | | |
| user_editable | number(1) | | |
| value | varchar2(1024) | | |
| scheduler | number(1) | | |
| category | number(2) | | |
| display_name | varchar2(45) | | |
| display_seq | number(5) | | |
| field_id | varchar2(100) | |
Keys
primary key (name)
foreign key (category) references 14.1 sp082_ru_setting_categories (category)
foreign key (field_id) references 14.1 sp900_language_translation (field_id)
Primary Key Referenced From
Column Descriptions
| Field | Description |
|---|---|
| name | Unique identifier - the name of the parameter |
| description | Deprecated - Textual description of the parameter. |
| value_type | A character indicating the true data type of the parameter: B – Boolean ('YES' or 'NO') C - character string I - integer N - number (float) T - time D - date and time G – a group of settings displayed in ServiceManager |
| min_value | Minimum permitted value |
| max_value | Maximum permitted value |
| nullable | A flag indicating whether or not null values are allowed - 0 - not null 1 - null |
| user_editable | 1 indicates that the value may be updated by users; 0 indicates that it cannot be updated. No longer used but should be set to 1 if category is not null, otherwise 0. |
| value | The parameter value, held as a character string. Applications must convert this value to the required type. (null for scheduler parameters). |
| scheduler | indicating whether or not the parameter is relevant to the optimizer:
|
| category | The category (grouping) of settings that this setting belongs to. If category is set then the parameter will be displayed in ServiceManager under the specified category. If category is null then the parameter is not displayed in ServiceManager. |
| display_name | A descriptive name for this parameter that is longer than name but shorter than description. Used for displaying descriptive labels on ServiceManager. Should be set to space if category is set to null. |
| display_seq | Used in association with category, a numeric value which provides facilities for ordering settings on ServiceManager. |
| field_id | key to language translations for display_name. |