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
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

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

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!