Using Oracle FastFormula

Formula Reference

Netherlands Payee Name Formulas

Oracle HRMS enables you to present the Payee Name of an employee/organization in a specified format, in the EFT Payment File. Creating a FastFormula entitled NL_PAYEE_REPORTING_NAME, you can decide the format the name appears on the file.

Prior to using the FastFormula, the Payee Name of the person/organization appearing on the EFT Payment is taken from the Payee Name field on the Personal Payment Method form. If this field is blank, a check is carried out to find the NL_PAYEE_REPORTING_NAME FastFormula, and use the information generated there. The Payee Name is set to Last Name +"+ Initials of the person being paid, if no formula has been defined.

The Payee Address is taken from the City of the primary address of the relevant employee/organization identified in the Payee Name record. This is left blank if it does not exist. If the Payee Name is derived from the Payee Name field on the Personal Payment Method form, the address used depends on whether the Payee Name specified is a person or an organization. The Payee Address for an organization is taken from the City on the appropriate location address, otherwise, it is taken from the City on the employee's address.

However, if a FastFormula is selected, or the Payee Name consists of the Last Name +"+ Initials, then the City from the employee address is used.

Netherlands EFT Payment Override Formula

Oracle HRMS enables you to override the contents of the Description field in the Transaction Description Record 160 of the EFT Payment file and enter your own information. You define a FastFormula with the standard name NL_TRANSACTION_DESCRIPTION, returning a value called Transaction_Description. The code in the formula can access any database item to derive the Transaction Description value. This description can be up to 128 characters in length, and spread over a maximum of 4 Transaction Description records.

Note: If you use the override, none of the derived values, such as Employee Name and Assignment Number, is included in the Transaction Description records unless added in the FastFormula.

Formulas for Netherlands Wage Tax Subsidies

Oracle HRMS provides you with FastFormulas for each of the following Wage Tax Subsidies:

Netherlands Working Hours Formula

You define a FastFormula with the name NL_WEEKLY_WORKING_HOURS, to return a parameter called Working_Hours with a value for weekly working hours in the format 99.99. The formula code uses any database items or balances to obtain a value for the weekly working hours.

Note: If you do not define a FastFormula, the application draws the working hours from the Individual Working Hours held on the assignment.

Netherlands Reporting ABP Part Time Percentage

Oracle HRMS enables you to override the ABP Part Time percentage at the assignment level. You define a FastFormula with the name NL_ABP_REPORTING_PART_TIME_PERCENTAGE, returning a value called Part_Time_Percentage. The formula code uses any available database items or balances to obtain a value.

Note: This action is only required if you want to override the assignment level information.

Formulas to Enable Additional Part-Time Percentages for the Netherlands

Oracle HRMS enables you to create FastFormulas to calculate each of the additional part-time percentage values for an assignment, overriding the current general part-time percentage and assignment level information. The FastFormulas will have no input values, returning a parameter called Part_Time_Percentage, in the format 999.9999.

If you want all part-time percentage values to be set from information at the assignment level, you do not need to define any overriding FastFormulas.

If you want to override all the part-time percentage values using the same calculation, you define one formula called NL_PART_TIME_PERCENTAGE.

If you need to override any of the part-time percentage values, you must create the appropriate formula from the following:

Note: Pseudo SI Calculation uses the Pseudo SI Part-time Percentage. All the part-time percentages are limited according to the maximum limits set in the corresponding global values.