Configuring Siebel Business Applications > Reference Materials for Configuring Siebel Business Applications > Properties of Object Types >
Properties of a Table Column
Table 84 describes properties that Siebel CRM commonly uses with a table column.
Table 84. Properties That Siebel CRM Commonly Uses with a Table Column
|
|
Default |
Stores a default value when Siebel CRM adds new table rows. |
Foreign Key Table |
Stores the table that this column references 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 that the Siebel schema uses to validate 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 85 describes the physical types that Siebel CRM supports. The Physical Type property identifies the physical type of the column in the Siebel database.
Table 85. Physical Types That Siebel CRM Supports in the Physical Type Property of a Table Column
|
|
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. You cannot use Char greater than 1, by default. To modify the default setting in Siebel Tools, you can click 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
If you define a Column as a Char column, and if the data that Siebel CRM stores in the column varies in length, then it 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 Siebel CRM defines 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 typical 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:
- 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 modify 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.
- Microsoft SQL Server does not define a CLOB type. It 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 creates 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 modify precision or scale properties to modify 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:
Table 86 describes possible values for the Type property of a Siebel table.
Table 86. Values for the Type Property of a Siebel Table
|
|
Data (Public) |
Contains data that Siebel CRM makes available through business components. To configure 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. 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 typically an extension of the S_PARTY table. |
|