Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Query to find pay period and Hours Worked, separating out PTO vs ESL vs FMLA hour groups
GaryRMLC
Rank 1 - Community Starter
Can someone please help with a Oracle Fusion SQL query to find pay period and Hours Worked, separating out PTO vs ESL vs FMLA hour groups.
I found the attached as a start but am only finding the element names of Regular Pay and Regular Pay Earnings data.
Maybe our system doesn't have anyone with PTO hours in the subset we have loaded thus far or is it somehow being excluded in the qualifications.
We are very new to HCM SQL Queries and are really struggling!
Thanks!
Tagged:
1
Answers
-
P.s. I started with the query from this post.
0