Administration Guide › How to Perform Data Transformations › Define and Send Escalation Emails › Create and Apply Data Transformations › Delete Users with Expired Role Memberships

Delete Users with Expired Role Memberships

To ensure that managers do not certify invalid role memberships, delete users with expired role memberships based on the end date.

Follow these steps:

1. In PDI, in the Design tab, locate and expand the Flow step, select Dummy (do nothing), and drag it to the Transformation screen.
2. Create a hop between the Filter Rows step and the Dummy (do nothing) step.

   All valid links are sent to the Dummy (do nothing) step.

3. Select Text file output, and drag it to the Transformation screen.
4. Right-click the Text file output step and select Edit step.

   The Text file output window opens.

5. Under the File tab, provide a filename for the text output file.
6. Under the Fields tab, click Get Fields.
7. Delete all fields except for the following and click Ok:
   • PersonID
   • ResName1
   • ResName2
   • ResName3
   • Start Date
   • End Date
8. Create a hop between the Filter rows step and the Text file output step.

   All users with expired links are captured and sent to the Text file output.

9. On the Design tab, locate and expand the RCM Output step, select the Delete User-Resource Links step, and drag it to the Transformation screen.
10. Right-click the Delete User-Resource Links step and select Edit step.

    The !Delete User-Resource Links! window opens.

11. In the General tab, in the RCM Configuration section, map the following fields, and click Ok:
    • Person ID Field=PersonID
    • Res Name 1 Field=ResName1
    • Res Name 2 Field=ResName2
    • Res Name 3 Field=ResName3

    You have added the output steps to delete users with expired role memberships. When you run the transformation, it deletes all users with expired role memberships.