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

Building a custom report for pay rates

Received Response
41
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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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