How Siebel CRM Creates a Join

The following figure describes how How Siebel CRM creates a a join.

Explanation of Callouts

As shown in this figure, Siebel CRM uses the following objects to create a join:

1. Business component. The business component is the parent of the join. Because of the join, a field in the business component that Siebel CRM joins can represent a column from the joined table.

2. Joined field. A joined field is a business component field that represents a column from a table other than the base table of the business component. For more information, see How Siebel CRM Uses a Joined Field.

3. Join. A join is a child of the business component. The join uniquely identifies a join relationship for the parent business component and provides the name of the joined table. The Table property of the join identifies the joined table. The join includes a child join constraint, which is an object that contains a constant value search specification that Siebel CRM applies to a column during a join. Siebel CRM uses it with an outer join. For more information, see Options to Filter Data That Siebel CRM Displays in an Applet.

   If Siebel CRM must get all records in the business component even if the joined fields are empty, then you must make sure the Outer Join Flag property contains a check mark.

4. Join Specification. The join specification is a child of the join. It identifies the foreign key field in the business component and the primary key column in the joined table. For more information, see How Siebel CRM Uses the Join Specification.

5. Foreign key field and foreign key column. The Source Field property of the join specification identifies the foreign key field. It represents a foreign key column that resides in the base table and it references the rows in the table that Siebel CRM uses in a join. For example, the foreign key field to the join on accounts data in the Contact business component is the Account Id field. This Account Id field references the PR_DEPT_OU_ID column in the base table.

6. Joined table. The joined table is the parent table in the parent-child relationship. It provides columns to the business component through the join. The Table property of the join identifies the joined table.

7. Primary key column. The Destination Column property of the join specification identifies the primary key column in the joined table. Each table in Siebel CRM includes a ROW_ID column that uniquely identifies the rows that the table contains. ROW_ID is the destination in most joins.

8. Mapped column. Columns in the joined table are available for use in fields in the business component.