Configuration
Process configuration
Parameter | Description | Value |
|---|---|---|
PERSON_REQUEST_SCHEDULE | (Cron Format) How often to perform termination | `* * * * *` |
PERSON_REQUEST_EXPIRATION | (Days, integer > 0) Person request lifetime | 10 |
Specification
Search candidates
Read PERSON_REQUEST_EXPIRATION parameter value
Fetch records from
IL.PERSON_REQUEST
status = 'NEW'
inserted_at < now()
PERSON_REQUEST_EXPIRATION
Change status
Update status for all records to EXPIRED:
status = 'EXPIRED'
updated_at = now()
updated_by = SYSTEM_USER