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 taxonomy coderxn_tax_cd

A standardized classification code used to categorize the type or nature of a documented physiological reaction within a defined coding taxonomy, such as MedDRA or SNOMED CT. Supports structured adverse event reporting, clinical research, and cross-system reaction data interoperability.

reaction temperaturerxn_temp

The recorded body temperature measurement associated with a documented physiological reaction or adverse event, such as a febrile response to medication or allergen exposure. Used as a clinical indicator of systemic reaction severity and to support diagnostic and treatment decision-making.

reaction termination daterxn_term_dt

The calendar date on which a documented physiological reaction or adverse event was clinically resolved or ceased. Used to calculate reaction duration, assess treatment effectiveness, and update allergy and adverse event records to reflect current patient health status.

reaction timerxn_tm

The specific time of day at which a physiological reaction or adverse event was observed, recorded, or reported during a clinical encounter. Used in conjunction with reaction date fields to construct a precise event timeline for adverse drug reaction analysis and clinical documentation.

reaction timestamprxn_ts

A combined date and time value capturing the precise moment a physiological reaction or adverse event was documented, observed, or transmitted within a clinical system. Used for accurate temporal sequencing of reaction records in EHR audit trails, adverse event reporting, and pharmacovigilance workflows.

reaction titlerxn_ttl

The formal name or heading assigned to a documented adverse reaction or allergy event in a patient's clinical record. Used to identify and distinguish specific reaction entries, such as anaphylaxis or urticaria, within allergy and immunology tracking systems.

reaction totalrxn_tot

The aggregate numeric value representing the combined severity score, dosage threshold, or cumulative measurement associated with a documented adverse reaction. Used in clinical allergy records to summarize reaction data across multiple exposure events or episodes.

reaction total countrxn_tot_cnt

The total number of times a specific adverse reaction or allergic response has been recorded for a patient. Used in clinical allergy and adverse event tracking to identify reaction frequency patterns, high-risk patients, and recurring drug or substance sensitivities.

reaction typerxn_typ

The classification category assigned to an adverse reaction, such as allergic, intolerance, side effect, or idiosyncratic. Used in clinical allergy and medication management systems to differentiate immune-mediated responses from non-immune reactions for appropriate treatment planning.

reaction unitrxn_unt

The standard unit of measure applied to a quantitative adverse reaction observation, such as mg/dL, IgE level, or severity scale unit. Used in clinical allergy and immunology records to ensure consistent interpretation of reaction severity measurements across patient encounters.

reaction updated daterxn_upd_dt

The most recent date on which a documented adverse reaction or allergy record was modified, corrected, or supplemented in the clinical system. Used to maintain an accurate audit trail of changes to patient allergy profiles and support medication safety reviews.

reaction urgencyrxn_urg

The clinical priority level assigned to an adverse reaction indicating how quickly medical intervention is required, such as emergent, urgent, or routine. Used in allergy and clinical decision support systems to triage patients experiencing drug or substance reactions.

reaction valuerxn_val

The discrete quantitative or qualitative measurement recorded for a specific adverse reaction observation, such as a severity score, lab result, or symptom intensity rating. Used in clinical allergy and pharmacovigilance records to document the degree of patient response to a substance.

reaction versionrxn_ver

The sequential version number assigned to an adverse reaction record each time it is updated or revised in the clinical system. Used to track the history of changes to a patient's documented allergy or reaction entry and ensure data integrity across system updates.

reaction ziprxn_zip

The postal ZIP code associated with the geographic location where an adverse reaction event was reported, treated, or occurred. Used in public health surveillance, pharmacovigilance reporting, and adverse event analytics to identify regional patterns in drug or substance reactions.

record copay amountrec_cpay_amt

The fixed out-of-pocket dollar amount a member is required to pay for obtaining medical records or documentation services under their health plan benefit structure. Used in claims and member billing systems to capture patient financial responsibility for administrative health record requests.

referral copay amountref_cpay_amt

The fixed out-of-pocket dollar amount a member is required to pay when receiving care through a specialist referral under their health plan. Captured on referral authorization records and claims to reflect member cost-sharing obligations tied to specialist visit benefits.

refill active indicatorrfll_actv_ind

A binary flag indicating whether a prescription refill authorization is currently active and eligible for dispensing at a pharmacy. Used in pharmacy management systems to control dispensing eligibility and prevent fulfillment of expired, cancelled, or suspended refill authorizations.

refill active statusrfll_actv_sts

The descriptive status value indicating the current activity state of a prescription refill authorization, such as active, on hold, expired, or discontinued. Used in pharmacy and medication management systems to manage dispensing workflows and patient medication continuity.

refill addressrfll_addr

The physical or mailing address associated with a prescription refill request in pharmacy and PBM systems, used to route dispensing to mail-order or retail locations. Data engineers validate refill address fields to ensure accurate claim routing, prevent dispensing errors, and support geographic utilization analytics.

PreviousPage 90 of 100Next