mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data teams.

Back to Glossary

Domain

Pharmacy

NDC codes, dispensing, PBM, RxNorm and formulary management

1,993 pharmacy terms

reaction death daterxn_death_dt

The date on which a patient death occurred that was associated with or attributed to a documented adverse reaction event. Used in pharmacovigilance reporting, mortality analysis, and serious adverse event surveillance to fulfill regulatory obligations and identify safety signals linked to specific substances or treatments.

reaction deductible amountrxn_ded_amt

The portion of reaction-related treatment costs applied toward a member's annual deductible before insurance coverage begins paying benefits. Used in claims adjudication and member cost-sharing calculations to accurately reflect out-of-pocket expenses associated with care received for a documented adverse reaction.

reaction deleted daterxn_del_dt

The calendar date on which an adverse reaction record was flagged for removal or soft-deleted from the clinical or administrative system. Used in audit trail management to document when a record was retracted, supporting data governance, compliance review, and historical accuracy in patient reaction histories.

reaction deleted indicatorrxn_del_ind

A flag indicating whether an adverse reaction record has been marked as deleted or inactivated within the clinical system. Used to support soft-delete functionality, ensuring removed records remain accessible for audit and compliance purposes while being excluded from active clinical displays and reporting workflows.

reaction descriptionrxn_desc

A structured or narrative text field providing a human-readable explanation of the nature, characteristics, and clinical presentation of a documented adverse reaction. Used in allergy records, adverse event reports, and clinical summaries to communicate reaction details to care team members across settings and systems.

reaction detailrxn_dtl

Granular clinical documentation of a patient's physiological response to a substance, treatment, or environmental trigger. Captures specifics such as symptoms, severity, body systems affected, and clinical observations recorded in allergy or adverse event records.

reaction due daterxn_due_dt

The expected or scheduled date by which a documented physiological response requires follow-up clinical assessment, treatment escalation, or resolution review. Used in care management workflows to track pending actions associated with an adverse reaction or allergy event.

reaction durationrxn_dur

The measured or estimated length of time a patient's physiological response persisted following exposure to a trigger substance or clinical event. Captured in allergy and adverse event records to support severity classification and longitudinal clinical analysis.

reaction effective daterxn_eff_dt

The date on which a documented physiological response became clinically active or was first observed. Used in allergy and adverse event records to establish the onset timeline of the reaction for clinical decision-making and longitudinal patient history tracking.

reaction emailrxn_eml

The electronic mail address associated with the clinician, reporter, or contact responsible for documenting or managing a recorded physiological response. Used in adverse event reporting workflows to facilitate communication regarding reaction follow-up or pharmacovigilance activities.

reaction emergency indicatorrxn_emerg_ind

A binary or coded flag identifying whether a documented physiological response to a substance or treatment required emergency intervention. Used in allergy and adverse event records to prioritize clinical alerts, escalate care, and support real-time clinical decision support systems.

reaction end daterxn_end_dt

The calendar date on which a patient's documented physiological response to a substance or clinical trigger was resolved or ceased. Recorded in allergy and adverse event records to define the full temporal span of the reaction for clinical history and severity evaluation.

reaction end timerxn_end_tm

The specific time at which a patient's physiological response to a substance or clinical event concluded. Used alongside reaction end date in adverse event and allergy records to precisely calculate duration and support time-sensitive clinical documentation requirements.

reaction enrollment statusrxn_enrl_sts

Indicates whether the patient or case associated with a documented physiological response is actively enrolled in a clinical trial, adverse event registry, or pharmacovigilance program. Used to determine eligibility and reporting obligations for reaction tracking and regulatory submissions.

reaction entered byrxn_ent_by

Identifies the clinician, pharmacist, or data entry personnel who recorded a physiological response in the clinical system. Captured in allergy and adverse event documentation to support data provenance, audit trail requirements, and accountability in patient safety reporting workflows.

reaction ethnicityrxn_ethn

The self-reported or recorded ethnic background of the patient who experienced a physiological response to a substance or treatment. Used in adverse event and pharmacovigilance analysis to identify demographic patterns in reaction incidence, severity, and population-level risk stratification.

reaction expiration daterxn_exp_dt

The date after which a documented physiological response record is no longer considered clinically current or valid for active decision support. Used in allergy management systems to trigger periodic review and revalidation of reaction records within the patient's longitudinal clinical history.

reaction external identifierrxn_ext_id

A unique reference code assigned by an external system, registry, or reporting body to identify a documented physiological response. Enables cross-system linkage of adverse event and allergy records across EHR platforms, pharmacovigilance databases, and regulatory reporting environments.

reaction faxrxn_fax

The facsimile number associated with the reporting clinician, facility, or contact managing a documented physiological response. Used in adverse event reporting workflows where fax transmission is required for regulatory submissions, specialist referrals, or pharmacovigilance communications.

reaction feerxn_fee

The charge associated with clinical evaluation, treatment, or documentation services rendered in response to a patient's physiological reaction to a substance or treatment. Referenced in billing and claims data to link adverse event management encounters to associated healthcare service costs.

PreviousPage 85 of 100Next