IBM Support

Using Escalations to Change Person Status

Question & Answer


Question

Is it possible to change a person's status to inactive based on a termination date using an escalation?

Answer

Yes. You can create an escalation that queries for the TERMINATIONDATE value on person records. In this case, the criteria looks for records that are currently set to ACTIVE and the TERMINATIONDATE is before the current system date. The system date format used in this example is for a SQL Server based environment. You may need to change this format depending on the database platform being used.




The action should look something like this.....




......and the change status value should look something like this......





When creating this type of escalation you may also want to add some criteria to the condition to confirm that the person is not part of a person group, assigned to open work orders or tickets as you will not be able to change the record's status to INACTIVE if that is the case.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"People","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.1;6.2;6.2.1;6.2.2;6.2.3;6.2.4;6.2.5;6.2.6;6.2.7;6.2.8;7.1;7.1.1;7.5;7.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21569798