Summary of Support for Extension Tables and Extension Columns

The following table summarizes support for extension tables and extension columns.

Object	Description
Public data table	Can be extended by using an extension table and extension columns.
Private data table	The following support is available for the private data table: Cannot contain an extension column Cannot add an extension column to a private data table A private data table is a table with the Type property set to Data (Private). Some interface tables are private, but most are public.
Intersection table	The following support is available for an intersection table: Can be extended with an extension column Cannot be extended with a custom extension table
LOV Bounded, LOV Type property of a table column	Read-only for a predefined column in Siebel CRM but is editable for a custom extension column. MLOV (multilingual list of values) is allowed with a custom extension column.
Predefined one-to-one extension column	It is recommended that you do not modify or delete a predefined one-to-one extension column.
Predefined extension column	Similar to a data column in a base table, you must not modify or delete a predefined extension column that a predefined Siebel application uses.
Custom extension column	The following support is available for a custom extension column: You can use the Database Designer to add a custom extension column to a base table. The Database Designer is available in the Tables list in Siebel Tools. The relational database that you use with Siebel CRM determines if you can or cannot create a custom extension column on a base table. You can add a custom extension column to one of several types of tables. For more information, see Adding an Extension Column to a Base Table.
Custom extension table	The following is available for a custom extension table: You can use the Database Designer to create a new one-to-one extension table. Several types of custom extension tables are available. For more information, see the table in Options to Use a Predefined One-to-One Extension Table.
EIM mapping	The following support is available for Enterprise Integration Manager (EIM) mapping: The EIM Table Mapping Wizard allows you to create or associate a new table with an interface table that uses EIM: You can create EIM Table Mapping objects to import data to a table that you define. You can automate the creation of an EIM attribute map on an extension column that Siebel CRM adds to a base table. You cannot add an EIM mapping for a foreign key relationship to a table that does not contain a user key. For more information, see Mapping a Custom Table to an Interface Table.
Custom extension to a dock object	The Dock Object Mapping Wizard allows you to associate a new table with a predefined or a new custom dock object. This support allows Siebel CRM to synchronize data that resides in the dock object of a Remote user.