Data of ANC_PER_ABS_ENTRY_DTLS table is inconsistent
We have a requirement where a custom BI report used to extract the annual accrual entitlement for the Absence Plan called Wellness Days. The report is run annually. The logic for Wellness Days accruals is based on the number of Sick Leave Absences taken throughout the year. Employees who have taken more than 3 days of Sick Leave are not entitled to Wellness Days whereas Employees whose Sick Leave is 3 days or less are entitled to Wellness Days.
But for some the cases where Sick leave over lapping between two years then absence duration not calculating currently.
Instead of ANC_PER_ABS_ENTRIES, we supposed to use ANC_PER_ABS_ENTRY_DTLS to calculate the duration.