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 primary indicatornt_prim_ind

A flag within a clinical note designating whether an associated diagnosis, provider, insurance plan, or other element is the primary record among multiple entries. Used to drive claims adjudication logic, care coordination workflows, and reporting prioritization in clinical systems.

note prioritynt_prty

Importance or urgency ranking assigned to a clinical documentation entry in EHR, care management, or utilization review systems. Drives workflow routing, escalation rules, and SLA enforcement for note processing. Used by data engineers to filter high-priority clinical events and support real-time alerting in healthcare data pipelines.

note procedure datent_proc_dt

The date on which a clinical procedure, intervention, or treatment was performed, as documented within a clinical note. Critical for claims processing, surgical recordkeeping, operative report linkage, and measuring time-to-treatment metrics in care delivery systems.

note pulsent_pulse

The patient's heart rate in beats per minute recorded as a vital sign within a clinical note. Captured during clinical encounters to assess cardiovascular status, monitor response to treatment, and document baseline or acute changes in a patient's physiological condition.

note quantitynt_qty

Numeric count or volume value associated with a clinical documentation entry in EHR, pharmacy, or care management systems. May represent units of service, medication quantities, or item counts linked to an annotation. Used in supply chain analysis, utilization tracking, and data validation logic within healthcare data engineering platforms.

note racent_race

The patient's self-reported or clinician-documented racial identity captured within a clinical note. Used to support health equity reporting, population health stratification, social determinants of health analysis, and compliance with federal demographic data collection requirements.

note rangent_rng

Minimum and maximum value boundaries associated with a clinical documentation entry in EHR or laboratory systems. Defines acceptable or reference value spans for lab results, vital signs, or dosage parameters noted in the record. Used in data validation, outlier detection, and clinical decision support within healthcare data engineering workflows.

note ratent_rt

The unit price or frequency value assigned to a clinical documentation entry within EHR or clinical data systems. Used by data engineers to quantify billing rates, visit frequencies, or scoring rates associated with structured clinical notes across care settings.

note ratingnt_rtg

A scored or categorical assessment value documented within a clinical note, such as a pain scale score, functional status rating, or quality measure result. Used to quantify patient-reported outcomes, clinical severity, or care quality metrics at the point of documentation.

note rationt_ratio

A proportional or calculated value documented within a clinical note, such as a BMI calculation, medication dosing ratio, or lab result ratio. Used to express clinical relationships between measured values that inform diagnostic interpretation and treatment planning decisions.

note reasonnt_rsn

The coded or free-text explanation captured within a clinical documentation entry in EHR systems such as Epic or Cerner. Identifies the clinical rationale behind a note creation, amendment, or addendum, enabling downstream analysis of documentation patterns and clinical decision support workflows.

note received datent_rcvd_dt

The date on which a clinical note, referral, external record, or related document was received by the healthcare organization. Used to track information exchange timeliness, support care coordination workflows, and measure response times in clinical operations and case management.

note referencent_ref

An external pointer or foreign key linking a clinical documentation entry to related records such as orders, encounters, or prior notes within EHR or clinical data warehouse systems. Used by data engineers to establish cross-document relationships and trace documentation lineage across care episodes.

note resolution datent_resol_dt

The date on which a condition, problem, complaint, or clinical issue documented in a note was resolved or closed. Used in problem list management and longitudinal patient records to mark the end of active conditions and support accurate chronic disease tracking and reporting.

note respirationnt_resp

The patient's respiratory rate in breaths per minute recorded as a vital sign within a clinical note. Documented during patient assessments to evaluate pulmonary function, detect respiratory distress, and establish clinical baselines for monitoring treatment response over time.

note resultnt_rslt

The outcome measurement or finding captured within a clinical documentation entry in EHR systems, such as lab result values, assessment outcomes, or diagnostic conclusions. Used by data engineers to extract discrete result data from unstructured or semi-structured clinical notes for analytics pipelines.

note revisionnt_rev

The version or iteration number of a clinical note, indicating how many times the document has been amended, addended, or updated after initial creation. Used in clinical documentation integrity workflows to maintain audit trails and track changes to the official medical record.

note risknt_rsk

A clinical or administrative risk level assigned within a clinical note, such as fall risk, medication risk, or care management risk stratification score. Used to trigger care interventions, prioritize outreach, and document clinician assessments of patient vulnerability or safety concerns.

note routent_rte

The administration route for a medication or treatment documented within a clinical note, such as oral, intravenous, intramuscular, or topical. Captures how a drug or therapy was delivered to the patient, supporting medication reconciliation, safety checks, and clinical documentation accuracy.

note scorent_scr

The calculated numeric rating derived from a clinical documentation entry, such as pain scale scores, risk stratification values, or screening tool results recorded in EHR systems. Used by data engineers to aggregate and trend scored assessments across patient populations in clinical analytics platforms.

PreviousPage 428 of 806Next