Setting the Name Property of a Workflow Policy Program Arg

To familiarize yourself with how Siebel CRM uses a workflow policy program argument, you can examine some of the predefined arguments. For example, in the Workflow Policy Programs list, you can query the Name property for Run External Program. This topic describes some of the workflow policy program arguments that this object references. Note the following:

  • You enter the value manually in the Name property of the workflow policy program arg.

  • If you run a database operation with Insert as the Operation Type, then you can choose a Default Value, New Row ID that provides the value for the ROW_Id field for the inserted row.

The following table describes values for workflow policy program arguments that are common to a workflow policy program.

Argument Description Value You Can Enter

Primary Id

Specifies the row ID of the violating row on which the workflow policy program runs.

Empty.

Primary Table

Specifies the base table where this workflow policy program arg applies an action. The base table can be unrelated to ‘the record of the primary ID. For example, the violating row resides in a child table and Siebel CRM must insert or update a record in the parent table. It can also update a table that is not related to the primary ID table. For example, to create a broadcast message when a monitored value in the opportunity becomes true.

The name of a table in the repository, as compared to the business object that a workflow process references. Siebel CRM uses the business object that a workflow process references to monitor values but not to code an action program.

Update Row ID

Specifies the row ID of a table other than the primary table of the workflow policy object. You can configure Siebel CRM to associate a workflow policy action with a workflow policy object that updates a table.

Siebel CRM uses the Update Row ID property only if the Operation Type is set to Update.

The row ID that Siebel CRM must update.

Operation Type

Specifies to perform an update operation or insert operation.

You can use one of the following values:

  • Update

  • Insert

Field Name

Specifies the Name of the column in the base table that this operation updates. This value is one of two field column pairs.

You can use one of the following values:

  • Text

  • Variable

  • Function

New Row ID

Specifies the row ID of the row that Siebel CRM must insert. Siebel CRM automatically populate this property with this row ID.

Empty.

Field Name (Column)

Specifies the field name using the following format:

Field_nameColumn

where:

  • Field name is the field name of the first column pair

This is the second of two column pairs.

Field name in the base table. This value cannot contain leading spaces.

Sql Statement

Specifies the data from the Siebel database that Siebel CRM uses to populate substitutions when it performs an action.

Valid SQL query statement for one of the following RDBMS that your implementation uses:

  • Oracle

  • MS SQL

  • Informix

  • Sybase

Sql Statement Inputs

Specifies the name of a column in the base table on which Siebel CRM performs an operation.

Not applicable.

Sql Statement Outputs

Specifies a variable for the values that the SQL Statement argument chooses.

Name of the variable.