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

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

« Previous Version 3 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

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