...Menu...
Menu Group: File Maintenance: Formula Keywords and Function Keywords
Function keywords are similar to database keywords. The difference is that a function keyword is a formula. When encountered in a calling formula the function will be executed and a result will be returned to the calling function. Functions can also call other functions as long as they do not call themselves (recursive).
In the formula shown above an employees' annual salary is calculated based on their salary. If the employee is paid an hourly rate then the function uses the employees' rate of pay multiplied by the number of hours in a standard work week, the result of which is multiplied by the frequency of pay (weekly = 52, monthly = 12 etc.). If the employee is paid a salary then the annual salary will be calculated by multiplying the salary by the frequency of pay. The keywords used in the above formula are defined in the following table:
| Keyword | Dictionary field | Meaning |
| SALHOUR | employee. | Logical field indicating whether an employee is paid hourly or is salaried. |
| SALARY | employee.salary | Employees salary if he/she is paid a salary |
| FREQ | employee.freq | Frequency of pay (can be 12,24,26,52) |
| RATE | employee.rate | Rate of pay if employee is paid hourly. |
| HRS | employee.hrs | Standard hours in standard work week for the employee. |
We provide a number of function keywords with the payroll module; you may add them as needed. Here is a list of function keywords that are provided with the module. More information on how formulas work can be found here.
Last Updated October 20, 2006