NERM Workflow to change User Status

[Shrikrishna_Saravanan]

Hi All,
I am trying to update the status of person whose assignments have ended.

1. We have two profile types called “Persons” and “Assignments”
2. So now, we check the end date of the assignment. Once the assignment has reached its end date, we go ahead and change the status of the profiles in the person profile type to inactive status.
3. Both these profiles, in person type and assignment type have the same attribute which is common in both called Employee ID.
4. For now we built a workflow where it checks the assignment end date and changes user status (One person to assignment, one to one mapping)

Workflow:

5. Now, we have a requirement, where the person profile may have more than one assignment profile at the same time. (One person to many assignments, one to many mapping)
   For eg: Assignment 1 → Start date - Jan 20, End date - Jan 28
   Assignment 2 → Start date - Jan 20, End date - Jan 30
   Note: Both assigned to same person
6. Now, we are trying to build a workflow, where it checks the assignments and

• If at least one assignment is still active, then the user will be in “Active” status,
• If both assignments reach the end date, then the profile in person profile type corresponding to the assignments will be changed to inactive status

7. We are trying to figure out how to proceed with this, since loops cannot be used here in workflows like IDN and not sure on how to leverage advanced search for this use case.

Thanks all.

[Shrikrishna_Saravanan]

I have also attached screenshots for the sub-workflow below:

Sub-Workflow :

[Shrikrishna_Saravanan]

Action 1: