State of Connecticut

Core-CT Project

Application:HRMS

Module:Payroll

Business Process:Calculate & Confirm On-Cycle Payrolls

Requirement Number:PY402

Requirement Title:Ability to ViewState Specific Pay Calc Validation Errors

Module Leads: Nancy Ribes, Josh Woodrum

  1. Requirement Description

Describe the requirement (gap). Include a description of the delivered PeopleSoft functionality.

The State currently has a large number of validation processes that the paychecks must pass through before a paycheck is produced. Outside of the delivered PeopleSoft validations, the State of Connecticut has developed additional conditions that result in either warnings or rejections. Employees with warnings will be processed to completion, but a rejection will not be processed and the respective agency is responsible for correcting the errors causing the rejection. PeopleSoft is similar in that it produces both warnings and errors, but not all the validations currently made by the State are delivered in PeopleSoft to produce errors on the Payroll Error Messages Report during the Pay Calculation process.The new error messages that are added to this new SQR will also need to be added online to a custom message set of the message catalog in the PeopleSoft environment.

  1. Business Need

Provide a justification for the requirement. Include information about frequency, volume, number of users impacted, etc.

Approximately 70,000 paychecks may be processed in one pay period. The State requires certain controls at the central level to assure the agency is reporting the proper data and following State procedures and regulations. Many of the custom validations are handled by delivered functionality, but others are not. The following additional validations would be required: 1) Certain lump sum payments cannot be split into multiple pay periods for taxation purposes 2) Retirement deductions cannot be refunded. 3) A refund cannot be made in excess of YTD balances for an employee 4) UCONN employees must use a specific deduction code where the state share = 8% 5) If sick time is paid out, then vacation should also be paid out OR if vacation time is paid out, then sick time should also be paid out.

  1. Required By: (Y/N)

Federal __N__Agency __N__Bargaining Unit __N__

State Statutory _N___State Regulatory __N__State Procedural __Y__

  1. Requirement Priority

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

  1. Recommended Solution

Enter an “X” next to the appropriate category

___X___Process Solution

_1__Option Number

______Application Modification

___Option Number

  1. Explanation for Recommendation

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

The State of Connecticut currently has validations that are being performed on all employee paychecks after the Pay Calculation (Compute in Legacy) process. In order to continue to meet this requirement, there needs to be additional validation performed on these paychecks before they can continue through the payroll cycle and eventually be confirmed checks. By creating an additional batch program (SQR) to capture these additional edits, the functionality will continue to exist in the PeopleSoft system.

  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.

None.

  1. Process Solutions

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

Option 1. Queries would be created by OSC that would do the validation checks for the State. These queries would need to be run directly after each Pay Calculation.

  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): Batch and On-line

Complexity (Easy, Medium, Difficult): Medium

Description: A new SQR could be created toperform these additionally required validations and insert these messages into the pay message table after pay calculation is run. These messages could then be printed as part of the Payroll Error Messages report. If the message is a rejection then the SQR would also need to switch the employee's Payline Status = 'E' to indicate that the employee's paycheck is in error and will not be processed through pay calculation until the payroll error is fixed.The new error messages that are added to this new SQR will also need to be added online to a custom message set of the message catalog in the PeopleSoft environment.

1 of 209/13/18