Looking to update status of the Master table Automatically.

Hi,

I have a database table called "Status" along with a CDT in Appian with the below list of values.

Also, I have an employee table with statuskey reference along with a CDT and while adding an employee using employee - add interface, I am saving the status as "1" (default). Also employee table is having loggedInDate.

statuskey status

1              Active

2              Inactive

3              Terminate

Can someone suggest what need to be done if I have to implement below requirement.

I have to mark the employee as “Terminate” if the employee is in inactive status for 30 days.

I have to mark the employee as “Inactive” if the employee is in active status for 15 days but not logged in(By looking into loggedInDate.