Options to Use a Predefined One-to-One Extension Table

Siebel CRM uses one-to-one predefined extension tables for many of the predefined data tables. The predefined extension table contains columns of various types that possess a predefined one-to-one relationship with a base table. This base table uses more columns in the extension table for new functionality without modifying the base table or database schema. For more information, see Guidelines for Modifying a Predefined One-to-One Extension Table.

A one-to-one predefined extension table does not require you to create a new business component because Siebel CRM implicitly defines this type of table as a join. For more information about implicit joins, see How an Extension Table Stores Custom Data.

A one-to-one predefined extension table includes an _X suffix, such as S_PROD_INT_X. Siebel CRM names the columns that these tables contain with ATTRIB_nn, where nn is a value from 01 to 47.

The following table lists the different data types in a Siebel extension table and the number of columns of each data type.

Data Type	Number of Columns
Number	12
Date	10
Varchar(255)	1
Varchar(100)	5
Varchar(50)	10
Varchar(30)	5
Char(1)	4