Configuring Siebel Business Applications > Configuring Tables > Modifying Shapes and Lines in an Entity Relationship Designer >

Configuring an Extension Table

This topic describes options to configure an extension table. It includes the following topics:

• Creating a LONG Column on an Extension Table
• Manually Creating a One-to-One Extension Table
• Modifying a Custom Extension Table or Column
• Deleting a Custom Extension Table or Column

Creating a LONG Column on an Extension Table

You can create a LONG extension column. For more information, see Guidelines for Creating a LONG Column.

To create a LONG column on an extension table

1. Locate an appropriate one-to-one extension table that corresponds to the base table that requires the LONG column.

   The S_EVT_ACT_X table is an example of a one-to-one extension table for the S_EVT_ACT table.

2. Create a column in the table.
3. Set the Physical Type property of the column to Long and the Length property 0.

   For more information, see Adding an Extension Column to a Base Table.

4. Apply the modifications to your local database.

   For more information, see Applying a Custom Table to the Local Database.

Manually Creating a One-to-One Extension Table

You can manually create a one-to-one extension table, but it is recommended that you use the New Table Wizard. For more information, see Guidelines for Creating a Custom One-to-One Extension Table and Using the New Table Wizard to Create a New Table.

To manually create a one-to-one extension table

1. In Siebel Tools, in the Object Explorer, click Table.
2. In the Tables list, locate the base table where you must create an extension table.
3. Verify that the Type property for the table contains Data (Public).
4. Click Extend.

   The Database Extension Designer creates the required predefined columns and predefined indexes, and then Siebel Tools displays the extension table in the Tables list. If necessary, the designer creates temporary columns in an interface table that Siebel Tools imports to the base table for this extension table.

5. Optional. Define more extension columns on the custom extension table.

   For more information, see Adding an Extension Column to a Base Table.

Modifying a Custom Extension Table or Column

After you create a custom extension table or column, you can only modify the properties of the table or column. You can rename a column before you apply it to the Siebel Server. After you add the column or apply it to the Siebel Server, you cannot rename the column. Instead, you must deactivate the column and create a replacement extension column.

Be careful if you modify the Physical Type property of a column. Depending on existing data that resides in the column, it might not be possible to do this modification.

Siebel CRM does not support modifying a predefined base table or the columns of a predefined base table. You must not modify the extension tables that come predefined with Siebel CRM. For more information, see How an Extension Table Stores Custom Data.

To modify a custom extension table or column

1. Open Siebel Tools.
2. In the Object Explorer, click Table.
3. Optional. Modify a custom extension column:
   1. In the Tables list, locate the table that contains the extension column you must modify.

      If you are adding a new extension table to the EIM Table Mapping list, then make sure you click Activate to create all the temporary columns that Enterprise Integration Manager (EIM) requires.

   2. In the Object Explorer, click Column.
   3. In the Columns list, locate the extension column you must modify, and then modify the properties.
4. Optional. Rename a custom extension column:
   1. In the Tables list, locate the table you must modify, and then deactivate the unwanted column.
   2. In the Tables list, create a new table column.
   3. Export the data from the old column.
   4. Use ddlsync.ksh to synchronize the logical and physical schema and to import the data.
   5. Delete the column you deactivated in Step a.
5. Optional. Modify a custom extension table:
   1. In the Tables list, locate the extension table you must modify.
   2. Modify properties, as you require.

Deleting a Custom Extension Table or Column

You can delete from the logical schema a custom extension table or column that you defined. Deleting a table or column removes it from the logical schema in the Siebel repository, but it does not remove it from the physical schema of the Siebel database.

You can only delete a custom extension column or table. You cannot delete a predefined table or the columns of a predefined table.

After you delete an extension table, Siebel Tools does not delete any corresponding temporary columns in an interface table. You cannot use Siebel Tools to delete these columns. The columns will remain in the logical and physical schema.

If a column is empty at the database level, and if the column is in the Siebel repository, and if the column is in the development environment but is not in the production environment, then your database administrator can use a database tool to remove a column that you do not require. The administrator must do a full database backup before removing a column. The administrator must be careful when deleting a column because removing a column that Siebel CRM still references might require the administrator to revert to a full backup.

Using the Siebel Database Configuration Wizard to run the Synchronize Schema Definition (ddlsync) utility does not delete a column that is inactive or that was deleted from the Siebel Repository. For more information, see Siebel Database Upgrade Guide.

To delete a predefined extension column

1. In the Object Explorer, click Table.
2. In the Tables list, locate the table that contains the extension column you must delete.
3. In the Object Explorer, expand the Table tree, and then click Column.
4. In the Columns list, locate the extension column you must delete.
5. Click the Edit menu, and then click Delete.

   Siebel Tools does not cascade the deletion of an extension column. You must delete or deactivate the attribute map after you delete an extension column. To delete an attribute map, you can navigate to the Attribute Mappings list in Siebel Tools, and then delete the record.

To delete a predefined extension table

1. In the Object Explorer, click Table.
2. In the Tables list, locate the table you must delete.
3. Click the Edit menu, and then click Delete.