Number of Work Days Changed Incorrectly Resulting in Entitlement Overpayment
ISSUE: Customer states that for a particular Employee Group, whenever an Entitlement is triggered, it results in an entitlement overpayment for 7 days.
Employee Group is configured to be 224 Work Days per Year however 217 is used in the calculation.
PROCESS OVERVIEW TEST CASE
PAYROLL > GROUP DATA > BASIC GROUP DATA > EMP_GROUP
**Pay Method = 2**
NOTE: Group Record has been open since 2003.
BOARD CONTROL > GENERAL TABLES > EMPLOYEE GROUP MAINTENANCE > EMP_GROUP
**Average Work Days per Year = 224**
NOTE: Group Record has been open since 2003.
PAYROLL > GROUP DATA > PAY PERIOD CALENDAR > EMP_GROUP
**Current Pay = 202414**
PAYROLL > PAY PROCESS > SCHEDULE GROUPS > NUTF10 > PAY RUN
**SUBMITTED Sample Pay Run**
PROCESS > COMPLETED > PAY REGISTER
PAYROLL > PAY PROCESS > POST RUN > ABORT & ROLLBACK
**Submit > Completed**
STAFFING > POSITION & ASSIGNMENT > SAMPLE EID
**Active Position**
COMPENSATION > SALARY & ALLOWANCE > 2285
**Active Salary Record**
STAFFING > POSITION & ASSIGNMENT > SAMPLE EID
**Change FTE from 1 to 0.5 > Save > Change back to 1 > Save (Dummy change to trigger Entitlement)**
PAYROLL > PAY PROCESS > ENTITLEMENT > EMP_GROUP > SUBMIT > PROCESSED > COMPLETED
ROOT CAUSE ANALYSIS / STEPS TO RESOLVE
ROOT CAUSE: Number of Working Days per Year was changed multiple times within the same Employee Group Maintenance record, without End Dating the record and Duplicating to Create a new one.
IMPACT: Whenever this value is updating within the Employee Group Maintenance record, this will create a RETRO calculation in the background of the Entitlement, going back to when it was created.
The system will compare the original value with the current value, and create an Entitlement based on the difference.
select * from EC_BOARD_AUDIT
where TABLE_NAME = 'EC_GROUP'
and COLUMN_NAME = 'WORK_DAYS_PER_YEAR'
order by 6 desc
**Number of Working Days changed within the SAME Employee Group Maintenance Record**
Current Salary Adjustment Calculation:
Original Value: 217 Days Calculation
36.99 per hour * 7 hours per day * 217 days per year = 56,187.81
Current Value: 224 Calculation
36.99 per hour * 7 hours per day * 224 days per year = 58,000.32
58,000.32 – 56,187.81 = 1,812.51
**Difference between these being exactly the 1,812.51 from Entitlement**
Best Practice for Updating Employee Group Data Records
Link to Solution Article:
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article