medication_dispense_references table contains normalized references from the medication dispense to other entities. It supports the following reference properties:
- medication_reference (required): links to the medication that was dispensed
- subject (required): links to the patient who received the medication
- performer.actor: links to practitioners who performed the dispensing
- location: links to the location where the medication was dispensed
- medication_dispense_id
- patient_id
- medication_id
| Column | Data Type | Description |
|---|---|---|
| medication_dispense_id | varchar | Unique identifier for the medication dispense |
| patient_id | varchar | Unique identifier for the patient |
| medication_id | varchar | Unique identifier for the medication |
| status | varchar | Status of the medication dispense. Possible values: – preparation: The core event has not started yet, but some staging activities have begun (for example, initial preparing and labeling of medication).– in-progress: The dispensed product is being prepared and packaged.– cancelled: The dispensing event was terminated prior to any output product being created.– on-hold: The dispensing event has been temporarily halted but is expected to resume.– completed: The dispensed product has been handed over to the patient or patient representative.– entered-in-error: The dispense event was created in error and should not be considered valid.– stopped: Actions implied by the dispense event have been permanently halted, before all of them occurred.– declined: The dispense was declined and not performed.– unknown: The authoring system does not know which of the status values applies for this dispense. |
| when_handed_over | date | Date when the medication was handed over |
| when_prepared | date | Date when the medication was prepared |
| dose_unit | varchar | Unit of measurement for the dose |
| dose_amount | varchar | Amount of medication dispensed |
| days_supply_amount | varchar | Number of days the medication will last |
| days_supply_unit | varchar | Unit for days supply (typically “d”) |
| note_text | varchar | Additional notes about the dispense |
| data_source | varchar | Source of the medication dispense data |