Join Specification

A join specification specifies the columns to join from the tables on the left side and the right side of a join.

This object type occurs in the following location in the object hierarchy:

Siebel Objects > Business Component > Join > Join Specification

The following table describes properties that Siebel CRM uses with a join specification.

Property	Description
Destination Column (O)	Specifies the name of the column in the destination table that Siebel CRM uses for the join. This name is case-sensitive. It must use the same format that it uses in the Siebel database. If the join occurs on a column other than the ROW_ID column, then the Destination Column property is required.
Name (R)	Specifies the name of the join specification object definition, which must be unique in the join. The name defaults to the Source Field value for the join specification. By default, the name of a join specification is the name of the source field specified for the object definition. You must not modify this value unless two join specification object definitions exist for the same join that use the same source field. The merge and upgrade utility uses this field to determine matching entries. For more information about the join specification, see Configuring Siebel Business Applications.
Source Field (O)	Specifies the name of a field. Siebel CRM uses this field to join the destination table. Note the following: This field resides in the parent business component of the join object definition. The Source Field property must reference a field that defines a database column. A computed field is an example of a field that does not reference a database column. You cannot use it as the source field for a join specification. This field must be a foreign key to the Destination Column. If the join occurs on a field other than the ID field, then the Source Field property is required.

Property

Description

Destination Column (O)

Specifies the name of the column in the destination table that Siebel CRM uses for the join. This name is case-sensitive. It must use the same format that it uses in the Siebel database. If the join occurs on a column other than the ROW_ID column, then the Destination Column property is required.

Name (R)

Specifies the name of the join specification object definition, which must be unique in the join. The name defaults to the Source Field value for the join specification.

By default, the name of a join specification is the name of the source field specified for the object definition. You must not modify this value unless two join specification object definitions exist for the same join that use the same source field. The merge and upgrade utility uses this field to determine matching entries.

For more information about the join specification, see Configuring Siebel Business Applications.

Source Field (O)

Specifies the name of a field. Siebel CRM uses this field to join the destination table. Note the following:

This field resides in the parent business component of the join object definition.
The Source Field property must reference a field that defines a database column. A computed field is an example of a field that does not reference a database column. You cannot use it as the source field for a join specification.
This field must be a foreign key to the Destination Column.
If the join occurs on a field other than the ID field, then the Source Field property is required.