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

Termination report with subquery

edited Oct 17, 2017 2:54PM in Reporting and Analytics for HCM 3 comments

Summary

Looking for a subquery that would eliminate currently active employees form termination report

Content

Hello,

I am trying to build a termination report for our organization that at run-time would show all currently inactive employees who were terminated 20 days ago. Currently the report pulls ALL employees who were terminated 20 days ago, even if they have been rehired since, and their current status is active - the report just pulls their historical termination record.

Does anyone know how I could build a subquery that would eliminate anyone who has been terminated 20 days ago but is currently active in the system?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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