HCM Extract - Payroll balance UE - YTD values

Summary

HCM Extract - Payroll balance UE - Payroll relationship start date

Content

Hello Experts, we have a little complex requirement to fetch the payroll balance details. Let me try to explain the requirement vs issue that I'm facing.

Payroll balance UE: PAY_INTERFACE_PAYROLL_REL_UE

1. We need to extract YTD hours worked for a person.

2. When you fetch the YTD value, we need to get the hours only for the period where associate did not have a break (termination period) not more than 30 days.

Example: 

Associate A:

Work relationship period: 01/01/2020 - 05/10/2020 - Hours worked for this period 250 hours