Forecasting Per-hour Absences

Per-hour absences are typically calculated based on the number of eligible hours an employee works in the current period. The eligible hours are usually sourced from other elements (e.g. Regular Earnings Auto-Assigned Units). By nature, these absence types do not forecast easily, as the forecast programme does not resolve the associated elements.

This example shows how to enable forecasting using an employee’s Standard Hours.

It is assumed the system is configured to enable forecasting (i.e. Country, Country Take & Forecasting Calendar Group)

Step 1 – Configure/review the Forecast Formula.

Main Menu > Set Up HRMS > Product Related > Global Payroll & Absence Mgmt > Elements > Supporting Elements > Formulas

Step 2 – Configure/review the Absence Take, Forecasting functionality

Main Menu > Set Up HRMS > Product Related > Global Payroll & Absence Mgmt > Elements > Absence Elements > Formulas

Gotcha!: Ensure both Absence Entitlement and Absence Take have Forecasting enabled. This small detail can be easily missed and can cause much frustration.

Step 3 – Configure Entitlement Formula to allow for forecasting.

The following code snippet shows the Entitlement Formula:

---

IF SY[TXN RSLT OPTN] = 'T' OR SY[TXN RSLT OPTN] = 'N' THEN
SY[STD HRS] * 2 * 0.076600 >> FM[FM ANN STD HR]
ELSE
AC[AC REC BASE] * 0.076600 >> FM[FM ANN STD HR]
ENDIF

---

The “TXN RSLT OPTN” System Element is used to determine if the formula is being used by the Forecasting process (this element is only available during forecasting). If the entitlement is used for forecasting the employee’s “Standard Hours” are used to calculate the entitlement. Otherwise an Accumulator is used.

Main Menu > Set Up HRMS > Product Related > Global Payroll & Absence Mgmt > Elements > Supporting Elements > Formulas

Control the Resolution of Comp Rate based Earnings

How do you control the resolution of an Earning element based on the assignment of a Compensation Rate code on an employee’s Job Data? It is not as easy as you think: If a Comp Rate Code is configured with a Default Value and a related Earning Element is assigned “by Eligibility Group” the Element will resolve for all employees, even if they don’t have the Comp Rate Code assigned on the Job Data, Compensation page.

This example shows how to ensure an Earning Element only resolves if a specified Comp Rate Code is present on an Employee’s Job Data, Compensation Page.

Prerequisites:

• Comp Rate Code with default amount/value exists
• Earning Element that uses the above mentioned Comp Rate Code is configured (and resolves)

Step 1 – Create a Flag Variable to indicate if the Comp Rate Code is assigned.

Step 2 – Create a Variable to hold a Comp Rate Code.

Step 3 – Create an Array to check the Employee’s Job Data, Compensation details

Step 4 – Create a Formula to check for the specified Comp Rate Code.

Step 5 – Add the Formula to the Array's Processing Formulas.

Step 6 – Assign the Array to the Initialise Section of the Payroll Process List

Step 7 – Attach a generation control to the Earning Element to check if the Flag Variable is set to 1.

Result: When the Array is called from the Initialise Section, it retrieves the data related to the employee from the PS_GP_ table. The Formula is run for each row and if the Comp Rate Code if found, the Flag Variable is set to 1. A simple Generation Control then checks the Flag Variable.