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

AAP Promotions Report

edited Sep 20, 2024 12:56PM in Reporting and Analytics for HCM 2 comments

Summary:

We have a requirement to report on employee promotions. This report should export on one line what their previous job/position was, and what their new/current position is. The problem we're running into is that the report is not getting the correct history. Right now the report is only looking at the top two records on employees' HR records. So, if an employee has additional activity on top of the promotion, it does not populate on the report. I think I have gotten close with some logical SQL to build this export, but I can't quite

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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