Hello team.
we have the following requirement:
The job info and compensation portlet need to be updated automatically for unionized employees.
The compensation portlet must be updated with the next pay scale level.
These are the conditions:
The employee must have been working in the company for 3 months.
The employee must have completed the mandatory courses for newly hired employees, this information is in a custom portlet.
Unionized employees are identified by Employee Class and Employment type.
We need to create an integration that runs every Friday to update the job information and compensation portlet for eligible employees.
The company has around 25000 employees
Example:
The hire date of employee 9999 is 02-01-2024 (This information is in employment details)
This is the information in the job information portlet.
Start date: 02-01-2024.
Salary structure
Pay scale type. 01
Pay scale area. 01
Pay scale group. 01
Pay scale level. 01
This is the information in the compensation portlet.
Start date: 02-01-2024.
Payroll area: AA
Pay component Amount Currency Frequency
1000 300 MXN Daily
This is the salary structure defined for the company.
Pay scale type | Pay scale area | Pay scale group | Pay scale level | Amount |
01 | 01 | 01 | 01 | 300 |
01 | 01 | 01 | 02 | 500 |
01 | 01 | 01 | 03 | 700 |
This is the information in the course portlet (custom portlet)
Strat date 02-01-2024
Course 1: Completed
Course 2: Completed
We are going to schedule a job; this job will be executed every Friday
The job is executed on Friday, May 3
On this date the employee has been in the company for 3 months. (first condition OK)
On this date, the employee has already completed the mandatory courses. (Second condition OK).
If the employee has an incomplete course, the employee will not be eligible and on the next run (May 10), the job will need to check if the employee already has the courses completed.
In this example the employee is eligible
A new record must be created in the job information portlet as follows.
Start date: 06-03-2024.
Salary structure
Pay scale type. 01
Pay scale area. 01
Pay scale group. 01
Pay scale level. 01 02 (Next pay scale level)
A new record must be created in the compensation portlet as follows.
Start date: 06-03-2024.
Payroll area: AA
Pay component Amount Currency Frequency
1000 300 500 MXN Daily
The start date must be obtained from the pay calendar table.
The start date is the start date of the first week of the following month.
The job was executed in the month of May, so the following month is June.
This is the information in the pay calendar.
Start date End Date
05.27.2024 06.02.2024
06.03.2024 06.09.2024 this is the first week of June and the start date is 06.03.2024
06.10.2024 06.16.2024
Can I resolve this requirement with CPI or Automate pay scale reclassification?
What do you recommend?
Thanks a lot for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.