Related Topics   

Workers' Compensation Benefit Projections

Contents

1 Overview

2 Exception Report

3 How-to

4 Selection Criteria

5 Tables Diagram

4 Selection Criteria

The following criteria are used by the program in this process:

  1. Criteria for Assignment Record Processing:  This process will perform calculations for all Employee Management System Assignment Records (HPMASN-ASSIGNMENTS) that are part of the current plan. To perform the required calculations, assignment records for an employee will be processed as a group.

  2. Work Hours Calculation:  Because the Workers’ Compensation premium is based on work hours, the first step in projecting benefit amounts is to calculate Work Hours. Work Hours are calculated only for those assignment records subject to Workers’ Compensation – that is, where there is an active Workers’ Compensation benefit.

As they are calculated, Work Hours for the employee are accumulated by the Workers' Comp Code (HPADCP-PAY-CODES.WA-HPADCP-WC-CODE) found by linking from the Assignment Record to the Pay Codes (HPADCP-PAY-CODES.HPADCP-PAY-CODE) field.

  1. Work Hours may be calculated in two different ways, Average Hoursand Actual Hours:  The type of calculation is specified in theCalculated by Average Method (HAAETY-EMP-TYPES.WA-HAAETY-WC-AVERAGE) field in theEmployee Type table. If the field has a value of"Yes", the Average Hours method applies. If the value is "No", the Actual Hours method applies.

  2. Average Hours Calculation:  When calculating using Average Hours, Work Hours for the employee are calculated as Average Annual Workers' Comp Hours (HAAETY-EMP-TYPES.WA-HAAETY-WC-AVERAGE-HRS) times the Pay Frequency per Year (HPADCQ-FRQ-CODES.HPADCQ-PAYS-PER-YR). The hours will then be proportionally spread across all Pay records with the same Pay Frequency Code (HPMASN-ASSGNMENTS.HPADCQ-FRQ-CODE) with active Workers’ Compensation deductions or benefits.

  3. Benefit Amount Calculation:  Once the Work Hours for the employee are calculated and totaled by Workers’ Comp Code, the benefit amount will be calculated and placed in the Benefit (HPMPDB-PLN-DED-BEN) record(s). Because Skyward processing for amount-type benefits uses the amount from the first record it encounters and distributes it on the basis of gross pay, the total benefit amount is placed in all of the active Workers’ Compensation benefit records.

The benefit amount for each Workers’ Comp Code is calculated as Work Hours times the Employer Rate for the Workers’ Comp Code (HPADCP-PAY-CODES.WA-HPADCP-WC-CODE).

Once the amounts for all Workers’ Comp codes are calculated, the sum of those amounts is placed in the Amount (HPMPDB-PLN-DED-BEN.HPMPDB-AMT) field and the Number of Times the benefit may be taken (HPMPDB-PLN-DED-BEN.HPMPDB-TIMES) field is set to "1" on all Workers’ Compensation Benefit records for the employee.

    1. Employer Rate:  The Workers’ Compensation employer rates are stored in the Workers' Compensation Rates (WA001WorkersCompRates) table. The record with a Workers' Comp Code is selected that meets all of the following criteria:

      1. matches the Workers' Comp Code (HPADCP-PAY-CODES.WA-HPADCP-WC-CODE), and

      2. is a rate for the current plan, and

      3. with the latest Rate Effective Date (WA001WorkersCompRates.WCRateEffectiveDate) that is less than or equal to the first day of the Fiscal Year (HPMPLN-PLAN.HPMPLN-YEAR) being planned.

If no rate record can be found, a "0" rate is used. Benefit amounts are calculated using the total of the employer rates from the Workers' Compensation Rates table: Employer Accident Rate  (WCAccidentEmployerRate) plus the Employer Medical Rate (WCMedicalEmployerRate) plus the Employer Pension Rate (WCPensionEmployerRate).

Page Updated 3/03

Top