medicationadministration

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:

• medicationadministration – Main medication administration record (this page)
• medicationadministration_dosage_route_coding
• medicationadministration_extension
• medicationadministration_extension_vcc_coding
• medicationadministration_references – Normalized references; see Reference Tables

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}

Column	Data Type	Description
medicationadministration_id	varchar	Unique identifier for the medication administration
patient_id	varchar	Unique identifier for the patient (subject)
medication_id	varchar	Reference to the medication administered
status	varchar	Status of the administration (e.g. completed, in-progress)
effectivedatetime	datetime	Effective date/time if provided directly
effectiveperiod_start	datetime	Start of effective period
effective_date†	datetime	Coalesced effective date (effectivedatetime or effectiveperiod_start)
effectiveperiod_end	datetime	End of effective period
dosage_dose_unit	varchar	Unit of measurement for the dose
dosage_dose_value	varchar	Amount of medication administered
dosage_ratequantity_unit	varchar	Unit for the infusion rate quantity
dosage_ratequantity_value	varchar	Infusion rate quantity value
dosage_route_text	varchar	Free-text route of administration
note_text†	varchar	Additional notes about the administration (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:

• medicationadministration_dosage_route_coding
• medicationadministration_extension

Version diff

Renamed

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