ЕСОЗ - публічна документація
Medication dispense data model
- Dmytro Kulibaba (Unlicensed)
- Oleksandr Zhuk (SoE eHealth)
FHIR description
Schema
Source
eHealth description
Medication dispense
Table name: medication_dispenses
Name | Type | M/O | Description and constraints | HL7 vs eHealth comparison result (v4.3.0) |
|---|---|---|---|---|
id | uuid | M | System identifier of the Medication dispense | Ok |
medication_request_id | uuid | M | Medication request identifier | Doesn't comply with FHIR |
dispensed_at | date | M | Processing date, which is determined by the external system | Doesn't comply with FHIR |
party_id | uuid | M | Party identifier | Doesn't comply with FHIR |
legal_entity_id | uuid | M | Legal entity identifier where issued Medication dispense | Doesn't comply with FHIR |
division_id | uuid | M | Division identifier where issued Medication dispense | Doesn't comply with FHIR |
medical_program_id | uuid | O | Medical program identifier | Doesn't comply with FHIR |
payment_id | varchar(255) | O | Receipt number (not System identifier) | Doesn't comply with FHIR |
status | varchar(255) | M | Status of Medication dispense | Ok |
is_active | boolean | M | Indication of the record of Medication dispense state in table | Doesn't comply with FHIR |
inserted_by | uuid | M | User who created the Medication dispense | Doesn't comply with FHIR |
updated_by | uuid | M | The last User by who updated the Medication dispense | Doesn't comply with FHIR |
inserted_at | timestamp | M | Datetime when Medication dispense was created | Doesn't comply with FHIR |
updated_at | timestamp | M | Last Datetime when Medication dispense was updated | Doesn't comply with FHIR |
dispensed_by | varchar(255) | O | Employee identifier who processed the Medication dispense | Doesn't comply with FHIR |
payment_amount | double precision | O | Amount of money paid by Patient | Doesn't comply with FHIR |
note | varchar(1000) | O | Some notes | Ok |
Medication dispense details
Table name: medication_dispense_details
Name | Type | M/O | Description and constraints |
|---|---|---|---|
id | uuid | M | System identifier of the Medication dispense details |
medication_id | uuid | M | System identifier of the Medication |
medication_dispense_id | uuid | M | System identifier of the Medication dispense |
medication_qty | double precision | M | Amount dispensed |
sell_price | double precision | M | Price of medication |
discount_amount | double precision | M | Total reimbursement amount |
program_medication_id | double precision | O | System identifier of the Program medication |
Medication 2d codes
Table name: medication_2d_codes
Name | Type | M/O | Description and constraints |
|---|---|---|---|
id | uuid | M | System identifier of the Medication 2d code |
medication_dispense_id | uuid | M | System identifier of the Medication dispense |
medication_2d_code | varchar(255) | M | Decoded 2d code |
inserted_at | timestamp | M | Datetime when record was added |
ЕСОЗ - публічна документація