Absence Formulas

Formulas offer a convenient way to implement various absence management features. You can create different formulas for the features that you use or use the same formula in as many situations as you need to.

This table lists the absence-related formulas that you may need:

Formula and Page	Use	Element Populated	Value Returned
Per Absence Formula Element (Absence Entitlements - Calculation page)	Required for per-absence entitlement elements. Defines when to resolve entitlement. Resolved each day if the balance is needed during processing.		0 = do not resolve entitlement. Nonzero value = resolve entitlement.
Day Formula (Absence Take - Day Formula page)	Required for all take elements. Interprets each absent day and returns the units to compare to the entitlement balance. Always resolved per day.	DAY COUNT	Count that represents units for the absent day.
Offset Formula (Absence Take - Day Formula page)	Per-absence entitlements only. Automatically reduces beginning entitlement balance. Resolved immediately after a per-absence entitlement is resolved.		Count that can be added to or subtracted from the entitlement balance.
Conditional Formula (Absence Take - Day Formula page)	Defines conditions for generating an absence event for another take element.		Zero or nonzero value.
(Wait) Count Formula (Absence Take - Period page)	Returns the number of remaining days that a payee must be absent before a wait period is satisfied. Often the formula that is used for the Wait Count is the same as the formula that is used for the Day Formula. For example, workday could be counted.	WAIT COUNT	Count
Forecast Element (Absence Take - Forecasting page)	Used during the Forecasting process to evaluate an absence. The result of the formula appears on the Absence Event Entry page. Resolved for each day of an absence event. The system saves only the value that is resolved for the last day of the absence.	ABS EVT FCST VAL	Up to 30 alphanumeric characters.

Many system elements are designed for use within absence formulas and point to columns in the absence daily data table.

For example, assume that you use the system element named SCHED HRS in your Day Formula and that you define the formula, named WRK DAY, as follows:

IF SCHED HRS > 0
THEN 1 ->> WRK DAY
ELSE 0 ->> WRK DAY
END IF

The formula checks to see if scheduled hours are greater than zero. If they are, the day equals one workday. If they are not, it is not a workday. As long as there is at least one scheduled hour, the absent day is considered a workday.

The formula processes each row of the daily data for the specified period for the absence take element that is being processed. For each row, the system retrieves the value for SCHED HRS from the daily data table.

Note:

Absence system elements in the rows of daily data reflect what the current process row contains. You can use other system elements in your formulas; however, the system resolves them only once—not for each row. For example, if you use a system element from the Job row, such as Department, the value for Department does not change for each row.