Connection between Leave Application and Attendance

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.

My Queries

  1. What was the purpose to have the link between leave application and attendance record ?

  2. 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().
or
b) ?

What was the purpose to have the link between leave application and attendance record ?

It shouldn’t. be that Employee is marked as Present and also Leave Application existing for it. If there is an Attendance Record as Absent, the Leave application is submitted just fine.

What should be the design solution for approved leave application of future dates?

Best of my knowledge, for future date, Attendance is not validated. If it is getting, can you share more details?