Page Comparison

...

1. Job starts once in 24 hours by default (configured parameter).

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

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

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

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

      1. set status = EXPIRED

      2. set updated_at = current_datetime()

      3. set updated_by = system_user()