1. Administering Payroll for United States Family and Medical Leave Act
  2. Absence Plan Conversion Formula

Absence Plan Conversion Formula

You can create a conversion formula for cases where you track absence time using a different unit of measure. For example, you can convert hours to weeks or fractions of a week.

In such a case, it performs this calculation.

Absence Hours in a Week / Work Week Hours

For example, if the employee has taken 8 hours of sick time and the employee's hours in the work week are 40, then the following calculation occurs to convert the hours to weeks:

8 hours sick / 40 hours in a week = .2 weeks

In this case, the source of work week hours comes from the Working Hours on the assignment and may require conversion based on the frequency.

Create the Plan

If you require a conversion formula, use the Fast Formulas task to create one similar to this.

DEFAULT FOR IV_START_DATE IS '4712/12/31 00:00:00' (date)
DEFAULT FOR IV_END_DATE IS '4712/12/31 00:00:00' (date)
DEFAULT FOR IV_START_TIME IS '00:00'
DEFAULT FOR IV_END_TIME IS '23:59'
DEFAULT FOR IV_START_DURATION IS 0
DEFAULT FOR IV_END_DURATION IS 0
DEFAULT FOR IV_TOTAL_DURATION IS 0
DEFAULT FOR PER_ASG_STANDARD_WORKING_HOURS IS 0
DEFAULT FOR PER_ASG_STANDARD_WORKING_HOURS_FREQUENCY IS 'W'
INPUTS ARE IV_START_DATE (date), IV_END_DATE (date),
IV_START_TIME(text),IV_END_TIME(text),
IV_START_DURATION(number),
IV_END_DURATION(number),IV_TOTAL_DURATION(number)
ln_duration = 0
ln_duration_mid = 0
ln_week_conversion_factor = 1
lc_frequency = PER_ASG_STANDARD_WORKING_HOURS_FREQUENCY
IF (lc_frequency = 'D')
THEN (ln_week_conversion_factor = ln_week_conversion_factor * 7)
IF (lc_frequency = 'BW')
THEN (ln_week_conversion_factor = ln_week_conversion_factor / 2)
IF (lc_frequency = 'SM')
THEN (ln_week_conversion_factor = (ln_week_conversion_factor * 24) / 52)
IF (lc_frequency = 'M')
THEN (ln_week_conversion_factor = (ln_week_conversion_factor * 12) / 52)
IF (lc_frequency = 'Y')
THEN (ln_week_conversion_factor = ln_week_conversion_factor / 52)
ln_abs_duration=IV_TOTAL_DURATION
ld_period_start_date = to_date(to_char(IV_START_DATE,'DD/MM/RRRR')||'
'||IV_START_TIME,'DD/MM/RRRR HH24:MI:SS')
ld_period_end_date = to_date(to_char(IV_END_DATE,'DD/MM/RRRR')||' '||IV_END_TIME,'DD/MM/RRRR HH24:MI:SS')
IF (ln_abs_duration =0 )
THEN
(
ln_abs_duration = GET_PAY_AVAILABILITY
 ('ASSIGN',
ld_period_start_date
ld_period_end_date,
 'Y',
 'Y',
 'N',
 'Y',
 'H')
)
ln_total_working_hours = PER_ASG_STANDARD_WORKING_HOURS * 
ln_week_conversion_factor
ln_duration_mid = ln_abs_duration/ln_total_working_hours
duration = round(ln_duration_mid,2)
RETURN duration

You can modify this example to meet your needs.

For further info, see Absence Plans for FMLA Benefits in the Help Center.

Attach the Formula to the Absence Plan

To attach the formula to the absence plan:

  1. In My Client Groups, click Absences.

  2. Click Absence Plans.

  3. Search for and select the plan you created.

  4. Select Edit and Correct.

  5. Select the conversion formula from Plan Attributes.

  6. Find your fast formula, and select it.

  7. Click Save and Close.

Related Topics