sp083_system_parameters

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 sp082_ru_setting_categories (category)
foreign key (field_id) references 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: null - general system parameter not null - optimizer parameter
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.