State of Connecticut

Core-CT Project

Application:HRMS

Module:Payroll

Business Process:Maintain Payroll Data

Requirement Number:PY056

Requirement Title:Ability to interface general deductions into PeopleSoft

Module Leads: Nancy Ribes, Josh Woodrum

  1. Requirement Description

Currently, a large number of deductions are managed by third party vendors. These vendors determine the deduction amount for the employee and then interface the employee general deduction information into the legacy system. There is no general deduction data entry at the agency level or at central payroll for these deductions. Central Payroll is ultimately responsible for these general deductions that are loaded via an interface. PeopleSoft allows for the data entry of general deduction data, but does not have a process that would load general deductions into the general deduction tables.

  1. Business Need

In the State’s current legacy system approximately 15 different vendors send deductions for approximately 30,000 employees on a biweekly basis. These deductions are managed and loaded into the legacy system by third party vendors. The State does not currently have the responsibility of determining the employee deduction. Currently, there is no future PeopleSoft release that would provide this functionality.

  1. Required By: (Y/N)

Federal __N__Agency ___N_Bargaining Unit _N___

State Statutory _N___State Regulatory __N__State Procedural _N___

  1. Requirement Priority

_High_(High, Medium, Low – please see “Requirements Prioritization Criteria”)

  1. Recommended Solution

Enter an “X” next to the appropriate category

______Process Solution

___Option Number

___X___Application Modification

__1_Option Number

  1. Explanation for Recommendation

Provide reasons for recommendation. Please do not re-state the description of the solution itself.

Due to the large volume of deductions and changes that would need to be manually entered by the State, the elimination of the vendor deduction loads would have a significant impact on Central Payroll and the time in which it took to maintain each employee’s information.

  1. 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.

Central Payroll would be responsible for capturing and loading the general deduction files into the State’s instance of PeopleSoft.

  1. Process Solutions

Describe the possible Process Solutions. Include a description of impacts and benefits of each solution.

Option 1. Manually enter general deductions sent by the vendor into PeopleSoft. The vendors would continue to send a file to the State detailing employee general deduction information. The State would then be responsible for retrieving these files and Central Payroll would then need to manually key the employee general deduction information into the general deduction pages.

  1. 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): Interface

Complexity (Easy, Medium, Difficult): Difficult

Description: A batch interface would need to be built that would accept and load any employee deduction additions, changes, and terminations into the employee general deduction record. In addition the agencies should not have the ability to override these deductions. Therefore, to complete this modification the general deduction page should be grayed out if the deduction code was loaded via an inbound interface. Since Central Payroll needs the ability to make corrections, an error file would need to be generated from the interface program for transactions that did not load or for transactions that need to be corrected. The Central Payroll Specialist will then need to have the ability to edit the file and load it into the general deductions table.

1 of 210/27/18