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

Need YTD hours for a timecard for an employee

in Reporting and Analytics for HCM

Summary:

I am working on an extract where I need to pull YTD hours worked for an employee ( basically for entire BU). How can I pull the YTD hours from timecards which are approved for a given employee/worker ? I want to pull only worked hours . I want to exclude vacation/sick/holiday hours. Can someone provide a SQL query for the same or how this can be done in OTBI.

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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