Understanding Rules

This section discusses:

• General setup steps.

• Rules from actions and conditions and SQL objects.

• Rule step creation guidelines.

All rules in Time and Labor are written in SQL. You don't have to be a SQL expert to create rules because you will probably create most rules using templates, and the templates contain the basic logic, underlying structures, and necessary SQL objects. However, an understanding of SQL is helpful, particularly if you use actions and conditions, or SQL objects to define your rules, since these tools give direct access to SQL logic and language. In addition, to properly create, test, and troubleshoot rules, you should understand the structure of a SQL statement and the basic procedures for converting business rules into SQL rules.