Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Parameter

Description

Value

PERSON_REQUEST_AUTOTERMINATION_SCHEDULE

(Cron Format) How often to perform termination

`* * * * *`

PERSON_REQUEST_EXPIRATION

(Days, integer > 0) Person request lifetime

10

Specification

Search candidates

  1. Read PERSON_REQUEST_EXPIRATION parameter value

  1. Fetch records from 

IL.PERSON_REQUEST

  • status = 'NEW'

  • inserted_at < now()

    • PERSON_REQUEST_EXPIRATION

...

prm.global_parameters.person_request_expiration

PEROSN_REQUEST_AUTOTCLEANING_SCHEDULE

(Cron Format) How often to perform termination

`* * * * *`

PERSON_REQUEST_DATA_CLEANING

(Days, integer > 0) Person request data lifetime

prm.global_parameters.person_request_autocleaning


Expiration person request

Search candidates

  1. If person_request.inserted_at < ( now() - PERSON_REQUEST_EXPIRATION) and status = 'NEW' or 'APPROVED`

Update person request

  1. Delete personal data from person requests: data, authentication_method_current,mpi_id, printout_form, documents, tax_id, first_name, last_name, birth_date, person_documents.

  2. Update status for all records to EXPIRED:

  • status = 'EXPIRED'

  • updated_at = now()

  • updated_by = SYSTEM_USER

Autocleaning person request

If person_request.inserted_at < ( now() - PERSON_REQUEST_DATA_CLEANING) and data is not NULL:

  1. Delete personal data from person requests: data, authentication_method_current,mpi_id, printout_form, documents, tax_id, first_name, last_name, birth_date, person_documents.

  2. update declaration_requests

  • updated_by = SYSTEM_USER

  • updated_at = timestamp