Skip to main content
Describes the event of a patient consuming or otherwise being administered a medication. This may be as simple as swallowing a tablet or it may be a long running infusion. See the HL7 FHIR R4 spec for full details. Previous version: medication_administration Tables in this resource: Reference Table: The medicationadministration_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
  • reasonReference: links to condition or other clinical resource per reference_type
For detailed information about reference table structure and indexing, see the Reference Tables documentation. Primary Keys:
  • medicationadministration_id
Foreign Keys:
  • patient_id – links to the patient table (subject)
  • medication_id – links to the medication table
† Metriport Platform added
ColumnData TypeDescription
medicationadministration_idvarcharUnique identifier for the medication administration
patient_idvarcharUnique identifier for the patient (subject)
medication_idvarcharReference to the medication administered
statusvarcharStatus of the administration (e.g. completed, in-progress)
effectivedatetimedatetimeEffective date/time if provided directly
effectiveperiod_startdatetimeStart of effective period
effective_date†datetimeCoalesced effective date (effectivedatetime or effectiveperiod_start)
effectiveperiod_enddatetimeEnd of effective period
dosage_dose_unitvarcharUnit of measurement for the dose
dosage_dose_valuevarcharAmount of medication administered
dosage_ratequantity_unitvarcharUnit for the infusion rate quantity
dosage_ratequantity_valuevarcharInfusion rate quantity value
dosage_route_textvarcharFree-text route of administration
note_text†varcharAdditional notes about the administration (first note)
meta_sourcevarcharSource document filename from FHIR meta.source
data_source_ext†varcharIntegration source derived from FHIR extension
Related Tables: Parent: Child:

​
Version diff

Renamed
  • medication_administration_id → medicationadministration_id
  • end_date → effectiveperiod_end
  • data_source → meta_source