Property
|
Description/Usage
|
Valid Values/Examples
|
ASCII Only (O)
|
A TRUE or FALSE value.
|
TRUE = ASCII text is used within the columns.
The default is FALSE.
|
Alias (O)
|
Not used.
|
Not applicable.
|
Cascade Clear (O)
|
A TRUE or FALSE value that indicates to the Siebel Enterprise Integration Manager (EIM) how to handle this foreign key on delete of the related entity.
Leave FALSE for extension columns.
|
|
Default (O)
|
The value used for this column in new records.
|
|
Denormalization Path (O)
|
The path that is being denormalized if this is a denormalization column.
Applies to denormalization of user key columns into intersection tables.
|
|
EIM Processing Column Flag (O)
|
A TRUE or FALSE value.
This flag should not be used for customer data.
|
TRUE = This interface table's column is reserved for EIM processing.
FALSE = This interface table's column is not reserved for EIM processing.
|
FK Column 1:M Rel Name (O)
|
The foreign key relationship name on the 1:M side of the relationship.
|
|
FK Column M:1 Rel Name (O)
|
The foreign key relationship name on the M:1 side of the relationship.
|
|
Force Case (O)
|
Indicates the case of the letters in the column.
|
Valid values are FirstUpper, Lower, None, and Upper.
|
Foreign Key Table (Foreign Key Table Name) (O)
|
Specifies the table to which this column is a foreign key, used by EIM.
Leave NULL in extension columns.
|
|
LOV Bounded (O)
|
A TRUE or FALSE value.
If LOV Bounded is TRUE, EIM will check the values as it imports against the values contained in a list defined in LOV Type. In that case, LOV data should be imported first into S_LST_OF_VAL, and LOV Type must be specified.
This property is read-only for standard columns in Siebel applications but is editable for columns that have been added by way of the Database Extension Designer.
|
TRUE = Requires that a field based on this column be populated with a value from the list defined in LOV Type.
FALSE = There is no restriction on values entered for a field based on this column.
|
LOV Type (O)
|
Specifies the list of values domain in which this column is validated. Used in conjunction with the LOV Bounded property. List of values domains are defined in List of Values Administration in the client.
This property is read-only for standard columns in Siebel applications but is editable for columns that have been added by way of the Database Extension Designer.
|
|
Name (R)
|
Specifies the name, which must be unique within the table.
|
|
Nullable (O)
|
A TRUE or FALSE value.
|
TRUE = NULL can be stored in this column by the database.
FALSE = NULL cannot be stored in this column by the database.
|
Physical Type Name (Physical Type) (R)
|
Identifies the data type of the column in the database.
|
- Character = Fixed-length text.
- Long = Long text.
- Varchar = Variable-length text.
- Number = Any numeric data.
- Date = Date values only, without time.
- Date Time = Combined date and time values in the same column.
- Time = Time values only, without the date.
|
Precision (R)
|
The total number of digits in a number column.
For noninteger columns, the precision is 22. For integer columns, the precision is 10.
|
|
Primary Child Col (S)
|
Used by EIM. For Siebel internal use only.
|
|
Primary Child Column Name (O)
|
The name of the column that contains the primary ID value.
|
|
Primary Child Join Column Name (O)
|
The name of the child table column on which to join the base record.
|
|
Primary Child Table Name (O)
|
The name of the table from which the primary child is to be found.
|
|
Primary Inter Table Name
(Primary Inter Table) (O)
|
Used by EIM. For Siebel internal use only.
|
|
Primary Join Column Name (O)
|
The name of the column on which to join to the base record.
|
|
Primary Key (O)
|
A TRUE or FALSE value.
|
TRUE = Consider this column part of the primary key of the table.
|
Required (O)
|
A TRUE or FALSE value.
|
TRUE = The application requires this column. For example, even if the database allows NULLs, the application does not.
|
Scale (O)
|
The number of decimal digits in a number column, out of the total number of digits (precision).
For noninteger columns, the scale is 7. For integer columns, the scale is 0.
|
|
Sequence (O)
|
Represents the sequence with which the columns of a cluster index are physically stored.
Although this property is set primarily with the MSSql platform in mind, it should be applicable to all other platforms as well.
|
An integer value.
|
Sequence Object (O)
|
A TRUE or FALSE value. For Siebel internal use only.
For each table, there should be only one foreign key for the foreign key table.
|
TRUE = Indicates that a Sequence Object is specified, in which case column values are auto-generated.
Leave FALSE for extension columns.
|
Text Length (O)
|
The length in characters for Text and Varchar columns.
|
|
Translation Table Name (O)
|
The name of the translation table.
|
Values are S_LST_OF_VAL and NULL. Enables multilingual list of value functionality when set to S_LST_OF_VAL.
|
Txn Log Code (O)
|
Not used.
|
Not applicable.
|
Type (S)
|
Describes what this column is used for.
|
Values include Data (Public), Data (Private), Extension, Denormalized, and System.
|
Use FKey (S)
|
A TRUE or FALSE value.
|
TRUE = Indicates that this foreign key is to be used by synchronization in evaluating visibility. Leave FALSE in extension columns.
|
User Key Sequence (O)
|
The sequence in the user key where this column fits.
|
|
User Name (R)
|
The "user-friendly" name for the column.
|
|
Valid Condition (O)
|
The expression for validating column values.
|
|
