Purpose: This page describes dates (periods) in Medication request.
DM:
[medication_requests] id | uuid | not null ... created_at | date | not null started_at | date| not null ended_at | date| not null dispense_valid_from | date| not null dispense_valid_to | date| not null ... inserted_at | timestamp | not null updated_at | timestamp | not null
Description:
- created_at: Medication request creation date, which is determined by the external system. Format DATE '2017-09-07'. created_at = today
- started_at: Start date of a treatment period, which is determined by the external system. Greater or equal to created_at. Format DATE '2017-09-07'
- ended_at: End date of a treatment period, which is determined by the external system. Greater or equal to started_at. Format DATE '2017-10-07'
Note:
You can't create Medication Request for innm_dosge in case there is another Medication Request with the same medication in this period (between started_at and ended_at)
Note:
In case Medication Request for innm_dosge already exists next Medication Request can be done in
- if (ended_at - started_at) => 21 days then
NEW created_at >= (ended at) - 7 days
- if (ended_at - started_at) < 21 days then
NEW created_at >= max((ended_at) - 3 days, previous created_at+1)
- dispense_valid_from: Start date of dispense period, which is determined by the internal system, not-manageable attribute by API. dispense_valid_from = created_at. Format DATE '2017-09-07'
- dispense_valid_to: End date of dispense period, which is determined by the internal system, not-manageable attribute by API. dispensed_valid_to = dispensed_valid_from + 30 days. Format DATE '2017-10-07'
Note:
Dispense of Medications under this Medication Request is possible in period between dispense_valid_from and dispense_valid_to
- inserted_at: Internal(system) not-manageable attributes by API. Format TIMESTAMP '2017-09-07 07:09:55.540635'
- updated_at: Internal(system) not-manageable attributes by API. Format TIMESTAMP '2017-09-07 07:09:55.540635'