Name |
Datatype |
Comment |
Is PK |
Is FK |
cfg_setting_id |
bigint |
The automatically generated primary key of the cfg_setting table. |
Yes |
No |
cfg_setting_const |
varchar(255) |
The name of the Configuration Setting. |
No |
No |
dflt_setting_label |
varchar(255) |
The name of the Configuration Setting. |
No |
No |
dflt_setting_descr |
varchar(255) |
The description of the purpose and usage of the configuration setting. This
description serves for documentation, and will be used to help develop UI
strings for the Label, ToolTip, Helptext etc. of the UI for the configuration
setting.
|
No |
No |
cfg_ctgy_id |
bigint |
A Foreign Key to the Configuration Category table. |
No |
Yes |
val_type_cd |
char(1) |
The data type for a Configuration Setting. The choices are 'S' string, 'D'
date, 'T' text, 'L' Long, 'R' real, and 'A' for any type.
|
No |
No |
agent_only |
bit |
identifies a setting as agent use only. This prevents customer role, customer
user profile usage of the property.
|
No |
No |
unique_user_only |
bit |
identifies a setting as unique user only so it does not get used in Roles or
Agent Preference Templates. There are certain settings in that should not be
shared across individuals, and there are also the direct properties of the
former USERS table which will now be configuration settings so that they can be
used in templates and user profiles such as the Customer Auto Add Profile.
|
No |
No |
cfg_val_list_id |
bigint |
A Foreign Key to the Configuration Value List table. |
No |
Yes |
spec_class_name |
varchar(255) |
The value of a Configuration Setting, stored as a string. |
No |
No |
cfg_list_type_name |
varchar(255) |
The name of the Configuration List Type. |
No |
Yes |
cfg_is_val_mapped |
bit |
Indicates if Configuration Is Value Mapped. |
No |
No |