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 MERGE_REQUEST_EXPIRATION_SCHEDULE= “*/20 * * * *”).

2. After starting it gets value from global parameter PERSON_TO_PREPERSON_ MERGE_REQUEST_TTLEXPIRATION_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() - PERSON_TO_PREPERSON_ MERGE_REQUEST_TTLEXPIRATION_MINUTES. Then skip the record

   2. If inserted_at = < current_datetime() - PERSON_TO_PREPERSON_ MERGE_REQUEST_TTLEXPIRATION_MINUTES. Then update entry:

      1. set status = EXPIRED

      2. set updated_at = current_datetime()

      3. set updated_by = system_user()

...