Page Comparison

Table of Contents

Purpose

This job is designed to expire previously created Medication requests. All active medication requests where dispense_valid_to in the past must be expired

...

...

1. For info - status charts: Medication_request

2. Get list Medication request 

   Code Block
   language sql
   SELECT * FROM medication_requests MR WHERE MR.status == ACTIVE AND MR.dispense_valid_to < current_date()

   
   

   
   

3. Update (Set values) Medication request
   1. status  =  EXPIRED
   2. updated_by = SYSTEM_USER
   3. updated_at = timestamp
4. Write changes to audit log
5. Write changes to event manager