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

note frequencynt_freq

The documented frequency of a treatment, medication administration, or follow-up interval recorded within a clinical note. Used in care plan management, medication reconciliation, and chronic disease monitoring to communicate how often an intervention or therapy should occur.

note full nament_full_nm

The complete display name assigned to a clinical note type or template within an EHR system. Used to identify structured documentation entries such as progress notes, discharge summaries, or operative reports in clinical data warehouses and reporting systems.

note gendernt_gndr

The biological sex or gender identity recorded within a clinical note, typically captured during patient encounters. Used to contextualize clinical findings, support sex-specific clinical decision rules, and ensure accurate patient demographics are reflected in documentation workflows.

note glucosent_gluc

The blood glucose measurement value documented within a clinical note, recorded in mg/dL or mmol/L. Captures point-in-time or fasting glucose readings during encounters, supporting diabetes management, metabolic monitoring, and longitudinal trending in clinical data systems.

note group numbernt_grp_nbr

The insurance group identifier captured within or associated with a clinical note, linking the documentation entry to the patient's health plan group. Used to align clinical records with corresponding claims and eligibility data across payer and provider systems.

note hemoglobinnt_hgb

The hemoglobin concentration value documented within a clinical note, typically measured in g/dL. Used to record findings from complete blood count results, supporting anemia diagnosis, transfusion decision-making, and chronic disease monitoring in clinical documentation workflows.

note history present illnessnt_hpi

The narrative section of a clinical note that describes the chronological development of the patient's current chief complaint, including onset, duration, severity, and associated symptoms. Serves as the foundational clinical context for diagnostic reasoning and encounter documentation.

note identifiernt_id

The unique alphanumeric key assigned to each clinical documentation entry within EHR, care management, or utilization review systems, serving as the primary key in note-level data tables and enabling accurate joins to encounter, member, provider, and authorization records across healthcare data warehouses.

note indexnt_idx

The sequential position number assigned to a clinical documentation entry within a series of related notes in EHR or care management systems, used to maintain ordering of multi-part documentation sets, care plan updates, or chronological clinical observations in structured data pipeline processing.

note indicatornt_ind

The boolean or coded flag value representing the presence, status, or condition of a clinical documentation entry in EHR, utilization management, or payer systems, used to signal documentation completeness, clinical alert states, or processing requirements within automated data quality and workflow management pipelines.

note instructionnt_instr

The structured or free-text guidance captured within a clinical documentation entry in EHR, care management, or pharmacy systems, detailing treatment directives, member education content, or care coordination actions that must be executed, tracked for compliance, and linked to clinical outcomes in population health platforms.

note keynt_key

The unique technical identifier or lookup value assigned to a clinical note record within a healthcare data system. Used as a primary or surrogate key to join note records across clinical tables, enabling consistent retrieval and linkage in EHR and data warehouse environments.

note labelnt_lbl

The human-readable display text or short descriptor assigned to a clinical note type, section, or field within the EHR interface. Used to present note metadata in user-facing screens, reporting dashboards, and clinical documentation templates in a clear and standardized format.

note languagent_lang

The written or spoken language in which a clinical note is authored or in which patient communication preferences are recorded. Used to support multilingual documentation workflows, translation services, and ensuring clinical notes align with patient language needs across care settings.

note last nament_last_nm

The family surname of the patient or clinician associated with a clinical note entry. Used to support patient matching, attribution of documentation to the correct author or subject, and display of identity information within EHR and clinical data reporting systems.

note legal nament_legal_nm

The officially registered legal name of the patient or provider associated with a clinical note, as documented in enrollment or credentialing records. Used to ensure documentation accurately reflects verified identity, supporting compliance, legal records management, and patient matching processes.

note levelnt_lvl

Numeric or coded value representing the hierarchical position of a clinical documentation entry within a structured note taxonomy in EHR or care management systems. Used to determine depth in note trees, control display logic, and support recursive queries in healthcare data engineering and reporting workflows.

note license numbernt_lic_nbr

The professional state or federal license identifier of the clinician who authored or cosigned a clinical note. Used to validate practitioner credentials, support regulatory compliance, and link clinical documentation to verified provider licensing records in healthcare data systems.

note marital statusnt_mar_sts

The marital or domestic partnership status of the patient as recorded within a clinical note or associated demographic data. Used to capture social determinants of health, support care coordination, and fulfill documentation requirements for encounter records in clinical and administrative systems.

note master identifiernt_mstr_id

The enterprise-level master identifier assigned to a clinical note, linking the record across disparate clinical systems through a master patient or document index. Used to ensure consistent note identification during data integration, patient record matching, and cross-system clinical data retrieval.

PreviousPage 426 of 806Next