State of Connecticut
Core-CT Project
Application: HRMS
Module: Payroll
Business Process: Calculate & Confirm On-Cycle Payrolls
Requirement Number: PY401
Requirement Title: Ability to produce a report that details earnings, taxes & deductions for a specific payperiod or a number of payperiods sorted by employee.
Module Leads: Nancy Ribes, Josh Woodrum
1. Requirement Description
Describe the requirement (gap). Include a description of the delivered PeopleSoft functionality.
Currently the central payroll specialist and the agency payroll specialist receive inquiries from a number of different sources mainly in the form of served subpoenas requesting detailed employee information regarding earnings, taxes, deductions and net pay per pay period. These reports are typically used to determine support payments and other garnishments required by various authorities. PeopleSoft currently delivers on a quarterly basis an earnings summary record for all employees.
2. Business Need
Provide a justification for the requirement. Include information about frequency, volume, number of users impacted, etc.
Approximately 150 subpoenas are served on the State per year and 10 requests weekly from agency payroll as well as central payroll requesting copies of detailed employee earnings information for current as well as prior year earnings on a ‘from’ check date ‘to’ check date basis.
3. Required By: (Y/N)
Federal __N__ Agency __Y__ Bargaining Unit _N___
State Statutory _Y___ State Regulatory _N___ State Procedural _N___
4. Requirement Priority
__Medium__ (High, Medium, Low – please see “Requirements Prioritization Criteria”)
5. Recommended Solution
Enter an “X” next to the appropriate category
______Process Solution
___ Option Number
___X___ Application Modification
_1__ Option Number
6. Explanation for Recommendation
Provide reasons for recommendation. Please do not re-state the description of the solution itself.
The State of Connecticut is required to follow court orders in subpoena form to produce a report detailing an employee’s earnings, deductions and taxes. There is no delivered report that can produce the detail required by the necessary parameters. Based on the frequency of the requirement, the process solution would require a great deal of human effort to provide the proper information to the requesting authority.
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.
none
8. Process Solutions
Describe the possible Process Solutions. Include a description of impacts and benefits of each solution.
Option 1. The Payroll Specialist would execute the quarterly Earnings Summary (delivered to report on all employees) for each quarter relevant to the period requested. The specific employee data would need to be retrieved from each quarterly report, edited for the proper period and compiled into one report.
9. 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): Report
Complexity (Easy, Medium, Difficult): Medium
Description: Modify the existing delivered quarterly report (PAY014 – Earnings Employee Record) to run based on different parameters. These parameters on the run control would request an individual employee ID and detail would be provided for a period based on the ‘from’ and ‘to’ dates provided
1 of 2 11/27/01