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

evaluation arrived dateeval_arrv_dt

Records the date and time a patient physically arrived for a scheduled diagnostic or clinical evaluation appointment. Used in clinical workflows to measure punctuality, calculate wait times, and track throughput metrics within care delivery settings.

evaluation assessmenteval_asmt

Contains the clinician's written findings, interpretations, and conclusions documented during a diagnostic evaluation encounter. Captures structured or free-text clinical reasoning that forms the basis for diagnosis, treatment planning, and care coordination decisions in the patient record.

evaluation balanceeval_bal

Represents the remaining unpaid dollar amount owed for a completed diagnostic evaluation after applying insurance payments, adjustments, and patient credits. Used in revenue cycle management to track outstanding receivables and drive patient billing follow-up workflows.

evaluation billed amounteval_bill_amt

Captures the total dollar amount submitted to a payer or patient for services rendered during a diagnostic evaluation encounter. Reflects gross charges before contractual adjustments, insurance payments, or write-offs are applied in the revenue cycle billing process.

evaluation birth dateeval_birth_dt

Records the patient's date of birth as captured or verified at the time of a diagnostic evaluation encounter. Used to confirm patient identity, calculate age-based clinical thresholds, and satisfy demographic documentation requirements in the clinical and billing record.

evaluation blood pressureeval_bp

Records the systolic and diastolic arterial pressure measurement, typically expressed in mmHg, obtained during a diagnostic evaluation encounter. Serves as a key vital sign used in clinical decision-making, risk stratification, and longitudinal monitoring of cardiovascular and overall patient health status.

evaluation cancelled dateeval_cncl_dt

Records the date on which a scheduled diagnostic evaluation appointment was formally cancelled by the patient, clinician, or facility. Used in scheduling analytics to track cancellation patterns, calculate no-show rates, and support capacity planning and appointment utilization reporting.

evaluation categoryeval_cat

Classifies a diagnostic evaluation into a defined grouping such as behavioral health, physical therapy, or specialty assessment. Used to organize evaluation records for clinical reporting, operational workflow routing, and population health segmentation across care settings.

evaluation chief complainteval_cc

Captures the patient's primary reported symptom, concern, or reason for seeking a diagnostic evaluation, typically recorded in the patient's own words or as summarized by the clinician. Drives clinical triage, documentation requirements, and coding specificity for the encounter.

evaluation childeval_chld

Identifies a subordinate or dependent evaluation record linked to a parent evaluation in a hierarchical data structure. Used to represent component assessments, follow-up evaluations, or sub-tasks that are associated with and governed by a primary evaluation encounter record.

evaluation cityeval_city

Stores the city or municipality where a diagnostic evaluation was performed or where the patient resides as captured during the evaluation encounter. Used in geographic analysis, care access reporting, and population health assessments tied to service delivery location data.

evaluation classeval_cls

Designates the classification tier or service level assigned to a diagnostic evaluation, such as urgent, routine, or specialized. Used to prioritize scheduling, allocate clinical resources, and segment evaluation data for operational and quality reporting across care settings.

evaluation codeeval_cd

Stores the standardized alphanumeric code identifying the type or nature of a diagnostic evaluation, such as a CPT or facility-defined code. Used as a primary reference to classify, route, and report evaluation encounters across clinical, operational, and billing systems.

evaluation commenteval_cmt

Contains unstructured free-text notes or annotations entered by clinical or administrative staff in relation to a diagnostic evaluation encounter. Used to capture contextual details, special instructions, or clarifying information that cannot be represented in structured data fields alone.

evaluation completed dateeval_cmpl_dt

Records the date on which a diagnostic evaluation was fully completed and all required clinical documentation was finalized. Used to measure turnaround times, track compliance with completion benchmarks, and trigger downstream workflows such as result notification or billing submission.

evaluation confidential indicatoreval_conf_ind

A binary flag designating that a diagnostic evaluation record contains sensitive information requiring restricted access, such as behavioral health, substance use, or reproductive health data. Governs data visibility rules and access controls to ensure compliance with applicable privacy regulations.

evaluation counteval_cnt

Represents the total number of diagnostic evaluation encounters recorded for a patient, program, or reporting period. Used in utilization analysis, caseload reporting, and quality metrics to quantify evaluation volume across clinical populations and service delivery contexts.

evaluation countryeval_ctry

Stores the country associated with the location where a diagnostic evaluation was performed or the patient's address as documented during the encounter. Used in international patient reporting, geographic segmentation, and compliance with cross-border healthcare data standards.

evaluation created byeval_crtd_by

Identifies the username or system identifier of the individual or automated process that initially created the diagnostic evaluation record in the clinical system. Used for audit trail purposes, data provenance tracking, and accountability in clinical documentation workflows.

evaluation created dateeval_crtd_dt

Records the date and time the diagnostic evaluation record was first created in the clinical system, which may differ from the actual date of service. Used for audit logging, data lineage tracking, and identifying documentation lag in clinical and administrative reporting workflows.

PreviousPage 252 of 806Next