[AUTO] Terminate Medication request Request

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

4. if the medication request request is based on the activity with quantity:

   1. Recalculate and set remaining_quantity for the activity as described at Create Medication Request: Validate based_on (p. 2.d.1 ) and do not include current MRR in the calculation in case when calculation was before MRR changed status