Define Calculation Functions

Explanation

This activity is used to define your own calculation function when standard system functions are not sufficient. Knowledge of SQL is required.

Prerequisites

There are no prerequisites.

System Effects

As a result of this activity, a user defined calculation function will be available for use in wage code calculations.

Window

Functions,

Related Window Descriptions

Functions, Functions/User Functions

Procedure

1. Open the Functions Window.
2. Navigate to the User Functions tab and add a new record in the table.
3. In the User Function ID field, enter the unique identifier of the function.
4. In the Func Name field, enter the name for the function.
5. In the Number of Parameters field, enter how many parameters the function will require to enter.
6. In the User Function field, enter the SQL code of the function. Please, refer to the field usage or the tab description for a detailed description of what SQL commands are available.
7. In the Remarks field, enter any comments about the function.
8. Save the information.