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

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

allergy phonealrg_ph

Telephone contact number associated with an adverse reaction record, typically referencing the reporting provider, pharmacy, or clinical contact documented within EHR allergy modules. Used in care coordination workflows and audit trails within Epic, Cerner, and interoperability data exchange pipelines.

allergy planalrg_pln

The documented treatment and management strategy associated with a patient's allergy record, outlining clinical interventions, avoidance protocols, and emergency response steps such as epinephrine use for severe reactions like anaphylaxis recorded in the EHR.

allergy policy numberalrg_pol_nbr

A unique identifier linking a patient's allergy record to a specific institutional or clinical policy governing allergy documentation, review, and management protocols within the EHR or clinical data warehouse for auditing and compliance tracking.

allergy preferred namealrg_pref_nm

The standardized or clinician-preferred display name for an allergen as shown in clinical interfaces, patient records, and medication safety alerts. May differ from coded terminology names to ensure clarity at the point of care in the EHR.

allergy pricealrg_prc

The cost associated with allergy-related clinical services, testing, or treatment recorded against a patient's allergy record. Used in clinical and billing workflows to track expenses tied to allergy evaluation, immunotherapy, or desensitization procedures.

allergy primary indicatoralrg_prim_ind

A flag identifying whether an allergy record is the primary or principal adverse reaction on file for a patient. Used in clinical decision support and medication safety systems to prioritize critical allergy alerts during prescribing and dispensing workflows.

allergy priorityalrg_prty

Importance ranking assigned to an adverse reaction record indicating the urgency or clinical significance of the allergy within EHR alert and clinical decision support systems. Used in Epic and Cerner to control alert firing order, override workflows, and ensure life-threatening allergies surface prominently during medication ordering.

allergy procedure datealrg_proc_dt

The date on which an allergy-related clinical procedure was performed, such as allergy skin testing, immunotherapy administration, or desensitization. Used to sequence care events and establish clinical timelines within the patient's allergy history in the EHR.

allergy pulsealrg_pulse

The patient's pulse rate recorded at the time of an allergic reaction event or allergy assessment encounter. This vital sign documents the cardiovascular impact of the reaction and supports clinical evaluation of reaction severity in the patient's allergy history.

allergy quantityalrg_qty

Count or volume measure associated with an adverse reaction event or documented allergen exposure in EHR and pharmacy data systems. May represent the number of documented reactions, allergen dose thresholds, or substance quantity involved in a reaction event used for clinical risk stratification and PBM safety edits.

allergy racealrg_race

The patient's self-reported racial classification associated with their allergy record. Used in population health analytics and clinical research to identify demographic patterns in allergy prevalence, reaction severity, and treatment outcomes across patient populations.

allergy rangealrg_rng

Value span defining the lower and upper boundaries of a measurable attribute within an adverse reaction record, such as tolerated allergen dose thresholds or reaction severity scales. Used in EHR clinical decision support and analytics platforms to evaluate patient-specific allergy sensitivity parameters.

allergy ratealrg_rt

Unit-based numeric value associated with an adverse reaction record, representing frequency of reaction occurrence, incidence rate within a population, or cost-per-event for allergy-related care. Used in EHR analytics, PBM reporting, and claims adjudication systems to assess allergy burden and associated healthcare utilization.

allergy ratingalrg_rtg

A clinical assessment score or severity rating assigned to a patient's allergic reaction, reflecting the intensity of the adverse response. Used to stratify patients by reaction severity, guide treatment decisions, and flag high-risk allergy profiles in the EHR.

allergy ratioalrg_ratio

A calculated proportional value associated with an allergy record, such as the ratio of allergen-specific IgE to total IgE from diagnostic testing. Used in clinical documentation to quantify immune sensitivity and support allergy diagnosis and treatment planning.

allergy reasonalrg_rsn

Explanatory text field documenting the clinical rationale or context behind an adverse reaction entry in EHR allergy modules. Captures provider-documented justification for allergy additions, modifications, or overrides in Epic and Cerner, supporting audit trails and quality review in healthcare data governance workflows.

allergy received datealrg_rcvd_dt

The date on which an allergy record, report, or external allergy documentation was received into the clinical system. Used to track data provenance and ensure allergy information transferred from outside facilities is accurately timestamped in the patient's EHR.

allergy referencealrg_ref

External pointer or identifier linking an adverse reaction record to a source system, clinical guideline, formulary, or cross-referenced data object in EHR and PBM platforms. Used to associate allergy entries with RxNorm, NDF-RT, or SNOMED CT terminology standards in interoperability and data integration pipelines.

allergy resolution datealrg_resol_dt

The date on which a patient's documented allergy or allergic condition was determined to have resolved, become inactive, or was clinically ruled out. Used to maintain accurate, current allergy records and remove outdated alerts from active clinical decision support systems.

allergy respirationalrg_resp

The patient's respiratory rate recorded during an allergic reaction event or allergy-related clinical encounter. Captures breathing abnormalities such as wheezing or bronchospasm associated with the reaction, supporting clinical severity assessment in the patient's allergy history.

PreviousPage 47 of 806Next