For more information, please refer to this announcement explaining best practices for getting answers to questions.
Need to fetch working days based on assignment changes of specific job
Summary:
Let's assume Employee has 3 assignments.
Person Number 103
Assignments: E103, E103-2, E103-3
Example: For Assignment E103
Assignment Action: Hire
Assignment Start Date = 1-Jan-2023
Assignment End Date = 5-Mar-2023
Job Name: TEST_2
Assignment Action: Job Change
Assignment Start Date = 6-Mar-2023
Assignment End Date = 10-Mar-2023
Job Name: TEST_1
Assignment Action: Job Change
Assignment Start Date = 11-Mar-2023
Assignment End Date = 15-Mar-2023
Job Name: TEST_2
Assignment Action: Job Change
Assignment Start Date = 16-Mar-2023
Assignment End Date = 25-Mar-2023
Job Name: TEST_1
Assignment Action: Job Change
Assignment Start Date = 25-Mar-2023
Assignment End Date = 31-Dec-4712 (System End Date)
Job Name: TEST_2
Now I have Monthly Payroll for Pay Period (1-Mar-2023 to 31-Mar-2023),