FMLA ACCRUAL RULE (One Year Prev)#

The One Year previous rule is a rule that looks back 365 days prior to the leave line being evaluated to check the amount available for the employee to take in the current period. The accrual end date is the end of the pay period being evaluated and the accrual start date is 365 days prior to the end date. The system will look at all leave lines taken in the 365 day period and check to see what the hours are compared to the accrual defined in the Service levels tab if there is time available the employee will be able to take the time otherwise it will go to LWOP.

Biweekly Example:#

An employee uses FMLA leave multiple times during the year. The accrual is always 480 hours however as time is used the bank balance is reduced until it has been a year since the original time was taken. At that point the time used in that time frame is added back to the bank to be available to the employee again. This creates a constant rolling balance within the bank of the original 480 hours, time taken and time added back after 365 days has elapsed. If the employee has gone an entire year without FMLA being taken the bank would end up with 480 hours again available for use.
Start DateEnd DateAccrualTime Added BackTime TakenBalance
15-Jun-201314-Jun-2014480 80400
29-Jun-201428-Jun-2014 80320
13-Jul-201414-Jul-2014 20300
27-Jul-201426-Jul-2014 300
10-Aug-201409-Aug-2014 300
24-Aug-201423-Aug-2014 300
07-Sep-201406-Sep-2014 300
21-Sep-201420-Sep-2014 40 260
05-Oct-201404-Oct-2014 40 220
19-Oct-201418-Oct-2014 40 180
02-Nov-201401-Nov-2014 180
30-Nov-201429-Nov-2014 180
14-Dec-201413-Dec-2014 180
28-Dec-201427-Dec-2015 180
11-Jan-201510-Jan-2016 180
25-Jan-201524-Jan-2016 180
08-Feb-201507-Feb-2016 180
22-Feb-201521-Feb-2016 180
22-Mar-201521-Mar-2016 180
05-Apr-201504-Apr-2016 180
19-Apr-201518-Apr-2016 180
03-May-201502-May-2016 180
17-May-201516-May-2016 180
31-May-201530-May-2016 180
14-Jun-201513-Jun-2016 180
28-Jun-201527-Jun-2016 80 180
12-Jul-201511-Jul-2016 80 180
26-Jul-201525-Jul-2016 20 360
09-Aug-201508-Aug-2016 360
23-Aug-201522-Aug-2016 360


The Entitlement for the 365 days period will be retrieved from the ‘Entitlement Time’ column in the ‘Service Level’ associated with the Leave Policy.

IALA (Accrual Record)#

User procedures are first defined on the Maintain Functions (IMFN) screen.

  • A new start and end date is created for the policy each time UACALC or UPCALC is run for the policy
  • The entitlement is calculated each time UACALC or UPCALC is run
  • Year end processing doesn’t take place with this bank as the bank rolls every pay period or UACALC processing date, therefore no A900 rule is required
  • If running from UPCALC the accrual end date will be obtained from the pay period end date
  • If running from UACALC the AS OF DATE of processing will be used as the end date
  • The date on the accrual in not significant as the time available to take is calculated each time a leave line is entered
  • The entitlement will be updated each time UPCALC or UACALC is run so if FTE rules are being used to obtain the entitlement, it will be updated accordingly.
  • FMLA requires the employee to be employed for one year and to have worked 1250 hours each year to qualify. With this rule, the 1250 hours is also a ‘rolling year’. Additional functionality using User Calc operators will be used to handle this requirement. (See example of a sample User Calc shown later in this document)
Whenever a leave line is created, the balance of time owing is computed by first taking the entitlement from the accrual record and then calculating the time taken for the prior 365 days using the leave line details.

User Defined Field#

A User Defined Field is created the first time this rule is used. This User Defined Field will be on the leave line created for policies using this specific rule. The text in the User Defined Field will display how the time taken for the prior 365 days has been calculated. It will also give the entitlement owed the employee before the current entry. You can add the UDF to the Requested Tab of the IAAL using the IMFDH.

SET UP Requirements:#

IALP – Leave Policy#

Details Tab:#

Accrual Begin Rule: One Year Previous End Date: Null Frequency: Null

Components:#

NOTE: A200 Rule must be ‘01’ A290 Rule must be ‘02’ (see defect 40149), prior to this defect the rule was ‘01’
AC CodeSeqRuleRequiredCompenent DescriptionRule Description
A001100 Preprocess/Qualify Usercalc Use User Calc Only
A10010002R Service Length Calculation Calculate Based on Service Date
A11011002R Service Date Hire Date
A12012001R Service Length Evaluation Freq Every Time Policy Evaluated (Eval Date)
A13013002R Service Length Replace Service Length
A14014001RService Length Change Amount of Service Length Change
A20020001R Entitlement Frequency Give Entitlement Each Evaluation
A26026002R Period Entitlement MethodService Level Entitlement (Prorate by FTE)
A27027003 Prorate by FTE RuleProrated by EE’s FTE value
A29029002R Current Year Entitlement Rederive Time Entitlement
A30030001R Total Time Taken Derive from All Sources
A32032003R Time Available to Take Prior Year Plus Annual Entitlement Cap
A33033003R Current Year Entitlement Entitlement with No Caps Applied
A70070302RCurrent Year Time Owing Prior Plus Current Year Less Taken
A90030003 Time Owing at Year End Cap Current Owing with Year-end Cap (YE Cap is zero)

IMUC#

A User Calculation to verify the hours worked for the employee in the past 12 months may be added at A260 to prevent entitlement if needed. A sample User Calculation is below. This User Calculation verifies hours worked in the last 12 months. If the employee has worked at least 1250 hours the normal number parameter will be passed through at this point. If the employee has worked less than the 1250 hours, the parameter will be reset to ‘0’.

The ELPL Usercalc operator has been enhanced to provide the ability to use any date range when computing the value for an Element from Pay Transactions. Previously this feature always used the Pay Period Start Date as the begin date and ‘Operator 3’ as the end date.

There are two ‘Variables’ that can be used to control the begin and end dates when using the ELPL operator. If either or both of these variables exist in the Usercalc, then the value loaded into them will be used by the ELPL Operator. NOTE: This will look at all pay headers associated with the employee’s assignments within the current employment. The Usercalc will look at the pay lines for the dates, and the pay details for the amounts.

If the variables identified above are NOT in the Usercalc, then the ELPL Operator will work the same way it has in the past.

The names of the two variables must be ‘Exactly’ as shown in this example:

IPPP#

The attendance type must be added to the appropriate pay points. If the FMLA time codes will be associated to other leave policies, ensure that FMLA is listed on the pay point before the other policies.

IALS#

The time codes used for this policy type must be added to the leave schedule.

IALA#

See example below where the ‘unofficial’ accrual has updated start and end dates.

High Line Recommendations for converting historical FMLA data into IAAL:#

The following steps should be used when converting leave lines:

1. Load transactions to the IPTL (via LMTD) with a destination of IPTR. The following information must be provided:

  • Employee Information (i.e. Person Code)
  • Date of Leave
  • Amount of leave time (i.e. hours)
  • Time code will be FMLA WOP only as we don’t need the additional information for FMLA SICK or FMLA VAC etc.

2. The loaded entries may be verified in IPTL

3. Use UPTL to process the entries to the IPTR. NOTE: This creates IPTR batches for each pay period with the transactions in the loaded file as well as creating the leave lines (IAAL)

4. Verify leave line entries in IAAL on the ‘In Payroll’ tab. (Note: You will not see the results in VALB)

5. Break the link between IPTR transactions and the IAAL leave lines that were created above using SQL:

  • Update p2k_pr_pay_trans_time_codes set aal_id = NULL
  • Where ptr_id in (select id from p2k_pr_pay_transactions where mex_id_generated = <the UPTL MEX_ID>);


Notes#

HL-458
There is no rollover. Once the plan has run it's course, a new IALA will not be created until the next time a transaction is entered.
There are gaps between occurrences of this bank.

  • The accrual start date is the date of the first transaction entered
  • The accrual end date is 365 days (1 year) in the future, from the start date

Notes prior to HL-458
There are three scenarios that an employee may take FMLA:

  1. Use FMLA Federal Only: FMLA Sick will be paid via association with the FMLA Federal (can this be worded better? - via association?)
  2. Use FMLA State Only: FMLA Sick will be paid via association with the FMLA State (can this be worded better? - via association?)
  3. If FMLA is for Both Federal and State:
    1. FMLA Sick will be paid via association with the FMLA Federal
    2. FMLA bank for Federal will be reduced using the timecode taken, such as FMLA_FEDNJ_TKN
    3. FMLA bank for State will be reduced using the FMLA State LWOP timecode

Set up for the FMLA Federal and FMLA State will require their own Leave Type to be able to add to the Pay Point