Bookshelf v8.0: Properties of a Table Column

Configuring Siebel Business Applications > Reference Materials for Configuring Siebel Business Application > Properties of Object Types >

Properties of a Table Column

Table 81 describes properties that Siebel CRM commonly uses with a table column.

Table 81. Properties That Siebel CRM Commonly Uses with a Table Column
Property	Description
Default	Stores a default value when Siebel CRM adds new table rows.
Foreign Key Table	Stores the table to which this column is a foreign key. Siebel Enterprise Integration Manager (EIM) uses this information. For more information, see Mapping a Custom Table to an Interface Table.
LOV Bounded	Stores import behavior for EIM. If LOV Bounded is TRUE, then, during import, EIM checks the values against the values contained in a list defined in the LOV Type property. In that situation, LOV data must be imported first into the S_LST_OF_VAL table, and the LOV Type property must be defined. This property is read-only for a predefined column in Siebel CRM but you can edit it for a custom extension column.
LOV Type	Stores the list of values domain in which the Siebel schema validates this column. Siebel CRM uses it in conjunction with the LOV Bounded property. You define a list of values domain in the Administration - Data screen, List of Values view in the Siebel client. This property is read-only for a predefined column in Siebel CRM but you can edit it for a custom extension column.
Name	Stores the name of the database column in the database table.
Nullable	Indicates if the Siebel database can or cannot store NULL in this column. If TRUE, then Siebel CRM can store NULL.
Physical Type	For more information, see Physical Type Property of a Table Column.
Precision	Stores the maximum number of digits in a number column. For a noninteger column, the precision is 22. For an integer column, the precision is 10.
Primary Key	Stores the primary key for the table. If TRUE, then this column is the primary key for the table. With minor exceptions, the ROW_ID column in a table is the primary key, and it contains a TRUE value for this property.
Scale	Stores the maximum number of digits after the decimal point. For a noninteger column, the scale is 7. For an integer column, the scale is 0.
Type	For more information, see Type Property of a Table Column.
User Key Sequence	Stores the sequence in the user key where this column fits.

Physical Type Property of a Table Column

Table 82 describes the physical types that Siebel CRM supports. The Physical Type property identifies the physical type of the column in the Siebel database.

Table 82. Physical Types That Siebel CRM Supports in the Physical Type Property of a Table Column
Physical Type	Description
Character	Stores text that is fixed in length. Also used for a Boolean column, which is a character column that contains a length of 1. By default, you cannot use Char greater than 1. To change the default setting in Siebel Tools, you can choose the View menu, Options, and then click the Database tab. Make sure the following option contains a check mark: Allow to create column of type 'Character' being greater than 1 NOTE: If you define a Column as a Char column, and if the data that Siebel CRM stores in the column varies in length, then Siebel CRM pads the data with empty spaces in the Siebel database. It is recommend that you use the Varchar data type for all but Boolean columns that are defined as CHAR(1).
Character Large Object (CLOB)	For more information, see Character Large Object (CLOB) Physical Type.
Date	Stores the date only, without time.
Date Time	Stores combined date and time in the same column.
Long	Stores long text. You can store approximately 16 KB of data in a Long column.
Number	Stores any numeric data. Typical numeric columns in Siebel CRM are 22,7 for general-purpose numbers, and 10,0 for integers. For more information, see Maximum Number of Digits for a Numeric Physical Type.
Time	Stores time only, without the date.
UTC Date Time	Stores the date and time. Siebel CRM saves time in Greenwich Mean Time (GMT).
Varchar	Stores text that varies in length. Used for most alphanumeric columns in the data objects layer, including ROW_ID, foreign key, list of values, and other free form text columns.

Character Large Object (CLOB) Physical Type

The Character Large Object (CLOB) physical type stores a large, variable amount of text. Siebel CRM version 8.0 and higher supports this text. CLOB is similar to Long, but it can contain much more data. In an Oracle database, the maximum size is (4 GB minus 1 byte) multiplied by the value in DB_BLOCK_SIZE.

Note the following requirements:

Because a column in a Siebel table is limited to 128 KB of data, you cannot define a column of type CLOB that is greater than 128 KB.
Siebel CRM allows no more than three CLOB columns for each table.
In Siebel Tools, you can only set the physical type to CLOB when you define a column. You cannot change a predefined column, such as a Long column, to a CLOB column.
Siebel Tools displays the CLOB Physical Type as L (Long) in the Properties window.
Because MS SQL Server does not define a CLOB type, MS SQL Server treats a CLOB as a varchar(max) or nvarchar(max) object.
To query on a DTYPE_CLOB field, you must use at least one wildcard in the search expression. You use an asterisk (*) to express a wildcard. For example, use TEST*. Do not use an equal sign (=) in the query. For example, do not use =TEST. If you use an equal sign, then Siebel CRM generates an error.

Maximum Number of Digits for a Numeric Physical Type

If the Physical Type property of a table column is Numeric, then the table column can contain up to 16 digits. Note the following for the numeric physical type:

As Siebel CRM increases the number of digits it uses to the left of the decimal point, the number of usable digits to the right of the decimal point decreases by an equal amount.
Data is limited to 16 digits without a decimal point.
If you use a decimal point, then data is limited to 15 digits to the left of the decimal point.
You cannot use more than 7 digits to the right of the decimal point.
You cannot change precision or scale properties to change this support.
Some rounding errors can occur with a 16 or 15 digit number.

Type Property of a Table Column

The type property specifies the type of column. Siebel CRM commonly uses the following values for the Type property of a table column:

Data. For more information, see Data Columns of a Siebel Table.
Extension. For more information, see Extension Columns of a Siebel Table.
System. For more information, see System Columns of a Siebel Table.
IFMGR. Occurs in an interface table. The Siebel Enterprise Integration Manager uses it internally. The name of an IFMGR type follows the IFMGR:nn format. For example, IFMGR:ROW_ID.

Table 83 describes possible values for the Type property of a Siebel table.

Table 83. Values for the Type Property of a Siebel Table
Type	Description
Data (Public)	Contains data that Siebel CRM makes available through business components. To customize a public data table, you can use an extension table and extension column. It is among the predefined set of tables.
Data (Private)	Similar to a public data table, except it cannot contain an extension column.
Data (Intersection)	Defines a many-to-many relationship between two data tables.
Extension	Provides more columns that you can use to store data. Contains an implicit one-to-one relationship to the parent base table, which is the table that an extension table logically extends. A table with an implicit one-to-many relationship to a base table is also known as an extension table. However, the Type property for this type of table is Data (Public), and not Extension.
Interface	Siebel Enterprise Integration Manager (EIM) uses the Interface type to enter values in one or more base tables and subsequently to perform periodic batch updates between Siebel CRM and other enterprise applications. The suffix in the name of an interface table is _IF or _XMIF.
Database View	Reserved for Oracle internal use.
Dictionary	Reserved for Oracle internal use.
Journal	Reserved for Oracle internal use.
Log	Reserved for Oracle internal use.
Repository	Reserved for Oracle internal use.
Virtual Table	Reserved for Oracle internal use.
Warehouse Types	Reserved for Oracle internal use.
Extension (Siebel)	Reserved for Oracle internal use. An Extension (Siebel) table is usually an extension of the S_PARTY table.

Configuring Siebel Business Applications		Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.