medication

This resource is primarily 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. See the HL7 FHIR R4 spec for full details.

Previous version: medication

Design notes: Core has no medication_references table (Medication is referenced by MedicationAdministration, MedicationDispense, etc.). The FHIR ingredient array is not modeled in core by design.

Tables in this resource:

• medication – Medication record (this page)
• medication_code_coding
• medication_extension
• medication_extension_vcc_coding

Primary Keys:

• medication_id

_{† Metriport Platform added}

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.
code_text	varchar	Free-text description of the medication
code_rxnorm_code†	varchar	RxNorm code for the medication
code_rxnorm_display†	varchar	Human-readable description from RxNorm
code_ndc_code†	varchar	National Drug Code for the medication
code_ndc_display†	varchar	Human-readable description from NDC
meta_source	varchar	Source document filename from FHIR meta.source
data_source_ext†	varchar	Integration source of the data, derived from FHIR extension

Related Tables:

Child:

• medication_code_coding
• medication_extension
• medicationadministration
• medicationdispense
• medicationrequest
• medicationstatement

Version diff

Renamed

• rxnorm_code → code_rxnorm_code
• rxnorm_display → code_rxnorm_display
• ndc_code → code_ndc_code
• ndc_display → code_ndc_display
• data_source → meta_source