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

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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.

Query help needed to determine duration in job code, title, pay grade

edited Oct 30, 2020 7:04PM in Reporting and Analytics for HCM 5 comments

Summary

Query generates a list of the job code, title and paygrade combinations for an employee with start and end dates

Content

Hi All,

I have seen several queries regarding the current and previous values and those have gotten me close to what I needed but not completely.

I am creating a report that shows an employees current job code, title and pay grade with the effective date and how long they have been in the combination. I also need to display the previous information.

The flaw that I seem to be hitting with any current and previous reports is that the "Previous" information may be the same as the current information because of a different transaction.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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