ЕСОЗ - публічна документація

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Purpose

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


Procedure logic for transition

  1. For info - status charts: Request_for_medication_request

  2. Get list Request for Medication request 

    SELECT * FROM requests_for_medication_request RMR
        WHERE RMR.status == NEW
            AND RMR.expiry_to <= current_date()

  3. Update (Set values) Request for Medication request
    1. status  =  EXPIRED
    2. updated_by = user_id
    3. updated_at = timestamp
  • No labels

ЕСОЗ - публічна документація