> ## Documentation Index
> Fetch the complete documentation index at: https://docs.metriport.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Medication Administration

> Schema documentation for the Medication Administration table in the Metriport data model

A medication administration record represents the actual administration of a medication to a patient. This includes details about when, how, and by whom the medication was administered.

**Reference Table:**

The `medication_administration_references` table contains normalized references from the medication administration to other entities. It supports the following reference properties:

* **medication\_reference** (required): links to the medication that was administered
* **subject** (required): links to the patient who received the medication
* **performer.actor**: links to practitioners who performed the administration

For detailed information about reference table structure and indexing, see the [Reference Tables documentation](/medical-api/handling-data/schema-v000/reference-tables).

**Medication Administration Table:**

**Primary Keys:**

* medication\_administration\_id

**Foreign Keys:**

* patient\_id
* medication\_id

| Column                         | Data Type | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| ------------------------------ | --------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| medication\_administration\_id | varchar   | Unique identifier for the medication administration                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| patient\_id                    | varchar   | Unique identifier for the patient                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| medication\_id                 | varchar   | Unique identifier for the medication                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| status                         | varchar   | Status of the medication administration. Possible values:<br />– <code>in-progress</code>: The administration has started but has not yet completed.<br />– <code>not-done</code>: The administration was expected to happen but did not occur.<br />– <code>on-hold</code>: The administration was paused but may be resumed.<br />– <code>completed</code>: The administration has finished (either completely or with a dose that was not fully given).<br />– <code>entered-in-error</code>: This administration record should not be considered (was created in error).<br />– <code>stopped</code>: The administration was terminated prior to completion.<br />– <code>unknown</code>: The current status is unknown. |
| effective\_date                | date      | Start date of the medication administration                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| end\_date                      | date      | End date of the medication administration                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| dose\_unit                     | varchar   | Unit of measurement for the dose                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| dose\_amount                   | varchar   | Amount of medication administered                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| note\_text                     | varchar   | Additional notes about the administration                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| meta\_source                   | varchar   | Source document filename from FHIR meta.source                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| data\_source                   | varchar   | **Deprecated.** Use `meta_source` instead.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| data\_source\_ext              | varchar   | Integration source of the data, derived from FHIR extension                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |