- medicationrequest – Main medication request record (this page)
- medicationrequest_extension
- medicationrequest_extension_vcc_coding
- medicationrequest_references – Normalized references; see Reference Tables
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
- medicationrequest_id
- 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 |
Version diff
Renamedmedication_request_id→medicationrequest_idauthored_on→authoredondata_source→meta_source