Employee department Change

I have an Employee details module which includes ( Code, Name, Start date, Leave date, Salary, etc.).

There is one more module where the monthly employee salary is shown and we get the salary detail until the employee is employed. I have made a process where the employee has changed departments on a certain date. For example, employee "ABC" transferred from the Sales to the Production department on August 1, 2020. Therefore, until August 2020, the salary will be reflected in Sales, and after the transfer, it will start showing in Production for the "ABC". For this to achieve, I have added the same employee with a different employee ID in the other department and in the new department I want the Start Date to be the Leave Date from the previous department, but I couldn't copy the date using formulas. How can I achieve this?

Thanks in advance for the help!

Accepted answers

Vinay VaradarajM

@SoumyadipKuila : In my opinion, the employee ID should remain the same as long as the employee is in continuous service with the organization. One of the ways to manage change in dept could be to have departments as a child of employee, and have the employee details (like start date, leave date etc.) as properties.

However, if this is just an exercise for learning, you might want to create a mapping as shown below, and use this in the lookup to bring the Eff Start Date (to be the Leave date corresponding to previous ID)

Screenshot 2023-07-21 at 12.30.03 PM.png

Screenshot 2023-07-21 at 12.32.09 PM.png

regards,

vinayvm

Vinay VaradarajM

Hi @SoumyadipKuila ,

The mapping will need to be a data entry upon the event talking place (i.e., change of dept), hence you cannot have a formula there. Also, the new and old emp-ID will not be always consecutive (i.e., new employee ID could be anything depending on the total number of employees, whereas the earlier ID was Emp-1)

regards,

vinayvm

All comments

Vinay VaradarajM

regards,

vinayvm

SoumyadipKuila

@vinayvm

This works, thank you!

And can you help me with one more thing?

In the Emp-ID mapping module, I would want to use a formula for the Previous ID so that it automatically selects the previous ID.

Vinay VaradarajM

Hi @SoumyadipKuila ,

regards,

vinayvm

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…