> ## 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 Request

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

A medication request record represents a request for a medication to be prescribed or administered to a patient. This includes details about the medication requested, dosing, and the practitioner making the request.

**Reference Table:**

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

* **medication\_reference** (required): links to the medication that was requested
* **subject** (required): links to the patient for whom the medication was requested
* **encounter**: links to the encounter where the request was made
* **requester**: links to the practitioner who made the request
* **reason\_reference**: links to conditions or other reasons for the medication request

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

**Medication Request Table:**

**Primary Keys:**

* medication\_request\_id

**Foreign Keys:**

* patient\_id
* medication\_id

| Column                  | Data Type | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| ----------------------- | --------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| medication\_request\_id | varchar   | Unique identifier for the medication request                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| patient\_id             | varchar   | Unique identifier for the patient                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| medication\_id          | varchar   | Unique identifier for the medication                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| status                  | varchar   | Status of the medication request. Possible values:<br />– <code>active</code>: The prescription is 'actionable', but not all actions that are implied by it have occurred yet.<br />– <code>on-hold</code>: Actions implied by the prescription are to be temporarily halted, but are expected to continue later.<br />– <code>cancelled</code>: The prescription has been withdrawn by the prescriber and is no longer 'actionable'.<br />– <code>completed</code>: All actions that are implied by the prescription have occurred.<br />– <code>entered-in-error</code>: The prescription was entered in error and should not be considered valid.<br />– <code>stopped</code>: Actions implied by the prescription have been permanently halted, before all of them occurred.<br />– <code>draft</code>: The prescription is not yet 'actionable', e.g., it is a work in progress.<br />– <code>unknown</code>: The authoring system does not know which of the status values applies for this prescription. |
| authored\_on            | date      | Date when the medication request was authored                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| dose\_unit              | varchar   | Unit of measurement for the dose                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| dose\_amount            | varchar   | Amount of medication requested                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| note\_text              | varchar   | Additional notes about the request                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| 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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |