Configuring Siebel eBusiness Applications > Configuring Tables and Columns >

About Extension Tables

Extension tables provide additional columns that you can use to store custom attributes. Extension tables have either an implicit 1:1 or a 1:M relationship with a given base table.

Siebel Systems provides a set of preconfigured extension tables that are set aside for customer use. These tables are known as static extension tables. Static extension tables include generic columns (ATTRIB_) that you can use to store custom attributes. Static extension tables are already part of the data model, so using them does not require updating the physical database.

NOTE:  Some ATTRIB_ columns in extension tables are used by Siebel Systems. Do not modify or delete ATTRIB_ columns in use by standard Siebel applications.

You can also create your own extension tables using the New Table Wizard. Extension tables that you create are changes to the logical schema and therefore must be also be applied to the physical database.

When columns in a base table are updated, the timestamps of its extension tables are not updated unless columns in those extension tables are also updated. However, when records in an extension table are changed, system columns in a parent table are updated. This is done because the associated record in an extension table is considered by the object manager to be logically a part of its parent record.

Related Topics

About One-to-One Extension Tables

About Implicit Joins

About One-to-Many Extension Tables

Using Static 1:1 Extension Tables

Using Static 1:M Extension Tables

Creating 1:1 Extension Tables Using the Object List Editor

Creating New Tables Using the New Table Wizard