Skip to main content
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: Primary Keys:
  • medication_id
† Metriport Platform added
ColumnData TypeDescription
medication_idvarcharUnique identifier for the medication
statusvarcharStatus 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_textvarcharFree-text description of the medication
code_rxnorm_code†varcharRxNorm code for the medication
code_rxnorm_display†varcharHuman-readable description from RxNorm
code_ndc_code†varcharNational Drug Code for the medication
code_ndc_display†varcharHuman-readable description from NDC
meta_sourcevarcharSource document filename from FHIR meta.source
data_source_ext†varcharIntegration source of the data, derived from FHIR extension
Related Tables: Child:

Version diff

Renamed
  • rxnorm_codecode_rxnorm_code
  • rxnorm_displaycode_rxnorm_display
  • ndc_codecode_ndc_code
  • ndc_displaycode_ndc_display
  • data_sourcemeta_source