Building a condition with the Condition Builder

The Condition Builder has three columns. You can add more than one condition on the Condition Builder. If you select Match All, all the conditions are required to be met. If you select Match Any, any one of the conditions is required to be met.

Note: You must be familiar with the database structure of the business class and the values that exist, if you are going to use literal values.

Use this procedure to build conditions.

In the left column, select the field to which you assign a condition. For example, to select employees for company 9100, select Company.

Note: The set of fields that are accessible is the set of fields included in the business class that you selected.
In the middle column, select the condition operator, for example, is equal to.
In the right column, select Literal and specify the value. In this case, 9100.
To add another condition, click the Plus icon.
If applicable, add another condition in the second row. For example, to have only employees from the CORP process level to be eligible, select Company > ProcessLevel (left column) is equal to (center column) Literal CORP (right column).
Continue adding your conditions until you are finished. For example, to further limit the employee group to the ACCTG department, select Company > Department (left column) is equal to (center column) Literal ACCTG (right column).

Note: To remove a condition from the Condition Builder, click the Minus button next to the condition.
When you are done with your conditions, click OK. All the conditions you defined are added in the Condition box separated by and or or, that depends on whether you selected Match All or Match Any. For example:
```
(Company = 9100 and ProcessLevel = "CORP" and Department = "ACCTG")
```
To remove a condition when created, remove it from the text box.

Note: The Condition Builder does not accommodate all scenarios. For example, if you want to pull employees from more than one department, you must edit the base condition within the text.
To add more conditions, click the Builder button, specify your conditions as defined above, and click OK.

When you click OK, the system asks you whether to replace the existing conditions with these conditions, or whether to append the conditions to the existing conditions. If you select Append, the conditions are added at the end of the other conditions.
To preview the group of employees or bank statement lines generated by the condition, click the Preview button.