Configuring Siebel eBusiness Applications > Configuring Tables and Columns >

Using Static 1:1 Extension Tables

Siebel applications provide 1:1 static extension tables for many of the standard data tables. The static extension table contains columns of various types that are set aside for your use. It has a predefined 1:1 relationship with a base table that allows you to use the additional columns in the extension table for new functionality without making alterations to the base table or modify the database schema. When using static 1:1 extension tables, you do not need to create a new business component object because these tables are already implicitly defined as joins. For more information about implicit joins, see About Extension Tables.

1:1 Static extension tables have a suffix of _X in the name, such as S_PROD_INT_X. Columns in these tables are named ATTRIB_nn, where nn is a value from 01 to 47. You can add additional extension columns if needed.

Not all columns in standard extension tables are available to use because Siebel applications use some of the columns. Extension columns used by standard Siebel applications should be treated as data columns in base tables—that is, they should not be modified or deleted.

Table 16 lists the different data types found in Siebel extension tables and the number of columns of each data type.

Before deciding to use a static extension table, you need to see if the column that you want to use in the table is already being used by standard Siebel configurations. You do this by searching the repository for fields that are associated with the column that you want to use.

CAUTION:  If the column is in use by a field defined by a Siebel application, do not deactivate the original field in order to use that column for another purpose.

To determine if standard extension columns are available

1. In the Siebel Tools Object Explorer, click the Flat tab.
2. Select the Field object type.
3. Choose Query > New Query.
4. In the Object List Editor, enter the following search criteria:
   • In the Column property, enter the name of the column you want to use.
   • In the Join property, enter the name of the extension table.

     If the query does not return any Field object definitions, the column is unused in the extension table and is available. If the query returns one or more object definitions, find another extension column in that table. To determine which extension columns are currently in use, perform the query again with the same extension table specified (in the Join property) and the value "ATTRIB*" in the Column property.