State of Connecticut
Core-CT Project
Application: HRMS
Module: Time & Labor
Business Process: Schedule Employee Time
Requirement Number: TL054
Requirement Title: Ability to create and manage schedules that are both rotating and averaging
Module Leads: Lee Stolzman, Judd Nielson
1. Requirement Description
Describe the requirement (gap). Include a description of the delivered PeopleSoft functionality.
For some agencies that provide services on a 24/7 basis there are schedules in which the actual number of hours worked can vary considerably from pay period to pay period within a specific cycle of weeks. As these employees receive pay based upon the standard biweekly hours as specified by their collective bargaining agreement, there is a need to adjust their pay should they transfer or leave mid-cycle. PeopleSoft as delivered cannot calculate this adjustment
2. Business Need
Provide a justification for the requirement. Include information about frequency, volume, number of users impacted, etc.
The majority of rotating and averaging schedules in use within the State can be accommodated by PeopleSoft as delivered. This is due to the fact that the variance between the actual hours worked in a pay period and the standard hours on which bi-weekly pay is based is insignificant. Consequently no adjustments to pay are needed. This is true of both Correction Officers and State Troopers. However, health care workers such as those covered by the New England Health Care Employees Union District 1199, can work rotating and averaging schedules in which there is a significant variance from pay period to pay period between the actual hours worked and the standard bi-weekly hours on which pay is based. In this case pay is based on 70 hours bi-weekly while scheduled hours can be 80, 72, or 64.
3. Required By: (Y/N)
Federal ____ Agency Y____ Bargaining Unit Y____
State Statutory ____ State Regulatory ____ State Procedural ____
4. Requirement Priority
High______(High, Medium, Low – please see “Requirements Prioritization Criteria”)
5. Recommended Solution
Enter an “X” next to the appropriate category
X______Process Solution
1___ Option Number
______Application Modification
___ Option Number
6. Explanation for Recommendation
Provide reasons for recommendation. Please do not re-state the description of the solution itself.
The legacy systems do not provide this adjustment calculation. It is done manually outside of the system
7. 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.
As there is no change to the current process there should be no organizational impact.
8. Process Solutions
Describe the possible Process Solutions. Include a description of impacts and benefits of each solution.
Option 1. Continue to calculate any adjustments to pay that may be necessary outside of the system.
9. Application Modifications
Describe the possible Application Modifications. Include a description of impacts and benefits of each solution.
Option 1.
Modification Type: Batch
Complexity: Medium
Description: Use a batch program that selects employees who transfer in/out of select bargaining units (Health Care) or whose schedules change during their scheduled 8 week assignment. Once selected this program will determine the proper adjustments to be made based on the transfer date and the total hours worked to that point. Since this process would only be necessary when employees terminate or transfer the idea of creating a program to satisfy a small number of employees would not be recommended. For all other employees (those who don’t terminate or transfer) rules will be created to identify when employees do not meet the required number of hours in an 8 week period.
1 of 2 11/08/01