Join Spec (O)

Specifies a join between this workflow policy component and the target workflow policy component.

If the existing join references an intersection table that would result in Siebel CRM returning multiple rows, then you specify the Join Spec property. The join that the Join Spec property references restricts the join so that Siebel CRM returns only one row at a time. The expression that the Join Spec property contains is equivalent to an additional WHERE clause in SQL. It uses the following format:

workflow_component.foreign_key = business_component.primary_key

For example, the following join specification occurs in the Primary Opportunity/Position workflow policy component in the Opportunity workflow process:

[Primary Opportunity/Position].OPTY_ID = [Opportunity].ROW_ID

You must enclose the component name with square brackets.

Name (R)

Specifies the name of this workflow policy component.

Primary (O)

If TRUE, then this workflow policy component is the primary workflow policy component for the parent workflow policy object. Each workflow policy object must include one and only one primary workflow policy component.

For example, the Primary property of the Account workflow policy component of the predefined Account workflow policy object is TRUE. This configuration defines the Account workflow policy component as the primary. Other workflow policy components in the Account workflow policy object are not primary workflow policy components.

Source Column Name (O)

Specifies the column in the source table that another workflow policy component references. The drop-down list for this property displays columns from the table that the Source Table Name property specifies.

Source Table Name (R)

Specifies the table that this workflow policy component references.

Target Column Name (O)

Specifies the column in the target workflow policy component that Siebel CRM joins to the source column in this workflow policy component. The drop-down list for this property displays columns of the table that the target workflow policy component specifies.

Target Component Name (O)

Specifies the target workflow policy component. The drop-down list for this property displays a list of workflow policy components for the current workflow policy object.