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.

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: – active: The prescription is ‘actionable’, but not all actions that are implied by it have occurred yet. – on-hold: Actions implied by the prescription are to be temporarily halted, but are expected to continue later. – cancelled: The prescription has been withdrawn by the prescriber and is no longer ‘actionable’. – completed: All actions that are implied by the prescription have occurred. – entered-in-error: The prescription was entered in error and should not be considered valid. – stopped: Actions implied by the prescription have been permanently halted, before all of them occurred. – draft: The prescription is not yet ‘actionable’, e.g., it is a work in progress. – unknown: 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