medicationrequest

An order or request for both supply of the medication and the instructions for administration of the medication to a patient. See the HL7 FHIR R4 spec for full details.

Previous version: medication_request

Tables in this resource:

• medicationrequest – Main medication request record (this page)
• medicationrequest_extension
• medicationrequest_extension_vcc_coding
• medicationrequest_references – Normalized references; see Reference Tables

Reference Table:

The medicationrequest_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
• reasonReference: links to conditions or other reasons for the medication request

For detailed information about reference table structure and indexing, see the Reference Tables documentation.

Primary Keys:

• medicationrequest_id

Foreign Keys:

• patient_id – links to the patient table (subject)
• medication_id – links to the medication table

_{† Metriport Platform added}

Column	Data Type	Description
medicationrequest_id	varchar	Unique identifier for the medication request
patient_id	varchar	Unique identifier for the patient (subject)
medication_id	varchar	Reference to the requested medication
status	varchar	Status of the request (e.g. active, completed, cancelled)
authoredon	datetime	Date/time the request was authored
dosageinstruction_doseandrate_dosequantity_unit	varchar	Unit for the prescribed dose quantity
dosageinstruction_doseandrate_dosequantity_amount	varchar	Prescribed dose quantity
intent	varchar	Intent of the request (e.g. order, plan)
note_text†	varchar	Additional notes about the request (first note)
meta_source	varchar	Source document filename from FHIR meta.source
data_source_ext†	varchar	Integration source derived from FHIR extension

Related Tables:

Parent:

• medication
• patient

Child:

• medicationrequest_extension

Version diff

Renamed

• medication_request_id → medicationrequest_id
• authored_on → authoredon
• data_source → meta_source