Configuring Siebel eBusiness Applications > Configuring Tables and Columns > About Extension Tables >

About Implicit Joins


Underlying a 1:1 extension table's relationship with the base table and business component is a set of hidden relationships called an implicit join (also called implied join). The implicit join makes the extension table rows available on a 1:1 basis to the business component that uses the extension table.

The name of the implicit join is the same name as the extension table. When a field in the business component is based on a column in the extension table, the Column property of the Field object is set to the name of the column, and the Join property is set to the name of the extension table. For example, the Industry field in the Contact business component has a Column property value of ATTRIB_48 and a Join property value of S_CONTACT_X.

An implicit join is different from a join that you define as an object definition.

  • Implicit joins allow data to be updated in columns, whereas joins defined as object definitions do not. Joins defined as object definitions only allow data to be displayed.
  • Implicit joins do not need to be configured. Columns in the extension table will automatically be available for you to use for business component fields.

The details of the object definition relationships in an implicit join are illustrated in Figure 12.

Figure 12.  Extension Table Details with Implicit Join
Click for full size image

The following definitions participate in the implementation of the implicit join:

  • Id field. The Id field is a system field in the business component. It represents the ROW_ID column in the base table, and it can be used in joins involving extension tables and other joined tables.
  • PAR_ROW_ID column. PAR_ROW_ID stands for parent row ID. Every extension table has this column, and every extension table row has a value there. It is used as a foreign key to the base table that is extended by the extension table.
Related Topics

Using Static 1:1 Extension Tables

About Implicit Joins

Configuring Siebel eBusiness Applications