Creating a Joined Business Component Field

You can add a join to a business component, and then reference the join in a field.

To create a joined business component field

1. In Siebel Tools, in the Object Explorer, click Business Component.

2. In the Business Components list, locate the business component where you must add a join.

3. In the Object Explorer, expand the Business Component tree, and then click Join.

4. In the Joins list, add a new record, using values from the following table.

   Property	Value
   Table	Name of the joined table. For example, enter S_ADDR_ORG to access address data.
   Alias	Name of the join. For example: Contact - S_ADDR_ORG It is recommended that you define the alias so that it is different from the table.
   Outer Join Flag	If you must get all the records in the business component even if the joined fields are empty, then set Outer Join Flag to TRUE.
   Comments	Optional.

5. In the Object Explorer, expand the Join tree, and then click Join Specification.

6. In the Join Specifications list, add a new record, using values from the following table.

   Property	Value
   Name	Name of the join specification. For example, Primary Address Id.
   Destination Column	Primary key column in the joined table. For example, ROW_ID. If you create a join on a column other than ROW_ID, then you must enter a value in the Destination Column property. An empty value in the Destination Column property indicates that the destination column is ROW_ID, which is typically the primary key. For a join to a party table, the destination column must reference the PAR_ROW_ID column in the joined table.
   Source Field	Foreign key field in the business component. For example, Primary Address Id. If empty, then the Source Field references the Id field, which indicates a one-to-one relationship between the business component and the joined table.

7. Optional. Add a Join Constraint:

   1. In the Object Explorer, expand the Join Specification tree, and then click Join Constraint.

   2. In the Join Constraints list, add a new record, using values from the following table.

      Property	Value
      Name	Name of the join constraint. For example, Primary Address Id.
      Destination Column	Column in the joined table where you must apply a search specification. For example, OU_ID.
      Value	The search specification. For example: GetProfileAttr("Primary Address Id") For more information, see Options to Filter Data That Siebel CRM Displays in an Applet.

8. In the Object Explorer, click the Field object type in the Business Component tree.

9. In the Fields list, add a new record, using values from the following table.

   Property	Value
   Name	Name of the joined field.
   Join	Join alias for the table where this field gets data. For example, Primary Account Address.
   Column	Column in the joined table where this join gets data. For example, ADDR_NAME.
   Text Length	Same length as the column where this join gets data.
   Type	Data type that is compatible with the column where this join gets data. For example, DTYPE_TEXT for a Varchar column.

10. Compile and test your modifications.

    For more information, see Using Siebel Tools.