Page Comparison

...

Purpose

This procedure (Automatic automatic schedule task) is designed to expire previously created Medication request request Request after lifetime ends in lifetime ends in status='NEW'.

Process configuration

...

Job logic

...

1. Read MEDICATION_REQUEST_REQUEST_EXPIRATION parameter EXPIRATION parameter value.

2. Fetch records from `medication_request_requests`, where:

   1. status = 'NEW'

   2. inserted_at < NOW() -

    MEDICATION

   1.  MEDICATION_REQUEST_REQUEST_EXPIRATION

3. Update

   (Set values) Medication request Request

   status for all records:

   1. status  =  EXPIRED

   2. updated_by =

       SYSTEM

       SYSTEM_USER

   3. updated_at = timestamp