You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query or table to get the employee work schedule as of the leave start date

Received Response
49
Views
1
Comments

Summary:

Hi Every one,

Do any one have any query to get the employee work schedule as of the Leave Start date .

The requirement is when employee applied the leave, I need to get the work schedule of the employee as of that leave start date. when ever in future if there is any change in the work schedule(retrospectively or normally) we have to pull the leave records whose work schedule is different that the one which is associated to the employee as of the leave applied date.

So for that I need to know in which table the leave records will be stores along with the corresponding work schedule associated to the employee as of that leave start date.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!