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 legal nameintol_legal_nm

The patient's official registered name as it appears on legal or government-issued identification, associated with a food or drug intolerance record. Ensures accurate patient matching and identity verification when reconciling intolerance data across clinical systems.

intolerance levelintol_lvl

Indicates the severity or classification hierarchy of a documented food or drug intolerance, such as mild, moderate, or severe. Used in clinical decision support and care planning to prioritize patient safety interventions and communicate risk levels to care teams.

intolerance license numberintol_lic_nbr

The professional license identifier of the clinician who documented or verified a patient's food or drug intolerance. Provides an auditable reference to the licensed healthcare professional responsible for the intolerance record within clinical documentation systems.

intolerance marital statusintol_mar_sts

The patient's marital status recorded in association with a food or drug intolerance entry. Supports complete patient demographic profiling within clinical records and may be used for social history context during care coordination and intolerance documentation workflows.

intolerance master identifierintol_mstr_id

The enterprise-level unique identifier assigned to a patient's food or drug intolerance record, enabling consistent tracking across disparate healthcare systems. Used in master patient index linking and cross-facility data exchange to prevent duplicate intolerance entries.

intolerance maximumintol_max

The upper threshold value associated with a food or drug intolerance, such as the maximum tolerated dose or exposure limit before an adverse reaction occurs. Used in clinical decision support to define safe boundaries for prescribing or dietary planning for affected patients.

intolerance middle nameintol_mid_nm

The patient's middle name or initial associated with a documented food or drug intolerance record. Supports accurate patient identity matching and disambiguation in clinical systems where multiple patients may share similar first and last names.

intolerance minimumintol_min

The lower threshold value associated with a food or drug intolerance, representing the minimum exposure level at which an adverse reaction may be triggered. Used in clinical decision support to guide prescribing limits and dietary restrictions for patients with documented intolerances.

intolerance mobileintol_mob

The patient's mobile phone number recorded in association with a food or drug intolerance record. Supports outreach and notification workflows where clinicians or care coordinators need to contact patients regarding intolerance-related medication changes or dietary guidance.

intolerance modified byintol_mod_by

The unique identifier of the user or clinician who last updated a patient's food or drug intolerance record. Provides an audit trail for tracking changes to intolerance documentation, supporting accountability and data integrity in clinical and administrative workflows.

intolerance modified dateintol_mod_dt

The calendar date on which a patient's food or drug intolerance record was most recently updated. Supports audit trail requirements and clinical data governance by establishing a temporal reference for changes made to intolerance documentation across healthcare systems.

intolerance modified timeintol_mod_tm

The precise timestamp at which a patient's food or drug intolerance record was last updated. Used alongside the modified date to provide a complete audit trail for changes, supporting data integrity reviews and chronological tracking of intolerance record updates.

intolerance nameintol_nm

The human-readable name of the specific substance, food, or drug to which a patient has a documented intolerance. Displayed in clinical summaries, medication reconciliation workflows, and patient-facing records to clearly identify the offending agent and communicate risk.

intolerance noteintol_nt

Free-text annotation providing supplementary clinical details about a patient's food or drug intolerance, such as reaction descriptions, contextual observations, or management instructions. Used by clinicians to capture nuanced information not represented by structured intolerance data fields.

intolerance numberintol_nbr

A system-generated or manually assigned reference number uniquely identifying a patient's food or drug intolerance record. Used to track, retrieve, and cross-reference intolerance entries across clinical documentation, reporting systems, and interoperability exchanges.

intolerance onset dateintol_onset_dt

The date on which a patient first experienced symptoms or reactions associated with a documented food or drug intolerance. Critical for clinical history accuracy, helping providers assess duration of the condition and correlate intolerance development with medication or dietary changes.

intolerance oxygen saturationintol_o2sat

The patient's blood oxygen saturation level recorded in association with a food or drug intolerance reaction event. Used to document clinical severity of adverse responses, particularly in cases where respiratory compromise is a known symptom of the identified intolerance.

intolerance paid amountintol_pd_amt

The dollar amount paid for healthcare services related to a documented food or drug intolerance reaction. Captured in claims or billing systems to track financial reimbursement associated with intolerance-related encounters, treatments, or medications dispensed.

intolerance paid dateintol_pd_dt

The date on which payment was issued for a claim or service associated with a documented food or drug intolerance. Used in claims processing and financial reconciliation to establish payment timelines and support audit trails for intolerance-related reimbursements.

intolerance parentintol_prnt

Identifies the higher-level hierarchical record or category to which a specific food or drug intolerance entry belongs. Used in clinical data systems to establish relationships between intolerance subtypes and their broader substance classifications, supporting structured allergy and intolerance hierarchies.

PreviousPage 351 of 806Next