Page Comparison

...

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 mpiil.merge_person_preperson_requestrequests with status=NEW or APPROVED:

   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()

      4. for APPROVED preperson merge request anonymize person data