Query to find recent payroll action — 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

Query to find recent payroll action

edited Sep 19, 2019 4:53AM in Reporting and Analytics for HCM 1 comment

Summary

Query to find recent payroll action

Content

For a particular employee, on the same day, they have processed payroll actions such as "Regular Normal" once and "Process separately" twice. Is anyone aware of how I can get the last payroll action that happened. In my sample, Process separately only happened at last, so I want my query to return the last processed process separately action only.

 

I was able to display the expected process separately action by sorting the Payroll rel action ID column in descending, the latest payroll action was at top when i sorted the payroll rel action id in descending, but I would like to confirm if this is right or any other approach is available in SQL to find the recent payroll action

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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