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

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 4 Next »

Status

  • Specification DONE
  • Apiary DONE

Purpose

This procedure (Automatic schedule task) is designed to expire previously created Medication request Request after ended time-life in NEW status.

Procedure logic for transition

  1. For info - status charts: Medication request Request Status Chart
  2. Get list Medication request 

    SELECT * FROM medication_request_requests RMR
    	WHERE RMR.status == NEW 
    		AND RMR.expired_at <= current_date()
  3. Update (Set values) Request for Medication request
    1. status  =  EXPIRED
    2. updated_by = user_id
    3. updated_at = timestamp
  • No labels