Additional Join Spec

Specifies an additional join.

Candidate Id Column

Specifies the column in the Team table that contains the Id of the candidate employee, position, or organization.

Candidate Table

Specifies to use the name of the source table that occurs at the last level of a join. If Candidate Table is TRUE, then the Candidate Id Column property is required.

This property was named Team Table in Siebel CRM versions prior to version 7.8.

Primary

This property can include one of the following values:

• TRUE. Siebel CRM uses the primary table for the join. The primary table is the table that contains the assignment object. For example, assume a record in the S_ORG_EXT table is marked as the primary for an account, contact, and position dynamic candidate. In this situation, Assignment Manager determines that Siebel CRM must use the S_ORG_EXT table as the first table in the join.
• FALSE. The Target Column Name property and the Target Component Name property are required.

Score Column

Specifies the column in the Team table that contains the scores of the candidates.

Source Column Name (R)

Specifies the column in the source table that relates to another dynamic candidate component.

Source Table Name (R)

Specifies the table that the dynamic candidate component references.

Target Column Name

Specifies the column in the target component that maintains a relationship with the column in the source column of the source table for this record. When Siebel CRM creates the SQL code, the inner join source table that the source column references on the source table equals the target column of the source table from the target component.

Target Component Name

Specifies the target dynamic candidate component that joins to the source table in this dynamic candidate component.