Medication Statement

Schema documentation for the Medication Statement table in the Metriport data model

A medication statement record represents a record of a medication that is being consumed by a patient. This includes details about the medication, its current status, and any relevant clinical information.

Reference Table:

The medication_statement_references table contains normalized references from the medication statement to other entities. It supports the following reference properties:

• medication_reference (required): links to the medication referenced in the statement
• subject (required): links to the patient who is taking the medication

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

Medication Statement Table:

Primary Keys:

• medication_statement_id

Foreign Keys:

• patient_id
• medication_id

Column	Data Type	Description
medication_statement_id	varchar	Unique identifier for the medication statement
patient_id	varchar	Unique identifier for the patient
medication_id	varchar	Unique identifier for the medication
status	varchar	Status of the medication statement. Possible values: – active: The medication is still being taken. – completed: The medication is no longer being taken. – entered-in-error: The statement was entered in error. – intended: The medication was intended to be taken. – stopped: The medication has been stopped. – on-hold: The medication is temporarily not being taken. – unknown: The authoring/source system does not know the status. – not-taken: The medication was not taken (this element is not used in most systems).
effective_date	date	Start date of the medication statement
end_date	date	End date of the medication statement
dose_unit	varchar	Unit of measurement for the dose
dose_amount	varchar	Amount of medication
note_text	varchar	Additional notes about the statement
meta_source	varchar	Source document filename from FHIR meta.source
data_source	varchar	Deprecated. Use meta_source instead.
data_source_ext	varchar	Integration source of the data, derived from FHIR extension