Siebel Object Types Reference > Siebel Object Types Reference > Workflow Policy Object Types >

Assignment Object Extension


An assignment object extension identifies the columns that Siebel CRM uses to determine the following items:

  • Candidates it adds or drops
  • Tables it uses for reporting
  • Column it uses as the key column
  • Columns it use for the position, employee, or organization

An assignment object extension contains the results tables. It does this only if Siebel CRM runs in reporting mode.

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

Table 222 describes properties that Siebel CRM uses with an assignment object extension.

Table 222. Properties of the Assignment Object Extension
Property
Description

Employee Reporting Column (O)

Specifies the name of the column in the employee reporting intersection table that references rows in the employee table.

If the Employee Table property is not empty then the Employee Reporting Column property is required.

Employee Reporting Deletion Column

Specifies the column that contains data about the employees that Siebel CRM removes from a team. This property applies only in snapshot mode or delta reporting mode.

Employee Reporting Insertion Column

Specifies the column that contains data about the employees that Siebel CRM adds to a team. This property applies only in snapshot mode or delta reporting mode.

Employee Reporting Key Column (O)

Specifies the column that contains the key values of the employees that Siebel CRM assigns to a team at runtime.

If the UseKeyValue server component parameter is TRUE, then the Employee Reporting Key Column property is required.

Employee Reporting Table (O)

Specifies the name of the employee reporting intersection table. If Siebel CRM can assign the assignment object to multiple employees, then this intersection table contains the set of employee IDs that it assigns to the assignment object IDs.

Name (R)

Specifies the name of the assignment object extension. This name must match the name of the assignment object.

Org Reporting Column (O)

Specifies the column in the organization reporting intersection table that references rows in the organization table.

If the Organization Table property is not empty, then the Org Reporting Column property is required.

Org Reporting Deletion Column

Specifies the column that Siebel CRM uses to save data about the organizations that it removes from a team. This property applies only in snapshot mode or delta reporting mode.

Org Reporting Insertion Column

Specifies the column that contains data about organizations that Siebel CRM adds to a team. This property applies only in snapshot mode or delta reporting mode.

Org Reporting Key Column (O)

Specifies the column that contains the key values of the organizations that Siebel CRM assigns to a team at runtime.

If you specify this property, then you must set the UseKeyValue server component parameter to True.

Org Reporting Table (O)

Specifies the name of the organization reporting intersection table. If Siebel CRM can assign the assignment object to multiple organizations, then this intersection table contains the set of organization IDs that it assigns to the assignment object IDs.

Position Reporting Column (O)

Specifies the column in the position reporting intersection table that references rows in the position table.

If the Position Table property is not empty, then the Position Reporting Column property is required.

Position Reporting Deletion Column

Specifies the column that identifies the positions that Siebel CRM removes from a team. This property applies only in snapshot mode or delta reporting mode.

Position Reporting Insertion Column

Specifies the column that Marks the positions that are added to the team. This property applies only in snapshot mode or delta reporting mode.

Position Reporting Key Column (O)

Specifies the column that contains the key values of the positions that Siebel CRM assigns to a team at runtime.

If you specify this property, then you must set the UseKeyValue server component parameter to True.

Position Reporting Table (O)

Specifies the name of the position reporting intersection table. If Siebel CRM can assign the assignment object to multiple positions, then this intersection table contains the set of position IDs that it assigns to the assignment object IDs.

Siebel Object Types Reference Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.