Purpose

This job limit the time of request being in status NEW. 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 by default (configured parameter PREPERSON_MERGE_REQUEST_SCHEDULE).

2. After starting it gets value from global parameter PREPERSON_MERGE_REQUEST_EXPIRATION.

3. Select all entries from mpi.merge_person_preperson_request with status=NEW:

   1. If inserted_at > current_datetime() - PREPERSON_MERGE_REQUEST_EXPIRATION. Then skip the record

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

      1. set status = EXPIRED

      2. set updated_at = current_datetime()

      3. set updated_by = system_user()