How an Implicit Join Creates a Relationship Between a Base Table and a Business Component

An implicit join is a relationship that creates a one-to-one relationship between the extension table, the base table, and the business component. It does the following:

• Creates a relationship between the following objects:

  • Between a one-to-one (_X) extension table and an intersection table.

  • Between an extension table of the S_PARTY table and the S_USER table. S_ORG_EXT, S_CONTACT, and S_POSTN are examples of these extension tables. These implicit joins map data to party business components. For example, if you add a field to the Account business component, and then choose the Join property, then Siebel Tools displays several implicit joins that it does not display in the Joins list, including joins that contain an S_ORG_EXT or S_USER alias.

• Makes the rows of the extension table available on a one-to-one basis to the business component that references the extension table.

• Is part of the Siebel object architecture. You do not use Siebel Tools to explicitly create an implicit join.

• Typically uses the table name as the Join Alias. The name of the implicit join is the same name as the extension table. If a business component field references a column in the extension table, then:

  • The Column property of the Field object contains the name of the column.

  • The Join property contains the name of the extension table.

  For example, the Column property for the Industry field in the Contact business component contains ATTRIB_48 and the Join property contains S_CONTACT_X.

• Is sometimes referred to as an implied join.

Unlike an explicit join, Siebel CRM can update the columns of an implicit join.

If you create an extension table, then Siebel Tools creates an implicit join. For more information, see How an Extension Table Stores Custom Data.

How Siebel CRM Creates an Implicit Join

The following figure illustrates how Siebel CRM creates an explicit join. As shown in this figure, Siebel CRM uses the following objects and properties to create an implicit join:

1. Empty join property. If the Join property is empty, then Siebel CRM gets the column from the base table that the business component references.

2. Column property. Identifies the table column.