Page tree
Skip to end of metadata
Go to start of metadata

Overview

The Benefit Update and Projection program provides features that facilitate the tracking of employee vacation, sick leave, and personal leave amounts. The program can be run once each month or as needed to keep balances current.

The Benefit Update and Projection program also assists in converting unused personal leave to sick leave or payment to the employee and in converting Part Time Sick Leave balance for Part-time employees.

Posting Period must be open in order for leave or payment to be posted. Will produce an Error message when ran in Actual:


The 'Accrual' Option allows you to create a projection report or actually perform the accrual calculations for employee vacation, sick leave, and/or personal leave. The accrual amounts are based upon the values entered in the Accum/month fields in the CORE/LEAVES record. For the accumulation fields, a value must also be entered in the Maximum field. During the accumulation process, any maximum field that is left blank will set the employee balance to zero. An error message will also be listed for any employee that has reached the maximum during the accumulation. A Accumulate Sick Leave entry will be added under CORE/LEAVES/ACCUMULATIONS:

The 'Reset Personal Leave' allows you to create a projection report or reset the employee personal leave balance as setup in the CORE/LEAVES record. When Benefit Update and Projection is run, the leave type specified will be reset by the value entered in the Personal, Reset value field. The report includes the previous personal leave balance, the amount that will be added to the current personal leave balance to bring the balance to the reset value, and the new balance.  Reset personal leave will create a new Balance Transaction and will not show in the CORE/LEAVES/ACCUMULATION tab.

The 'Convert Personal Leave To Pay' employees for unused personal leave. When the amount is calculated, partial days may be included or excluded from the payment. When the actual option is processed, a Future MIS entry will be added automatically if the  was checked:

The 'Convert Personal Leave to Sick Leave' allows for unused personal leave days to be converted to sick leave. When the actual option is processed, two entries will show in CORE/LEAVES/ACCUMULATION tab:

The 'Part Time Sick Leave Accrual' allows you to first create a Projection report and then complete the Actual calculations for the employees 'Part Time Sick leave'.  The accrual amounts are based upon the values entered in the employee's Current Service Hours, Service Hours Accumulator and by checking the box for, 'Accumulate Based On Hours' field, in the CORE/LEAVES/SICK record.  On the 'EMPLOYEE' screen, the 'Part Time' box needs to be checked in order to be included on the 'Part Time Sick Leave' accrual. 

 Accrual Option

The 'Benefit Accrual Report' is the default file name for the Accrual report. This can be changed by entering a new file name in the Report Title field.

The Accrual or Projection?: The projection (P) option is the default option and is recommended to be ran first to allow for verification of data before the accrual is made.

Select the type of benefit to be accrued in the Benefit Accrual Options field. The following type of leave are available:

  • Vacation leave
  • Sick leave
  • Personal leave
  • All leave types

If a date is entered in the Specific Accrual Date field, the Attendance records will be added with the date specified. If a date is not entered, the system date will be placed under CORE/LEAVES/ACCUMULATIONS.

The Include ineligible Positions field offers the following options:

  • Check to Include ineligible jobs. Jobs not eligible for benefit(s) will be included on the report.
  • Leave Unchecked if to Exclude ineligible jobs. Only jobs eligible for benefit(s) selected will be included on the report.

The Sort field offers the following options:

  • Employee Name
  • Employee Number

The Select Pay Groups field allows you to select specific Pay Groups for reporting purposes.  Highlight to select those pay groups that you wish to report on from the Available box and move it over  to the Selected box.  You can choose none or any number of pay groups to report on.  To remove from the selected box use  to move it back to the available box.

Or/Both

The Select Employees field allows you to select specific Employees for reporting purposes.  Highlight to select those Employees that you wish to report on from the Available box and move it over  to the Selected box.  You can choose none or any number of Employees to report on.  To remove from the selected box use  to move it back to the available box.

After you have all the selections entered, you will want to 

sample reports

Benefit Accrual Report

Reset Personal Leave Option

The Reset or Projection:  The projection option is the default option and is recommended to be ran first to allow for verification of data before the reset takes place.

Enter in the Specific Accrual Date

The Include ineligible Positions? field offers the following options:

  • Check to Include ineligible jobs: Jobs not eligible for benefit(s) will be included on the report.
  • Leave Unchecked if to Exclude ineligible jobs: Only jobs eligible for benefit(s) selected will be included on the report.

The Sort field offers the following options:

  • Employee Name
  • Employee Number

The Select Pay Groups field allows you to select specific Pay Groups for reporting purposes. Highlight to select those pay groups that you wish to report on from the Available box and move it over  to the Selected box.  You can choose none or any number of pay groups to report on.  To remove from the selected box use  to move it back to the available box.

After you have all the selections entered, you will want to 

Personal Leave Reset Report 

Convert Personal Leave To Pay Option


The 'Personal Leave To Pay Report' is the default file name for the report. This can be changed by entering a new file name in the Report Title field.

The Accrual or Projection? field allows a report to be generated prior to the converting taking place. The projection option is the default option and is recommended to be ran first to allow for verification of data before the conversion is made.

The Sort By field offers the following options:

  • Employee Name
  • Employee Number
  • Pay Group
  • Building/Department
  • Check Distribution
  • Appointment Type

The Post to Future payroll? offers the following:

  • Check to Include in Future payroll
  • Leave unchecked if to Exclude from Future Payroll

Enter an Effective Date . The Effective Date is the date when the record should be paid. When this date is included within the run of the current payroll beginning and ending dates, the record will be included in the payroll. If no date is entered in the Effective Date field, the record will be included in the next payroll run.

In the Set the personal leave balance to zero field:

  • Check to zero Personal leave balance
  • Leave unchecked to retain Personal leave balance

The Convert personal leave option field offers two options: **Required Field**

  • FlatRate - Pay a flat daily/hourly rate for unused personal leave days.  Enter up to 4 rates:

    • Four rates may be entered when using the flat rate option. For example, $50 may be entered in the Rate 1 field to pay the first unused personal day and $25 in the Rate 2 field for the second unused personal day payment. 
    • In the Rate Type field indicate whether the following:
      • Daily - Process the rates as daily rates
      • Hourly - Process the rates as hourly rates
  • PositionRate - Use the daily/hourly position rate to calculate the pay for unused personal leave days.
    •  If using the daily/hourly job rate option, the payment will be based on the CORE/POSITION information. If the job is paid daily, the payment will be based on the daily rate value. If the job is paid hourly, the payment will be calculated by multiplying the hours per day times the hourly rate.

In the Percentage of Balance to Convert field enter a percent from .01-100.00 of the personal leave balance you wish to convert to pay. The percentage may be a fraction or whole number, but it may not be negative. The percentage is not a required field.
If you wish to NOT include partial days, the partial days are taken off right away, then the percentage will be calculated. If the user selects to zero out the personal leave balance, no matter what percent is entered, the personal leave balance will be set to zero.

In the Minimum balance to qualify for converting to pay enter the minimum value of personal days/hours required to qualify for converting the personal days to sick days. The employee's personal leave balance in CORE/LEAVES is compared to the minimum value entered when converting. If blank, any employee with a personal leave balance in CORE/LEAVES will be included.

The Include partial days/hours field allows the following options:

  • Check to Include partial days/hours
  • Leave unchecked to Exclude partial days/hours
    If the option to include partial days/hours is selected, the entire balance of personal leave days will be used in the processing. If the
    option to exclude partial days/hours is selected, only whole days will be converted and the partial days are forfeited.

The Include positions ineligible for personal leave offers the following options:

  • Check to Include positions ineligible for personal leave
  • Leave unchecked to exclude positions ineligible for personal leave

 In the Appointment type field select from the following:

  • Certified employees
  • Classified employees
  • All Appointment Types

The Specific contract start date from fields allow a range of contract start dates in be entered. Only those employees with a contract start date within the specified range, and that meet the other selection criteria, will be included. **Required Field**

The Specific contract stop date from fields allow a range of contract stop dates in be entered. Only those employees with a contract start date within the specified range, and that meet the other selection criteria, will be included.  **Required Field**

The Select Pay Groups field allows you to select specific Pay Groups for reporting purposes. Highlight to select those pay groups that you wish to report on from the Available box and move it over  to the Selected box.  You can choose none or any number of pay groups to report on.  To remove from the selected box use  to move it back to the available box.

The Select Employees field allows for the selection of specific employees. Highlight to select those employees that you wish to report on from the Available box and move it over to the Selected box.  You can choose none or any number of employees to report on.  To remove from the selected box, use  to move it back to the available box.

After you have all the selections entered, you will want to 

sample reports

Convert Unused Personal Leave To Pay Report

Error

When running in Actual, if an Error occurs, this means an employee's pay account is not valid.  The employees above this employee will post correctly but anyone below including this employee will not post.  View the error message and correct the employee's account in Payroll Account.  Then rerun in projection, check the report and if all looks correct run in actual:

Convert Personal Leave to Sick Leave Option


The 'Personal Leave To Sick Leave Report' is the default file name for the report. This can be changed by entering a new file name in the Report Title field. 

The Accrual or Projection? field allows a report to be generated prior to the converting taking place. The projection option is the default option and is recommended to be ran first to allow for verification of data before the conversion is made.

The Sort By field offers the following options:  **Required Field**

  • Employee Name
  • Employee Number
  • Pay Group
  • Building/Department
  • Check Distribution
  • Appointment Type

The Create Personal Leave Option field offers four options: **Required Field**

  • Convert one personal leave day to one sick day
  • Convert 50% of the unused personal leave to sick days
  • Convert the unused personal leave balance minus 1 to sick days
  • Carry over one personal leave day, and convert the remainder of the personal leave days minus 1 to sick days

In the Minimum value of personal days/hours to convert enter the minimum value of personal days/hours required to qualify for converting the personal days to sick days. The employee's personal leave balance in CORE/LEAVES is compared to the minimum value entered when converting. If blank, any employee with a personal leave balance in CORE/LEAVES will be included.

The Include partial days/hours field allows the following options:

  • Check to Include partial days/hours
  • Leave unchecked to Exclude partial days/hours
    If the option to include partial days/hours is selected, the entire balance of personal leave days will be used in the processing. If the option to exclude partial days/hours is selected, only whole days will be converted and the partial days are forfeited.

The Include jobs ineligible for personal leave offers the following options:

  • Check to include jobs ineligible for personal leave
  • Leave unchecked to exclude jobs ineligible for personal leave

The Include jobs ineligible for sick leave offers the following options:

  • Check to include jobs ineligible for personal leave
  • Leave unchecked to exclude jobs ineligible for personal leave

In the Appointment type field select from the following:

  • Certified employees
  • Classified employees
  • All appointment types

The Specific Contract Start Date from fields allow a range of contract start dates in be entered. Only those employees with a contract start date within the specified range, and that meet the other selection criteria, will be included. **Required Field**

The Specific Contract Stop Date from fields allow a range of contract stop dates in be entered. Only those employees with a contract start date within the specified range, and that meet the other selection criteria, will be included.  **Required Field**

The Select Pay Groups field allows you to select specific Pay Groups for reporting purposes. Highlight to select those pay groups that you wish to report on from the Available box and move it over  to the Selected box.  You can choose none or any number of pay groups to report on.  To remove from the selected box use  to move it back to the available box.

The Select Employees field allows for the selection of specific employees. Highlight to select those employees that you wish to report on from the Available box and move it over to the Selected box.  You can choose none or any number of employees to report on.  To remove from the selected box, use  to move it back to the available box.

After you have all the selections entered, you will want to 

Convert Unused Personal Leave To Sick Leave Sample Reports:

Convert one personal leave day to one sick day report

Convert 50% of the unused personal leave to sick days report

                            

 


Convert the unused personal leave balance minus 1 to sick days report

 

Carry over one personal leave day, and convert the remainder of the personal leave days minus 1 sick days report


Part Time Sick Leave Accrual Option

The 'Part Time Sick Leave Accrual Report' is the default file name for the Accrual report.  This can be changed by entering a new file name in the Report Title field.

The Accrual or Projection?:  The projection (P) option is the default option and is recommended to be ran first to allow for verification of data before the accrual is made.

The Sort By field offers the following options:

  • Employee Name
  • Employee Number

The Select Pay Groups field allows you to select specific Pay Groups for reporting purposes. Highlight to select those pay groups that you wish to report on from the Available box and move it over  to the Selected box.  You can choose none or any number of pay groups to report on.  To remove from the selected box use  to move it back to the available box.

After you have all the selections entered, you will want to 

sample reports

Part Time Sick Leave Accrual Report


  • No labels