Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Quick Setup Steps

...

Step 1 of Leave Method Setup

Field NameSelection OptionsDescription
Assign LevelGlobalSelect this option if the accrual method applies to a group of employees based on common attribute(s) from an employee record, 
EmployeeSelect this option to assign this method directly to an employee
Activeif the accrual method is active
⏹️If the method is inactive
Name
Enter a name to identify the accrual method. This field is limited to 100 characters.
Time Code Group
Select the time code group where the hours are accrued
Method Start Date
The date the method goes into effect

Accrual Based On

V8.2 Base Accrual Rate Calculation

Accrual - By Day

If the accrual is calculated based on the number of days specified in the Day of Accrual field times the accrual rate specified in the Base Accrual Rate field

Accrual - By Period

If the accrual is calculated based on the reporting period defined in user's employee profile and the accrual rate specified in the Base Accrual Rate field.

By Day Prorated by FTEIf the accrual is calculated based on the number of days specified in the Day of Accrual field times the accrual rate specified in the Base Accrual Rate field times the FTE of an employee type assigned to a user
By Period Prorated by FTEIf the accrual is calculated based on the reporting period defined in user's employee profile and the accrual rate specified in the Base Accrual Rate field multiplied by the standard working hours per day defined in the Location field assigned to the user, divided by the 8 standard hours and multiplied by FTE
By Period Prorated by Standard hours

If the accrual is calculated based on the accrual rate specified in the Base Accrual Rate field, the number of specific type of hours worked specified in the Time Code(s) selected field, prorated by the number of total standard working hours within a reporting period, calculated based on the reporting period of a user and the type of the days selected in the Day of Accrual field. The formula is Accrual Rate * Number of worked hours/total working hours within a period. This field takes into account the daily standard working hours defined in employee's Location field.

Comp Time - Fixed Rate


If the accrual is earned based on each hour worked (charged to a specific time code). The type of worked time that would qualify a user for accrual is defined in the Time Code(s) selected field. The accrual rate for each hour worked is defined in the Base Accrual Rate field. As an example each hour charged to ST time code earns a user 0.10 of benefit time.

Comp Time - Prorated RateIf the accrual is earned based on each hour worked (charged to a specific time code). The type of worked time that would qualify a user for accrual is defined in the Time Code(s) selected field. The accrual rate needs to be defined per period in the Base Accrual Rate field. The rate is then divided by total standard hours per period to calculate the actual comp rate per hour. 
Fixed Accrual

If the accrual is a fixed amount not dependent on by day, period, or pro-ration.

Fixed Accrual Prorated by FTEThe fixed accrual rate multiplied by the FTE of an employee type assigned to a user

Day of Accrual



Days of Accrual field is used in the following 2 cases:

a. If the accrual is calculated by period, and an employee starts or is terminated in the middle of the period, the rate is prorated based on the number of days specified in this option. All Days, Working Days or Working Days+Holidays

b. If the accrual is by day, this field is used to analyze which days to count towards the accrual, since the accrual is always calculated by period behind the scenes, this field allows us to know the number of days to be used as a multiplier.

All days 
Working Days OnlyIf holidays and weekends are to be excluded from the accrual rate calculation
Working Days + HolidaysIf all days except weekends are to be included in the accrual rate calculation
Time Codes For Paid Days Limit
  1. This field is required if Comp Time-Fixed Rate and Comp Time - Prorated Rate options are being used in the Accrual Based on field. Select the time codes that would qualify a user to earn leave time.
  2. This field is optional if other accrual options are being used in the Accrual Based on field. Select time codes that would disqualify a user to earn leave time. (Example. User will not accrue Paid Time Off on days where Leave Without Pay(LWP) time code has been used. If a timesheet period includes where at least one hour of this time code is being charged the accrual for the next period will be prorated. So as an example if LWP is being used in a week the accrual rate will be multiplied by the number of days where LWP was charged, divided by the standard working days. In addition number of days can be specified in the Pay Days Limit field to require minimum number of days a user must charge against time codes not specified in this list to be able to accrue.

Prorate Net Accrual 

(Does not apply to fixed accrual)

0-if less than limit

If the total hours to be prorated in a timesheet is less than or equal the limit defined in the Paid Days Limit field, the accrual is 0. 

For the methods based on the comp time if total hours for proration in a timesheet exceed the Paid Days limit, the accrual rate per period is Comp Rate x (comp hours-limit)

Limit earned hours worked

Limit earned hours worked - Used for COMP Time

If a user worked more than the limit, the accrual rate will be the rate x limit

Limit COMP accrual by number of hrs worked by period / multiple periods (e.g. 40 hrs weekly / 80 hrs per biweekly payroll) – COMP time with limit per period So:

  • If user worked 10h – accrual is 5
  • If user worked 20h – accrual is 10
  • If user worked 39h – accrual is 19.5
  • If user worked 40h – accrual is 20 (Prorated per-period earning, based on hours worked)
  • If user worked 40.5h – accrual still 20
No ProrationNo proration applied to the accrued hours in the balance table
Prorate based on standard hours work

This field is one of the elements in calculating accrued hours when calculating overall Ending Balance of a user. The formula for calculating users ending balance is the following: Ending Balance=Start Balance + Accrued Hours + Manually Adjusted Hours (if applicable in the employee profile)+ Bank Hours (if applicable and manually added by admin in employee profile). 

From the formula above the Prorate Based On Standard Hours Worked is used in the Accrued Hours calculation as follows: Accrued Hours = Base Accrual Rate x Number of hours charged to the time codes selected in Time Code for Prorate Accrual Based on field divided by Standard Working Hours 

Prorate based on total hours work

This field is one of the elements in calculating accrued hours when calculating overall Ending Balance of a user. The formula for calculating users ending balance is the following: Ending Balance=Start Balance + Accrued Hours + Manually Adjusted Hours (if applicable in the employee profile)+ Bank Hours (if applicable and manually added by admin in employee profile). 

From the formula above the Prorate Based On Total Hours Worked is used in the Accrued Hours calculation as follows: Accrued Hours = Base Accrual Rate x Number of hours charged to the time codes selected in Time Code for Prorate Accrual Based on field divided by Total Hours Work

Time Code For Prorate Accrual Based On

(V8.2 Time codes for Net Accrual Proration)


The time codes selected for Prorate Accrual Based On calculation
Paid Days Limit

Enter the number of fully paid days needed to allow accrual. This option works in combination with Time Code for Prorate Accrual Based On, If on any day a user charged time against the time codes selected in this list, there will be no hours accrued for this day. 

If the limit is >0 and the total number of days when user charged the limited time codes from the Time Code for Prorate Accrual Based on is greater than Paid Days Limit- there will be no accrual for the entire period.


Enable Cumulative AccrualYesThis field is only applicable if the Number of Months Before Accrual Available is more than zero. If enabled then the number of hours a user would have accumulated for the number of months specified in the Number of Months Before Accrual Available field become available after this period
NoThis field is only applicable if the Number of Months Before Accrual Available is more than zero. If not enabled then the user starts accumulating the hours from zero starting at   number of months specified in the Number of Months Before Accrual Available 
Base Accrual Rate

Enter the starting accrual rate for users with 0 years of service. Additional rates will be entered in a later step

Daily Base Prorate Hours 

This option is used only for rate type By Period Prorated by Standard hours

For this rate type prorated rate is computed as

base rate*FTE* hours in day per location/Daily Base Prorate Hours

Hire/Term Employee Rate Options (Version 8.3 and higher)
This option is available for accrual methods in Version 8.3 and higher. Applies only when one of the following Base Accrual Calculation options are used: Accrual By Period, By Period Prorated by FTE, By Period Prorated by Standard Hours. In all other cases a selection in this field will be ignored. This is used in case the accrual rate for the period needs to be prorated further by the number days in any period based on the employee hire and termination dates, in cases where an employee is hired or terminated in the middle of the period and an employer does not want the end user to accrue for the full rate for that period.
Hire - Full, Term-FullUse this option if an employee earns the full accrual rate for both the timesheet reporting period in which they were hired and the period in which they were terminated
Hire - Full, Term-noUse this option if an employee earns the full accrual rate for the timesheet reporting period in which they were hired and 0 accrual for the period in which they were terminated
Hire - Full, Term-proportionalUse this option if an employee earns the full accrual rate for the timesheet reporting period in which they were hired and proportional accrual rate based on the number of days until termination for the period in which they were terminated (proportional rate is calculated based on the  percentage of the days that the user worked multiplied by the rate by period)
Hire - no, Term-FullUse this option if an employee earns 0 accrual rate for the timesheet reporting period in which they were hired and a full accrual rate for the period in which they were terminated
Hire - no, Term-noUse this option if an employee earns 0 accrual rate for the timesheet reporting period in which they were hired and 0 accrual for the period in which they were terminated
Hire - no, Term-proportionalUse this option if an employee earns 0 accrual rate for the timesheet reporting period in which they were hired and proportional accrual rate based on the number of days until termination for the period in which they were terminated
Hire - proportional Term-FullUse this option if an employee earns an accrual rate proportional to the number of days worked within the hire period  and full accrual rate for the period in which they were terminated
Hire - proportional Term-noUse this option if an employee earns an accrual rate proportional to the number of days worked within the hire period  and 0 accrual for the period in which they were terminated
Hire - proportional Term-proportionalUse this option if an employee earns an accrual rate proportional to the number of days worked within the hire period  and proportional accrual rate based on the number of days until termination for the period in which they were terminated
Number of Months Before Accrual Available

Enter number of months after which the leave hours should become available to a new employee. See Enable Cumulative Accrual  field for additional options

Initial Balance For New Employees
Starting balance granted to the user at the beginning of the employment
Number Of Months Before Initial Balance Available
Number of months at which the Initial Balance For New Employees becomes available to a user
Set Leave Balance To Zero For Terminated EmployeesYesIf this option is selected, if a user has an ending balance at termination date the ending balances will be reduced to zero
NoIf this option is selected, if a user has an ending balance at termination date the ending balances will remain in the system
Keep AccrualYesThis option only applies if Hours Limit options is set. If selected, in case a user  balances has reached the max Hours Limit,  the system will continue tracking any balances above the limit, as soon as the hours taken are below the limit the balances will be re-filled up to the available balance.
NoThis option only applies if Hours Limit options is set. If No is selected, in case a user balances has reached the max Hours Limit, user will continue the accrual at a regular rate after the taken leave has reduced the balance below Hours Limit 
Start Accrual Based OnJanuary - December

This option overrides the option selected on the Reporting Period  and Time Code Group. It defines the start of accrual year based on the specific month for the selected time code group in this method.  

Based on Employee previous date of serviceThis option overrides the option selected on the Reporting Period  and Time Code Group. It defines the start of accrual year based on the Employee original hire month, this field is located in the Employee setup screen and is called Previous Date of Sservice (in case an employee was refired) for the selected time code group in this method. 
Based on Employee Start Date

This option overrides the option selected on the Reporting Period  and Time Code Group. It defines the start of accrual year based on the Employee Start Date for the selected time code group in this method. 

Disabled and Enable only at the Time Code Group.This option   points to Time Code Group  to define the start of the accrual year. 

Fixed Rate Options

*This only applies to accrual set up based on calendar year and or starting month other than Jan. The option will be ignored if the accrual is based on employee anniversary. 

V8.2 New Hire Fixed Rate

Accrual Full Fixed Rate in regards of start date.

This option only applied if Fixed Accrual or Accrual Prorated by FTE options are selected in Accrual Based on field. The full fixed rate is granted regardless of the start date of the hire.

Based on Scheduled Absolute ValueWhen the accrual rate is fixed per year and an employee is hired in the middle of the year, the rate can be prorated based on the number of hours defined in the New Hire Fixed Rate tab. In this table the admin needs to define the number of month and the corresponding fixed rate per month, based on the number of months that has already passed in the accrual year. The rate for a full year is defined in the Base Accrual Rate field and the fractions of that rate based on the number of months worked are defined in the New Hire Fixed Rate tab in the accrual method setup screen. These tabs will only appear if one of the Scheduled Fixed Rate Options are selected. 
Based on Schedule PercentThe same as above, except the rate is defined as the percentage of the Base Accrual Rate instead of an absolute value
No accrual on employee start date for Fixed Rate only.This option only applied if Fixed Accrual or Accrual Prorated by FTE options are selected in Accrual Based on field. User starts with zero fixed rate until the new accrual year. 
Prorated based on number of months employee works in a year from start date.

This option only applied if Fixed Accrual or Accrual Prorated by FTE options are selected in Accrual Based on field. The fixed accrual rate is taken and prorated based on the number of months the employee has worked. 

The month when employee starts is included.

Accrual New Year StartsBased on the Start of the Accrual Period (Default)When an old year transitions into a new accrual year and the first date of the new accrual year falls in the middle of the timesheet. Start the new accrual year on the timesheet that contains first day of the new year.
Reporting Next following period in the New YearWhen an old year transitions into a new accrual year and the first date of the new accrual year falls in the middle of the timesheet. Start the new accrual year from the next reporting period, where the first date of the timesheets falls into the new year.
Balance RoundingDisabledWhen calculating the ending balance the hours are not rounded
Round DownWhen calculating the accrued hours the hours are rounded down  using the increments specified in the reporting period setup
Round UpWhen calculating the accrued hours the hours are rounded up using the increments specified in the reporting period setup
To the nearestWhen calculating the accrued hours the hours are rounded to the nearest decimal using the increments specified in the reporting period setup
Apply Full Rate On Missing PeriodYesThis option overrides the setting in case Prorate Accrual Based On is being used and the accrual is based on the number of hours worked. If enabled the system will insert the full accrual rate if a timesheet is missing (A timesheet is considered in a New Timesheet status or a timesheet has no hours)
NoThe accrual rate for the missing timesheets will be zero (A timesheet is considered in a New Timesheet status or a timesheet has no hours)
Description
Enter text to further identify the function.  This field is limited to 255 characters.

...

Once the set up steps above are completed Administrators must schedule a profile jobs as follows:

  1. Expand Data Piping by clicking on the plus sign.
  2. Click on All Profile Task
  3. Click Add to create a profile
    1. Name* - Enter in a name for the profile like below
    2. Profile Type* - Select Update Employee Leave Balance
    3. Description  - Enter in a description for the profile (Optional)
  4. Click Save
  5. Click the Parameters tab and fill out the field options

...