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

SQL to fetch only the future dated employment changes includes salary changes, Work data changes, T

edited Jun 13, 2021 5:24PM in Human Capital Management 2 comments

Summary

SQL to fetch only the future dated employment changes includes salary changes, Work data changes, Terminations from the system run date.

Content

Hi Team,

I am looking for a SQL that could fetch all the future dated employment records changes in HCM Cloud.

SQL should fetch all the below transactions committed in the database with the future effective start date.

  • Transfer
  • Global Transfer
  • Change Manager
  • Working Hours Change
  • Change Assignment
  • Terminations
  • Salary Changes

and any other employment related transactions with the future effective start date from the system date.

Please share if you have any references/SQL that could help to fetch the above details.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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