Siebel Assignment Manager Administration Guide > Working with Dynamic Candidates > Process of Defining Dynamic Candidates >

Configuring Join Specifications for Dynamic Candidate Object Definitions


As of version 7.8, Assignment Manager supports complex joins to relate base table with other related entities. The Dynamic Candidate Component object properties define the table and column names used when performing a join from the assignment object primary table to the candidate table to retrieve the dynamic candidates.

Using the dynamic candidate feature, you can configure Assignment Manager to identify related business entities and retrieve potential candidates from these entities. For example, you use the dynamic candidate feature when:

  • Assigning a position, such as Executive Sponsor, from the account team to a related child account
  • Assigning account sales representative positions to a child account's opportunity
  • Assigning an activity and you want to evaluate only employees who belong to that activity's service region, and if necessary, add more criteria for product skills, and so on.

Because potential assignees for dynamic candidates can be derived from various related business entities, you must configure the relationship between these entities.

This task is a step in Process of Defining Dynamic Candidates.

Use the following procedure to configure join specifications for dynamic candidates.

NOTE:  Before you can successfully use join specifications for creating dynamic candidate definitions, you need to have a thorough understanding of database administration and how to use Siebel Tools. You should also familiarize yourself with the basics of the underlying Siebel application architecture. For more information on these topics, see Using Siebel Tools and Deployment Planning Guide.

To configure join specifications for dynamic candidates

  1. Start Siebel Tools.
  2. In the Object Explorer, expand Workflow Policy Object, and in the Workflow Policy Objects window, select the object you want to configure.

    TIP:   If Workflow Policy Object is not visible in the Object Explorer, you can enable it in the Development Tools Options dialog box (View > Options > Object Explorer).

  3. Lock the project for the object by choosing Tools > Lock Project (or Alt+L).

    The pencil icon appears in the W field to indicate the project for the object is locked.

  4. In the Object Explorer, expand Assignment Object, and then expand Dynamic Candidate.
  5. Expand the Dynamic Candidate object further, and then select Dynamic Candidate Component.
  6. In the Dynamic Candidate Component window, choose Edit > New Record.
  7. In the new record, enter values for the relevant information.

Table 40 provides descriptions of some of the Dynamic Candidate Component properties.

Table 40. Dynamic Candidate Component Object Properties
Property
Description

Additional Join Spec

Use this property to specify an additional join.

Candidate Id Column

The column in the Team table containing the Id of the candidate (employee, position, or organization).

Candidate Table

The name of the source table at the last level of a join.

NOTE:  Before version 7.8, this property was called Team Table.

Inactive

Indicates if the component is active or inactive.

Name

The name of the dynamic candidate component.

Primary

When checked, indicates whether the dynamic candidate component is the primary for the dynamic candidate selected for the assignment object.

Score Column

The column in the Team table containing scores of the candidates.

Source Column Name

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

Source Table Name

The table that the dynamic candidate component is based on.

Target Column Name

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

Target Component Name

The target dynamic candidate component that is related to this dynamic candidate component.

NOTE:  Each dynamic candidate specified can have only one primary dynamic candidate component.

Siebel Assignment Manager Administration Guide