Status
Purpose
This procedure is designed to expire previously created Request for Medication request after ended time-life in ACTIVE status.
Process configuration
Parameter | Description | Value |
|---|---|---|
| MEDICATION_REQUEST_SCHEDULE | (Cron Format) How often to perform termination | `* * * * *` |
Procedure logic for transition
- For info - status charts: Medication_request
Get list Medication request
SELECT * FROM medication_requests MR WHERE MR.status == ACTIVE AND MR.ended_at <= current_date()- Update (Set values) Medication request
- status = EXPIRED
- updated_by = SYSTEM_USER
- updated_at = timestamp