Entities (tables)
Medication requests
This entity defines Medication request (terms) information structure.
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| human_receipt_id | varchar, | M | Must have special proc |
| program_type | varchar (Dictionary: PROGRAM_TYPE) | M | |
| created_at | date | M | |
| started_at | date | M | |
| ended_at | date | M | |
| dispense_valid_from | date | M | |
| dispense_valid_to | date | M | |
| person_id | uuid | ||
| employee_id | uuid | ||
| receipt_period_type | varchar (Dictionary: RECEIPT_PERIOD_TYPE) | ||
| receipt_age_type | varchar (Dictionary: RECEIPT_AGE_TYPE) | ||
| innm_id | uuid | ||
| innm_route | varchar (Dictionary: MEDICATIONS_ROUTE_TYPE) | ||
| innm_dosage | Dosage: jsonb | ||
| innm_container_dosage | Dosage: jsonb | ||
| innm_qty | number | ||
| innm_dose_used_qty | number | ||
| note | varchar ??? jsonb | ||
| dosage_instuction | varchar ??? jsonb | ||
| status | varchar (Dictionary: MEDICATION_REQUEST_STATUS) | ||
| is_active | boolean | ||
| recall_at | date | ||
| recalled_by | uuid | ||
| recall_reason | varchar | ||
| inserted_at | timestamp | M | |
| inserted_by | uuid | M | |
| updated_at | timestamp | M | |
| updated_by | uuid | M |