Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

FHIR description

...

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

(thumbs up)