Query to extract the last effective start date record for payroll element
Summary:
Content (required):
Hello experts,
Please, could you share the SQL query to extract the effective start date loaded for a specific element in the employee compensation history? In other words, we need to end date the last payroll element record and create a new one.
Thanks in advance for you time!
Kind Regards,
Valerio
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0