Siebel Business Process Framework: Workflow Guide > Administering, Testing, and Migrating Workflow Policies > Administering Workflow Policies >

Configuring a Workflow Policy to Reference Multiple Tables

A workflow policy references a database trigger and the workflow policy can run on a database record only after Siebel CRM commits the record. If a workflow policy references multiple database tables, then it goes into effect only after Siebel CRM commits the records on these tables.

For example, Siebel CRM stores opportunity revenue in the S_OPTY_POSTN table and lead quality in the S_OPTY table. A workflow policy that applies each of the following workflow policy conditions goes into effect only after Siebel CRM commits the records on each table:

• Opportunity Revenue > 10M
• Lead Quality is High

To defined multiple business components for the same database table, you can use a search specification. If you configure a workflow policy component to monitor a business component, then make sure you configure Siebel CRM to reference fields in the search specification as workflow policy columns. To enforce the required behavior, you can then use the workflow policy column in the workflow policy conditions.