Whenever you apply for leave for to_date <= today , relevant Attendance Record with status “On Leave” gets created.
Normally when user applies for future date planed leaves and gets approval.
At present , since attendance record for future dates are not allowed, hence for such leave application no relevant attendance record gets created. There is no daily night script provision to create attendance records for the leave application.
Note : Payroll is processed based on leave application only. At present it is not linked with attendance records.
What was the purpose to have the link between leave application and attendance record ?
What should be the design solution for approved leave application of future dates ?
a) should a daily night script should run at 00:05 hours to create attendance record for yesterday for an approved leave record having to_date() <=today().