Attribute Name |
Attribute Definition |
Logical Datatype |
Is Required |
Configuration Setting Value Id |
The automatically generated primary key of the cfg_setting_val table. |
LONG |
Yes |
Configuration Setting Id |
A Foreign Key to the Configuration Setting table. |
LONG |
Yes |
Owner Id |
A Foreign Key to the Owning instance in either the Definition, Definition Version , Role, or User Profile tables. |
LONG |
Yes |
Value Type Code |
The data type for a Configuration Setting Value. The choices are 'S' string, 'D' date, 'T' text, 'I' integer.
|
CHAR(1) |
Yes |
Configuration Setting Owner Type Name |
The unique string identifier for an instance of Configuration Setting Owner Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table.
|
VARCHAR(255) |
Yes |
String Value |
The value of a Configuration Setting Value, stored as a string. |
VARCHAR(255) |
No |
Text Value |
The value of a Configuration Setting Value, stored as a long text object. |
TEXT |
No |
Date Value |
The value of a Configuration Setting Value, stored as a date. |
DATE |
No |
Real Value |
The value of a Configuration Setting Value stored as a real. |
DECIMAL(,) |
No |
Int Value |
The value of a Configuration Setting Value stored as Int. |
INTEGER |
No |
Long Value |
The value of a Configuration Setting Value stored as Long. |
LONG |
No |
Boolean Value |
The value of a Configuration Setting Value stored as Boolean. |
BOOLEAN |
No |
Application Role Id |
A Foreign Key to the Application Role table. |
LONG |
No |
Value Map Key |
The value of a Configuration Setting Value, stored as a string. |
VARCHAR(255) |
No |