State of Connecticut
Core-CT Project
Application:HRMS
Module:Human Resources
Business Process:Monitor Health & Safety/Workers Compensation
Requirement Number:HR455
Requirement Title:Ability to calculate and store and adjust average annual salary for worker’s compensation
Module Leads: Lina Simonu, Lisa Lagus
- Requirement Description
Describe the requirement (gap). Include a description of the delivered PeopleSoft functionality.
The State of Connecticut processes Worker’s Compensation Claims through a Third Party Administrator, TPA. The TPA is responsible for calculating the worker’s compensation claim benefit rate based on numerous factors. One factor is the employee’s previous 52 weeks average salary as of the claim date minus any additional payments, such as retroactive pay that may not apply entirely to those periods. PeopleSoft, as delivered, does not have a program to calculate the average salary for an employee based on the previous 52 weeks pay as of the claim date. In addition, the calculated average salary may need to be adjusted manually by the Agency HR Specialist. Therefore, the calculated amount needs to exist on-line and be available for adjustment due to retroactive or other additional payments that should not be included in the calculated average salary. As delivered, PeopleSoft does not have a field to store this amount. In addition, upon implementation PeopleSoft will not contain wage history.
- Business Need
Provide a justification for the requirement. Include information about frequency, volume, number of users impacted, etc.
The Detailed Gross pay for the last 52 weeks since the claim date and the Calculated Average Gross pay for eligible earnings codes for the last 52 weeks since the claim date must be sent in order for the TPA to determine the rate of worker’s compensation pay to award the employee if the claim is approved. The historical rates must be stored as rates change due to collective bargaining increases and annual increases, and the original rate is often used in calculating the final settlement.
- Required By: (Y/N)
Federal ____Agency ____Bargaining Unit __
State Statutory ____State Regulatory ____State Procedural __Y__
- Requirement Priority
Medium(High, Medium, Low – please see “Requirements Prioritization Criteria”)
- Recommended Solution
Enter an “X” next to the appropriate category
______Process Solution
__Option Number
___X__Application Modification
_1_Option Number
- Explanation for Recommendation
Provide reasons for recommendation. Please do not re-state the description of the solution itself.
The TPA needs the calculated average bi-weekly salary based on the previous 52 weeks of pay as of the claim date to calculate the Worker’s Compensation rate. The Agency needs the ability to adjust this calculation if the employee had retroactive or other payments that should not be included in the Worker’s Compensation rate. In order to adjust the average salary, the Agency needs access to review the payroll earnings data in usable format. Therefore, a modification is recommended to calculate the salary and a query is recommended to review the data to identify adjustments.
- Organizational Impact of Recommendation
Describe the changes to the organization that result from the recommended solution. Include a description of any role, process, statute, or bargaining unit agreement affected.
The Agency HR Specialist would need to be trained to run the query from the EPM data warehouse, calculate the average bi-weekly salary in excel, and record the adjusted rate in the new field.
- Process Solutions
Describe the possible Process Solutions. Include a description of impacts and benefits of each solution.
Option 1. None identified for calculating the average salary. Create a query to select detailed pay earnings and pay other earnings data for each period within a specified begin and end date range for a specified employee. This query would be executed by Agency HR Specialists to review detailed pay check data to identify payments that should not be included in the average calculated worker’s compensation rate.
Option 2. Manually review the pay check earnings online using the pay check data pages.
- Application Modifications
Describe the possible Application Modifications. Include a description of impacts and benefits of each solution.
Option 1.
Modification Type (On-line, Batch, Interface, Report, Workflow): On-line
Complexity (Easy, Medium, Difficult): Medium
Description: Add a page and record to store the average bi-weekly salary. The record needs to be effective dated, so that if the rate changes due to a collective bargaining increase or annual increase, the history of the rates is available. The original rate is often used during a final settlement. The average salary will be manually calculated outside the system based on a custom query from the EPM data warehouse. The query results will be run to excel and the average bi-weekly salary computed. The EPM data warehouse will include payroll history 4 years as of the HRMS implementation date and be available upon HRMS implementation.
1 of 210/03/18