[AUTO] Terminate Medication Request

Purpose

This procedure is designed to expire previously created Request for Medication request after ended time-life in ACTIVE status.

Parameter	Description	Value
MEDICATION_REQUEST_SCHEDULE	(Cron Format) How often to perform termination	`* * * * *`

Get list Medication request

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

Update (Set values) Medication request
1. status = EXPIRED
2. updated_by = SYSTEM_USER
3. updated_at = timestamp