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

Building a custom report for pay rates

Received Response
62
Views
1
Comments
edited Sep 18, 2018 4:27PM in Reporting and Analytics for HCM 1 comment

Summary

Client is using the newly released salary basis based on rates of pay. There are no OTBI subject areas and need to create a new data model.

Content

The tables holding pay rates are: 

PAY_RATE_CONTRIBUTORS_F
PAY_RATE_DEFINITIONS_F
PAY_RATE_VALUE

Client requires report with a breakdown of the individual pay rates as well as employee data.  They are unable to perform the join.  Does anyone have a prebuilt SQL or can assist?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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