Page Comparison

...

...

...

...

Purpose

This procedure job is designed to expire previously created Request for Medication request after ended time-life in ACTIVE statusMedication requests. All active medication requests where dispense_valid_to in the past must be expired.

Process configuration

...

Job logic

...

Get list Medication request 

SELECT * FROM medication_requests MR
    WHERE MR.status == ACTIVE
        AND MR.ended_at <= current_date()

...

1. Fetch records from `medication_requests`, where:

   1. status = 'ACTIVE'

   2. dispense_valid_to < NOW()

2. Update status for all records:

   1. status  =  EXPIRED

   2. updated_by =

...

1. 1.  SYSTEM_USER

   2. updated_at = timestamp

2. Write changes to audit log

3. Write changes to event manager

4. if the medication 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 )