Skip to Content
Technical Articles
Author's profile photo Xavier Le Garrec

Managing employees rehired during the same fiscal year than Termination in Variable Pay


In this 30 minutes recording we look at how to handle the following requirement in Variable Pay : for employees who were rehired only a few weeks or months after they left the company only use the active record(s) after the Rehire event to calculate a prorated bonus for them.

It took about 40 hours of work to conceptualize and build to meet the requirements of a customer in Retail that has 1,500 employees that terminate and get rehired a few weeks/months later every fiscal year.



It is not easy to build in Variable Pay because :

  1. Nothing differentiate the Active record(s) before Termination from the Active record(s) after Termination.
  2. There are no business rule functions that allow us to scan through Job Info in a way that is compatible with business rule type = “Variable Pay Eligibility” which we must use to retrieve EC records within the fiscal year dates.



This recording explains the following :

  1. The creation of an effective dated custom object (MDF) compatible with Variable Pay record rules.
  2. The creation of 2 integration center jobs (with hardcoded effectiveStartDate set to 1/1/1970)  that will populate a “Termination Date” custom field of the MDF upon termination and that will not override that date after Rehire so it can be used in our records eligibility rules.
  3. How to run an adhoc report and load its data into a custom MDF object.


Please note : in the recording I use a fixed date for the integration center jobs of 1/1/2021 which created issues towards the end of the recording when I tested my setup because my test user’s active record before Termination hadn’t changed since 2020. For that reason we should be using 1/1/1970 (1970-01-01T00:00:00Z) or any other date old enough that it can also capture employees who have had no change in job information in a long time.




All the best,



(If you found this blog useful please consider giving it a Like)

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo mridul sharma
      mridul sharma

      Thanks a lot for always posting value addition information for us

      Author's profile photo swagatika panda
      swagatika panda

      Thank you so much @xavierlegarrec for sharing.


      A thought - Can we delete the first active record from the History file for the 'Same Year Rehired' employee. This way only that Active period will be considered which is after the REHIRE. Then calculate bonus and launch form.

      Do you see any limitation in this approach ?




      Author's profile photo Xavier Le Garrec
      Xavier Le Garrec
      Blog Post Author

      Hi swagatika panda

      Yes that works but in my case the customer in retail had about 2,000 employees in this situation every year so they (understandably) didn't want to have to do this and wanted it all automated.

      All the best