Purpose

This job limit the time of request being in status NEW or APPROVED. It changes status of person to preperson merge requests to EXPIRED after configured period of it existance.

Job logic

1. Job starts once in 24 hours 20 min by default (configured parameter PREPERSON_ MERGE_REQUEST_EXPIRATION_SCHEDULE= “*/20 * * * *”).

2. After starting it gets value from global parameter PREPERSON_ MERGE_REQUEST_EXPIRATION_MINUTES (by default is 60 min).

3. Select all entries from mpiil.merge_person_preperson_requestrequests with status=NEW or APPROVED:

   1. If inserted_at >= current_datetime() - PREPERSON_ MERGE_REQUEST_EXPIRATION_MINUTES. Then skip the record

   2. If inserted_at = < current_datetime() - PREPERSON_ MERGE_REQUEST_EXPIRATION_MINUTES. Then update entry:

      1. set status = EXPIRED

      2. set updated_at = current_datetime()

      3. set updated_by = system_user()

...