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 arrived dateintol_arrv_dt

Records the calendar date on which a patient arrived for clinical evaluation of a suspected or known adverse food or drug intolerance reaction. Used to establish the encounter date, support longitudinal tracking, and correlate intolerance episodes with treatment timelines in the patient record.

intolerance assessmentintol_asmt

Contains the clinician's documented clinical evaluation and interpretive findings related to a patient's adverse food or drug intolerance. This narrative or structured text captures diagnostic reasoning, severity assessment, and clinical conclusions recorded during the intolerance evaluation encounter.

intolerance balanceintol_bal

The remaining outstanding financial amount owed following payments or adjustments applied to charges associated with clinical care for an adverse food or drug intolerance. Reflects the net patient or payer liability after insurance payments, write-offs, or credits have been applied to the intolerance-related encounter.

intolerance billed amountintol_bill_amt

The total charges invoiced to a patient or payer for clinical services rendered in connection with the evaluation or management of an adverse food or drug intolerance reaction. Represents the gross billed value prior to insurance adjustments, contractual discounts, or patient payments being applied.

intolerance birth dateintol_birth_dt

Records the patient's date of birth as captured within the adverse food or drug intolerance record. Used to confirm patient identity, support age-appropriate clinical decision making, and ensure accurate matching of intolerance documentation to the correct patient demographic record.

intolerance blood pressureintol_bp

Records the patient's arterial blood pressure measurement documented during clinical evaluation of an adverse food or drug intolerance reaction. Captures systolic and diastolic values used to assess hemodynamic status, monitor severity of the intolerance response, and guide treatment decisions.

intolerance cancelled dateintol_cncl_dt

Records the calendar date on which a previously scheduled or active adverse food or drug intolerance-related encounter, order, or referral was formally cancelled. Used to track workflow changes, support audit trails, and maintain accurate scheduling records within the clinical documentation system.

intolerance categoryintol_cat

Classifies an adverse food or drug intolerance into a defined grouping such as food, medication, environmental, or contrast agent. Supports clinical decision support, allergy reconciliation workflows, and population reporting by organizing intolerance records into standardized categories for analysis and safety alerts.

intolerance chief complaintintol_cc

Documents the primary symptom or reason for presentation as reported by the patient experiencing an adverse food or drug intolerance reaction. This free-text or coded value anchors the clinical encounter narrative and guides the clinician's initial assessment and differential diagnosis during the intolerance evaluation.

intolerance childintol_chld

Identifies a subordinate or dependent intolerance record linked to a parent intolerance entry within a hierarchical data structure. Used to represent component-level reactions, related sub-classifications, or nested intolerance relationships that provide granular detail beneath a primary intolerance record in the clinical system.

intolerance cityintol_city

Records the municipality name associated with the patient or clinical site linked to an adverse food or drug intolerance record. Used for demographic data completeness, geographic reporting, care coordination, and ensuring accurate patient address information within the intolerance documentation record.

intolerance classintol_cls

Identifies the pharmacological or substance classification tier assigned to an adverse food or drug intolerance, such as antibiotic class, NSAID, or shellfish group. Enables cross-reactivity alerts, clinical decision support rules, and reporting by grouping individual intolerances under broader therapeutic or substance class categories.

intolerance codeintol_cd

A standardized coded value, such as SNOMED CT, ICD, or RxNorm, used to identify and classify a specific adverse food or drug intolerance within clinical and administrative systems. Enables interoperability, clinical decision support, cross-system reconciliation, and structured reporting of intolerance records across care settings.

intolerance commentintol_cmt

Free-text field capturing supplementary narrative notes entered by a clinician or staff member regarding a patient's adverse food or drug intolerance record. Used to document nuanced clinical observations, reaction details, historical context, or follow-up instructions that fall outside structured data fields in the intolerance record.

intolerance completed dateintol_cmpl_dt

Records the calendar date on which clinical evaluation, treatment, or documentation workflow associated with a patient's adverse food or drug intolerance episode was formally completed. Used to close encounter records, support quality reporting, and track the full lifecycle of intolerance-related clinical activities.

intolerance confidential indicatorintol_conf_ind

A flag designating that a patient's adverse food or drug intolerance record contains sensitive information subject to restricted access controls. When set, this indicator limits visibility to authorized users only, supporting patient privacy protections, regulatory compliance, and role-based access governance within the clinical documentation system.

intolerance countintol_cnt

Represents the total number of documented adverse food or drug intolerance records, episodes, or reactions associated with a patient or encounter. Used in clinical reporting, population health analytics, and patient safety workflows to quantify intolerance burden and identify patients with multiple or recurring adverse reactions.

intolerance countryintol_ctry

Identifies the country where a patient's food or drug intolerance was documented or diagnosed. Used in EHR systems to support international patient records, cross-border care coordination, and ensures intolerance data is contextualized within the correct regional clinical and regulatory framework.

intolerance created byintol_crtd_by

Captures the unique identifier of the clinical user, such as a physician or nurse, who initially entered a patient's food or drug intolerance record into the EHR. Supports audit trails, accountability tracking, and data provenance across clinical documentation workflows.

intolerance created dateintol_crtd_dt

Records the calendar date on which a patient's food or drug intolerance entry was first created in the clinical system. Essential for audit trails, chronological tracking of patient safety records, and determining when an intolerance became known within the care team's documentation workflow.

PreviousPage 348 of 806Next