Medication

Schema documentation for the Medication table in the Metriport data model

A medication resource is used for the identification and definition of a medication for the purposes of prescribing, dispensing, and administering a medication as well as for making statements about medication use.

Primary Keys:

• medication_id

Column	Data Type	Description
medication_id	varchar	Unique identifier for the medication
status	varchar	Status of the medication. Possible values: – active: The medication is currently in use. – inactive: The medication is not currently in use. – entered-in-error: The medication record was entered in error. Refer to HL7 FHIR Medication Status for more details.
rxnorm_code	varchar	RxNorm code for the medication
rxnorm_display	varchar	Human-readable description from RxNorm
ndc_code	varchar	National Drug Code for the medication
ndc_display	varchar	Human-readable description from NDC
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

Related Tables:

• Medication Administration - Records of medication administration
• Medication Dispense - Records of medication dispensing
• Medication Request - Records of medication requests
• Medication Statement - Records of medication statements