Previous  Next          Contents  Index  Navigation  Glossary  Library

Creating an Assignment Set

There are two uses of assignment sets in Oracle HRMS:

There are three ways to define the set:

Use the Assignment Set window to define your set.

To define an assignment set using criteria for a formula:

No. Condition Database Item Operator Value/ Database Item
10   &SALARY_PAY_VALUE_ENTRY_VALUE >= 16000
20 AND &SALARY_PAY_VALUE_ENTRY_VALUE <= 24000

Operator Symbols Meaning
Equals = The condition is true if both expressions have exactly the same value. For text, the case of the expression must be the same. So, for example, 'Smith' is not equal to 'SMITH'.
Not Equal != The condition is true if the result of the first expression does NOT have the same value as the result of the second expression.
Greater than > The condition is true if the first expression is alphabetically after, or has a numerically greater value, or a later date than the second expression.
Less than < The condition is true if the first expression is alphabetically before, or has a numerically smaller value, or an earlier date than the second expression.
Greater than or equal to >= The condition is true if either the greater than OR the equal to operator returns a true result.
Less than or equal to <= The condition is true if either the less than OR the equal to operator returns a true result.

To define a set by including or excluding assignments:


         Previous  Next          Contents  Index  Navigation  Glossary  Library