Dates & periods in Medication request

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'.
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_dosage in case there is another Medication Request with the same INNM in this period (between started_at and ended_at)

Config parameters:

mrr_delay_input = 3
mrr_standart_duration = 21
min_mrr_renew_days = 3
max_mrr_renew_days= 7

Note:

Fetch Medication Request by innm, program_id, person_id and max(end_date) in status (ACTIVE, COMPLETED). In case there is such Medication Request with ended_at>=current_date then next one can be done in

if (ended_at - started_at) => mrr_standart_duration then
- NEW created_at >= ended at - max_mrr_renew_days and
- NEW created_at >= current_day
if (ended_at - started_at) < mrr_standart_duration then
- NEW created_at >= ended_at - min_mrr_renew_days and
- NEW created_at >=current_day

Config parameters:

dispense_period = 30

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 + dispense_period. 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'