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 cancelled datent_cncl_dt

The date on which a previously scheduled or initiated clinical note or associated encounter was formally cancelled in the health record system. Used in scheduling reconciliation, no-show tracking, and care gap identification to flag patients who did not complete planned clinical interactions.

note categorynt_cat

Grouping classification assigned to a clinical documentation entry in EHR or care management platforms, such as progress note, discharge summary, or prior authorization note. Drives routing, access controls, and reporting logic. Used by data engineers to filter and segment note datasets across healthcare analytics systems.

note chief complaintnt_cc

The patient's primary presenting symptom or concern documented at the start of a clinical encounter, recorded in the patient's own words or the clinician's interpretation. Used in clinical documentation, triage workflows, and quality reporting to establish the reason for visit and guide diagnostic workup.

note childnt_chld

Subordinate record in a hierarchical clinical documentation structure within EHR or care management systems. Represents a dependent note linked to a parent entry, such as a sub-task or follow-up annotation. Used to model parent-child note relationships in data pipelines supporting clinical workflow and audit trail analysis.

note citynt_city

The city associated with the patient's address or the clinical facility location recorded within a clinical note or linked encounter record. Used in geographic reporting, care access analysis, and public health surveillance to identify service area demographics and regional patterns in clinical documentation.

note classnt_cls

The classification tier assigned to a clinical documentation entry within EHR and care management systems, categorizing notes as progress notes, discharge summaries, operative reports, or consultation records to support structured retrieval and workflow routing.

note codent_cd

The standardized alphanumeric value assigned to a clinical documentation entry in EHR, utilization management, and care coordination systems, enabling consistent categorization of note types such as SOAP notes, clinical assessments, or authorization comments across data pipelines.

note commentnt_cmt

The unstructured free-text field capturing supplemental clinician or administrator remarks appended to a clinical documentation entry in EHR, case management, or claims adjudication systems, requiring NLP processing or careful handling in downstream analytics pipelines due to PHI sensitivity.

note completed datent_cmpl_dt

The date a clinical note was finalized and marked complete in the EHR. Captures when documentation was closed for a patient encounter, procedure, or assessment, supporting audit trails, compliance tracking, and timely care coordination workflows.

note confidential indicatornt_conf_ind

A flag designating a clinical note as restricted, limiting access to authorized users only. Used in EHR systems to protect sensitive documentation such as behavioral health, substance abuse, or HIV-related records in compliance with privacy regulations including 42 CFR Part 2.

note contactnt_cntct

The recorded communication point associated with a clinical documentation entry in care management or utilization review systems, identifying the provider, member, or facility contact referenced during outreach, authorization requests, or care coordination activities logged within the note record.

note countnt_cnt

The aggregated occurrence number representing the total clinical documentation entries recorded for a member, encounter, or provider within EHR, care management, or claims systems, used in quality analytics, utilization reporting, and identifying documentation completeness gaps.

note countrynt_ctry

The country associated with address or contact information captured within a clinical note, used when documenting international patient history, foreign care events, or cross-border referrals in EHR and clinical data management systems.

note created bynt_crtd_by

The unique identifier of the user who originally authored or initiated a clinical note in the EHR. Used for accountability, audit trail management, and clinical documentation integrity, linking the note to the originating clinician or staff member.

note created datent_crtd_dt

The system-generated timestamp recording when a clinical documentation entry was initially created in an EHR, care management, or utilization management platform, used for audit trails, SLA compliance tracking, and distinguishing creation time from the note's clinical service or effective date.

note created timent_crtd_tm

The exact timestamp when a clinical note was first entered into the EHR system. Supports audit logging, documentation compliance, and workflow analysis by recording the precise moment authorship began, separate from the note service or completion date.

note creatininent_cr

The creatinine lab value documented within a clinical note, reflecting kidney filtration function. Used in care management and chronic disease documentation to track renal health trends, support medication dosing decisions, and monitor patients with CKD or related conditions.

note datent_dt

The calendar date assigned to a clinical documentation entry in EHR, care management, or utilization review systems, representing the date the note content is clinically relevant, which may differ from the system creation or finalization date used in longitudinal member health analytics.

note datetiment_dttm

The combined date and time stamp for a clinical documentation entry in EHR, care coordination, or utilization management systems, enabling precise chronological ordering of clinical events, concurrent note detection, and accurate temporal joins in healthcare data warehouse pipelines.

note dea numbernt_dea_nbr

The DEA registration number of the prescribing clinician associated with a clinical note, particularly relevant in notes documenting controlled substance prescriptions. Used to verify prescriber authorization and maintain regulatory compliance in EHR and pharmacy systems.

PreviousPage 424 of 806Next