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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Query to Pull Reported Time and Absences Entered on a Timecard
We have requirement to list time entered on timecards in a report, the output needs to match the exact name of what's been displayed and entered in Timecard.
For instance, employee enters 8 hours of Regular, the report needs to be display 8 hours of regular rather than 8 hours of Reg base pay element.
With our custom SQL we are able to pull reported time underlying element used on layout sets, not the display of the timecard Element or absence type used.
If you anyone have insights or SQL on pulling display value and entered time that would be great.
0