Skip to main content
A medication administration record represents the actual administration of a medication to a patient. This includes details about when, how, and by whom the medication was administered. Reference Table: The medication_administration_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
For detailed information about reference table structure and indexing, see the Reference Tables documentation. Medication Administration Table: Primary Keys:
  • medication_administration_id
Foreign Keys:
  • patient_id
  • medication_id
ColumnData TypeDescription
medication_administration_idvarcharUnique identifier for the medication administration
patient_idvarcharUnique identifier for the patient
medication_idvarcharUnique identifier for the medication
statusvarcharStatus of the medication administration. Possible values:
in-progress: The administration has started but has not yet completed.
not-done: The administration was expected to happen but did not occur.
on-hold: The administration was paused but may be resumed.
completed: The administration has finished (either completely or with a dose that was not fully given).
entered-in-error: This administration record should not be considered (was created in error).
stopped: The administration was terminated prior to completion.
unknown: The current status is unknown.
effective_datedateStart date of the medication administration
end_datedateEnd date of the medication administration
dose_unitvarcharUnit of measurement for the dose
dose_amountvarcharAmount of medication administered
note_textvarcharAdditional notes about the administration
data_sourcevarcharSource of the medication administration data