Retrieve top 2 records per employee — Cloud Customer Connect
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: Oracle Cloud SCM and Purchasing

Retrieve top 2 records per employee

edited Sep 24, 2020 7:55PM in Reporting and Analytics for HCM 7 comments

Summary

Need to figure out a way to determine the top 2 records for an employee

Content

Hi All,

I am read through some posts but still haven't found a solution for what I am trying to do.

I need to create a report that shows an employees Current/Previous Job Code, Job Title, Grade

I have the query to pull in most of the data but with the transactional lines, it was pointed out that I had the incorrect previous record

The users want to see the values from the last time they were different

I am trying to build a query where I have combined the employees Person Number, Job Code, Job title, Grade with Effective Start and End Dates

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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