RC_Rx_[AUTO] Terminate Medication request request (modified - EN)

Purpose

This procedure (automatic schedule task) is designed to expire previously created Medication request request after lifetime ends in status='NEW'.

Process configuration

Job logic

1. Read MEDICATION_REQUEST_REQUEST_EXPIRATION parameter value

2. Fetch records from `medication_request_requests`, where:

   1. status = 'NEW'

   2. inserted_at < NOW() - MEDICATION_REQUEST_REQUEST_EXPIRATION

3. Update status for all records:

   1. status  =  EXPIRED

   2. updated_by = SYSTEM_USER

   3. updated_at = timestamp