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 first namealrg_first_nm

The given name of the patient associated with the allergy record. Used to correctly identify and match the individual within clinical and administrative systems, ensuring accurate linkage of documented adverse reaction histories to the correct patient record across healthcare encounters.

allergy flagalrg_flg

A binary indicator field used in EHR and pharmacy data systems to denote the presence or absence of a documented adverse reaction for a patient record. This flag triggers clinical decision support alerts, drug-allergy interaction checks in PBM adjudication engines, and allergy-specific workflows in care management and utilization review platforms.

allergy frequencyalrg_freq

Describes how often a patient experiences allergic reactions or the recurrence pattern of adverse responses to a specific allergen. Captured in clinical documentation to characterize the severity and chronicity of allergic conditions and guide ongoing treatment and monitoring decisions.

allergy full namealrg_full_nm

The complete name of the patient, including first, middle, and last name components, associated with the allergy record. Used in clinical and administrative systems to ensure unambiguous patient identification when displaying or transmitting adverse reaction history documentation.

allergy genderalrg_gndr

The biological sex or gender identity of the patient associated with the allergy record. Used in clinical reporting and population health analysis to identify sex-based differences in allergic disease prevalence, immune response characteristics, and adverse drug reaction profiles.

allergy glucosealrg_gluc

The blood glucose measurement recorded in association with an allergic reaction event or clinical encounter. Captured to assess metabolic status during adverse reaction episodes, particularly relevant for patients with diabetes where allergic responses may affect glycemic control or medication safety.

allergy group numberalrg_grp_nbr

The insurance group plan identifier linked to the patient's allergy record for billing and coverage verification purposes. Used in claims processing to associate allergy-related treatments and services with the correct health plan group when adjudicating benefits for adverse reaction care.

allergy hemoglobinalrg_hgb

The hemoglobin measurement recorded in association with an allergic reaction event or clinical encounter. Captured to monitor hematologic status during adverse reaction episodes, as severe allergic responses such as anaphylaxis can affect blood oxygen-carrying capacity and circulatory function.

allergy history present illnessalrg_hpi

Narrative description of a patient's current allergy-related symptoms and clinical presentation, documented during the encounter. Captures onset, severity, triggers, and progression of allergic reactions to support clinical decision-making and treatment planning in the patient's medical record.

allergy identifieralrg_id

The unique alphanumeric key assigned to an individual adverse reaction or allergy record within an EHR or clinical data system. Used as the primary reference key for allergy records in systems such as Epic and Cerner, and in HL7 FHIR AllergyIntolerance resources to enable accurate cross-system data linking and deduplication.

allergy indexalrg_idx

A numeric positional value assigned to an adverse reaction record within a patient's allergy list, used to order or sequence multiple allergy entries in EHR clinical data structures. Supports data extraction, reporting, and integration processes where allergy records are processed in array or list-based data formats across health information systems.

allergy indicatoralrg_ind

A boolean or coded field designating the presence, absence, or unknown status of a patient's adverse reaction history within clinical and administrative data systems. Used in EHR platforms, PBM drug utilization review engines, and member enrollment systems to drive allergy-related clinical alerts, formulary checks, and population health reporting workflows.

allergy instructionalrg_instr

Clinical guidance text associated with a patient's adverse reaction record, providing direction to care teams on managing or avoiding specific allergens. Stored in EHR allergy modules and transmitted in HL7 v2 NTE or FHIR AllergyIntolerance.note segments, supporting pharmacy dispensing workflows, care plan documentation, and patient safety protocols.

allergy keyalrg_key

Surrogate or natural key value that uniquely identifies an allergy record within the clinical data system. Used to join allergy data across tables in EHR and clinical data warehouse environments, linking patient-specific adverse reaction records to substance, reaction type, and severity reference data.

allergy labelalrg_lbl

Human-readable display text associated with an allergy record, typically representing the allergen name or reaction type as shown in clinical interfaces. Used in patient charts, medication order screens, and clinical summary views to communicate allergy information clearly to care team members.

allergy languagealrg_lang

Language code or descriptor indicating the language in which the allergy record's narrative content is documented. Supports multilingual clinical documentation environments and ensures allergy descriptions, reaction notes, and patient-reported information are stored and displayed in the correct language context.

allergy last namealrg_last_nm

Family surname of the patient or individual associated with the allergy record. Used in clinical systems to confirm patient identity when reviewing or updating adverse reaction histories, supporting accurate matching of allergy records to the correct patient demographic profile.

allergy legal namealrg_legal_nm

Officially registered full legal name of the patient linked to the allergy record. Used for identity verification in clinical and administrative workflows to ensure allergy documentation is accurately attributed to the correct patient, particularly during transitions of care or record reconciliation processes.

allergy levelalrg_lvl

A coded or hierarchical value indicating the severity classification or organizational tier of a documented adverse reaction within an EHR allergy data structure. Used in clinical decision support systems and pharmacy benefit management platforms to stratify allergy severity—such as mild, moderate, or severe—for drug-allergy interaction alerts and care prioritization.

allergy license numberalrg_lic_nbr

Professional license identifier of the clinician who documented or validated the allergy record. Used in clinical audit trails to attribute allergy entries to a licensed healthcare provider, supporting regulatory compliance and accountability in adverse reaction documentation workflows.

PreviousPage 45 of 806Next