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

intolerance external identifierintol_ext_id

Stores a reference identifier assigned by an external system to a patient's food or drug intolerance record. Enables cross-system data exchange and reconciliation of intolerance records between EHRs, health information exchanges, and third-party clinical data repositories.

intolerance faxintol_fax

Records the fax number associated with the reporting clinician or facility that documented a patient's food or drug intolerance. Supports communication workflows when transmitting intolerance documentation between healthcare facilities, referral offices, or pharmacies.

intolerance feeintol_fee

Captures any service charge associated with the clinical assessment, documentation, or management of a patient's food or drug intolerance. May be referenced in billing workflows to associate intolerance-related clinical services with corresponding charges in healthcare financial systems.

intolerance first nameintol_first_nm

Stores the first name of the patient or clinician associated with a documented food or drug intolerance record. Used to identify and display the relevant individual in clinical workflows and reporting within EHR and healthcare information systems.

intolerance flagintol_flg

A binary indicator that marks whether a patient has an active food or drug intolerance on their clinical record. Triggers alerts and warnings within EHR clinical decision support systems to prevent inadvertent exposure to substances known to cause adverse reactions.

intolerance frequencyintol_freq

Describes how often a patient experiences adverse reactions related to a documented food or drug intolerance. Supports clinical assessment of reaction patterns and informs care planning decisions regarding substance avoidance and monitoring protocols in EHR systems.

intolerance full nameintol_full_nm

The complete display name for a documented food or drug intolerance record, combining all relevant name components. Used in clinical reports, patient-facing documentation, and EHR interfaces to present a human-readable identifier for the specific intolerance entry.

intolerance genderintol_gndr

Records the patient's gender associated with a documented food or drug intolerance. Supports demographic analysis, clinical research, and population health reporting to identify gender-based patterns in adverse food or drug responses within healthcare data systems.

intolerance glucoseintol_gluc

Captures blood glucose measurements relevant to a patient's documented food intolerance, particularly for dietary intolerances such as lactose or gluten that may impact metabolic function. Supports clinical monitoring and chronic disease management workflows in EHR systems.

intolerance group numberintol_grp_nbr

Identifies the insurance group associated with a patient's documented food or drug intolerance record. Used to link intolerance documentation to the patient's coverage group for reporting, care management coordination, and health plan population tracking purposes.

intolerance hemoglobinintol_hgb

Records hemoglobin values relevant to a patient's documented food or drug intolerance, particularly useful for conditions such as gluten intolerance or celiac disease where anemia may be a clinical indicator. Supports laboratory result tracking in EHR clinical workflows.

intolerance history present illnessintol_hpi

Contains the clinical narrative describing the onset, progression, and context of a patient's food or drug intolerance as reported during the clinical encounter. Provides the chronological patient history that supports diagnosis and documentation of the adverse substance response.

intolerance identifierintol_id

The unique system-generated or assigned identifier for a specific food or drug intolerance record within the clinical data system. Serves as the primary key for referencing, retrieving, and linking intolerance data across EHR modules, clinical decision support, and reporting systems.

intolerance indexintol_idx

Represents the sequential or positional number assigned to a food or drug intolerance record within a patient's clinical history. Used to order and reference multiple intolerance entries for a single patient in EHR display, reporting, and data processing workflows.

intolerance indicatorintol_ind

A boolean or coded value that denotes the presence, absence, or status of a patient's food or drug intolerance in the clinical record. Drives clinical decision support logic, medication screening alerts, and dietary restriction workflows within EHR and pharmacy systems.

intolerance instructionintol_instr

Contains clinical guidance or care directives associated with a patient's documented food or drug intolerance, such as substances to avoid or emergency response protocols. Supports safe patient care by communicating critical management information to clinicians and care teams.

intolerance keyintol_key

A coded lookup value used to reference and categorize a food or drug intolerance record within clinical data systems. Enables standardized retrieval, cross-referencing, and integration of intolerance data across EHR modules, health information exchanges, and reporting environments.

intolerance labelintol_lbl

The standardized display text used to present a documented food or drug intolerance in clinical interfaces and patient records. Ensures consistent terminology when rendering intolerance details across EHR screens, clinical summaries, and care transition documents.

intolerance languageintol_lang

The preferred language in which a patient's food or drug intolerance information is documented or communicated. Supports multilingual clinical workflows by ensuring intolerance details are presented in the patient's primary language during care interactions and documentation.

intolerance last nameintol_last_nm

Captures the patient's family surname associated with a documented food or drug intolerance record. Used to link the intolerance entry to the correct patient identity during clinical reconciliation, ensuring accurate attribution within EHR and clinical data systems.

PreviousPage 350 of 806Next