Configuring Siebel eBusiness Applications > Configuring Tables and Columns >

Creating 1:1 Extension Tables Using the Object List Editor

In cases where standard extension tables and columns are not available, you can create custom 1:1 extension tables.

When creating custom 1:1 extension tables, consider the following:

• Review Guidelines for Extending the Data Model.
• If you need to extend tables whose type is Extension or Extension (Siebel), you must extend from from the table's base table, not from the extension table itself. The Base Table property of the extension table will tell you which base table to extend. For example, S_CONTACT is an extension table of S_PARTY. Because S_CONTACT is of the type Extension (Siebel), you cannot use it as a parent table for an extension table. Instead, extend S_PARTY and use a join (implicit join) to display the data from the extension table.
• Custom 1:1 extension tables do not need new docking rules, as the data contained in these tables is implicitly routed according to the docking rules of their parent tables.

To create a custom 1:1 extension table

1. Connect to your local development database with Siebel Tools.
2. In the Object Explorer, select the Table object type.
3. In the Object List Editor, select the base table for which you want to create an extension table. Verify that its Type property has a value of Data (Public).
4. Click Extend.

   The extension table appears in the list of tables in the Object List Editor. The Database Extension Designer automatically creates the necessary standard columns and standard indexes. Temporary columns in interface tables that are imported to the base table for this extension table are also created automatically.

5. Create any additional extension columns on the custom extension table, following the instructions in Adding Extension Columns to Base Tables.