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 death datent_death_dt

The date of member or patient death recorded within a clinical documentation entry across EHR, care management, or enrollment systems, used to terminate active care programs, close utilization records, and trigger downstream mortality reporting and member disenrollment workflows in payer platforms.

note deleted datent_del_dt

The date a clinical note was marked as deleted or voided in the EHR system. Retained for audit trail and compliance purposes to document when a record was removed, by whom, and as part of legal health record management and data governance processes.

note deleted indicatornt_del_ind

A boolean flag indicating whether a clinical note has been logically deleted or voided in the EHR. Allows systems to retain the record for audit and compliance purposes while excluding it from active clinical views, supporting data integrity and legal health record standards.

note descriptionnt_desc

The textual explanation summarizing the purpose or content of a clinical documentation entry in EHR, utilization management, or care coordination systems, providing human-readable context for note type classification and supporting searchability across clinical data repositories and reporting dashboards.

note detailnt_dtl

The granular clinical or administrative content captured within a documentation entry across EHR, case management, and payer systems, containing provider observations, treatment rationale, or authorization specifics that feed downstream quality measurement, risk stratification, and clinical decision support workflows.

note discharge datent_dsch_dt

Date value representing the hospital discharge event associated with a specific clinical documentation entry in EHR systems. Used to close inpatient encounter records, reconcile clinical notes with claims discharge dates, and support length-of-stay calculations and care transition documentation workflows.

note due datent_due_dt

The date by which a clinical note or associated documentation task must be completed, used in care management workflows to enforce timely documentation. Supports compliance with regulatory requirements, accreditation standards, and organizational documentation policies.

note durationnt_dur

The length of time associated with a clinical encounter, procedure, or intervention as recorded in a clinical note. Used to support billing accuracy, time-based CPT code assignment, and clinical workflow analysis in EHR and revenue cycle management systems.

note emailnt_eml

The electronic mail address associated with a clinical documentation entry in care management, utilization review, or provider communication systems, capturing the contact used for correspondence related to the note, supporting audit trails and care coordination follow-up tracking in member management platforms.

note emergency indicatornt_emerg_ind

A flag identifying a clinical note as associated with an emergency encounter or urgent clinical situation. Used in EHR systems to prioritize documentation review, trigger escalation workflows, and support triage tracking in emergency department and acute care settings.

note end datent_end_dt

The date marking the conclusion or deactivation of a clinical documentation entry's relevance in EHR, care management, or authorization systems, used to define the close of treatment periods, care plans, or utilization review cycles within slowly changing dimension tables and member timeline analytics.

note end timent_end_tm

The timestamp marking the conclusion of a clinical encounter or documented service as recorded in a clinical note. Used alongside start time to calculate encounter duration, support time-based billing, and validate documentation completeness in EHR systems.

note entered bynt_ent_by

The identifier of the staff member who entered or transcribed a clinical note, which may differ from the note's author or signing clinician. Supports audit trail documentation, transcription tracking, and accountability in clinical data entry workflows within EHR systems.

note ethnicitynt_ethn

The patient's self-reported ethnicity as documented within a clinical note, used to support culturally competent care, population health reporting, and health disparity analysis. Aligns with OMB standards and regulatory requirements for demographic data collection in clinical settings.

note expiration datent_exp_dt

The date after which a clinical documentation entry is no longer considered valid or actionable in EHR, payer authorization, or care management systems, used to retire standing orders, care instructions, or provider attestations and trigger renewal workflows in utilization and compliance monitoring pipelines.

note external identifiernt_ext_id

A reference identifier assigned by an external system to a clinical note, enabling cross-system linkage and data exchange. Used in interoperability workflows such as HIE integrations, interface engines, and care coordination platforms to match notes across disparate EHR and HIS environments.

note faxnt_fax

The fax number associated with a recipient or sender referenced in a clinical note, used when documenting communication events such as referrals, consultation requests, or care transitions that were transmitted via facsimile in clinical and administrative workflows.

note feent_fee

The charge amount associated with a clinical service documented in a note, used in revenue cycle workflows to link clinical documentation to billing records. Supports fee schedule validation, charge capture accuracy, and financial reconciliation in EHR and practice management systems.

note first nament_first_nm

The first name of an individual referenced within a clinical note, such as a patient, guardian, or contact person. Used to identify and distinguish persons documented in clinical records, supporting accurate patient matching and contextual clarity in EHR documentation workflows.

note flagnt_flg

The binary status marker applied to a clinical documentation entry in EHR, care management, or claims systems to indicate conditions such as requiring follow-up, containing PHI concerns, pending review, or triggering alerts, used to filter and route notes through clinical workflow automation and quality review processes.

PreviousPage 425 of 806Next