Pro-rated accrual balance not appearing in absence screen
Summary:
Pro-rated accrual balance not appearing in absence screen
Content (required):
I have a scenario as below -
IV_Accrual:1.75
Plan Enrolment Start Date:21-02-2023
Calendar Start Date:01-01-2023
Accrual Period Start date:01-04-2023
Accrual Period End Date:30-04-2023
Calendar End Date:31-12-2023
Plan Enrolment End Date:19-04-2023
Calculating Prorated accrual as below
start_date: greatest(Plan Enrolment Start Date, accrual start date) -
End_Date: least (Plan Enrolment End Date, accrual End Date) -
Duration: days between (accrual End Date, accrual Start Date) /*30, 31, 28 or 29 based on month*/
participation_duration: days between (end_date, start_date) /*no.of days employee comes into the accrual plan for that period*/
0