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

encounter identifierenc_id

Unique system-generated or source-assigned key that distinctly identifies a single healthcare service interaction across EHR, claims, and PBM platforms. Used as a primary join key in data integrations, deduplication processes, audit trails, and cross-system encounter reconciliation in analytics pipelines.

encounter indexenc_idx

Numeric position or sequence number assigned to a healthcare service interaction within an ordered set of encounters for a patient or claim. Used in EHR and claims systems to sort, paginate, and reference encounters programmatically during data processing, deduplication, and downstream analytics operations.

encounter indicatorenc_ind

Binary or coded yes/no attribute flagging the presence, type, or status of a condition related to a healthcare service encounter. Used in EHR, claims, and utilization systems to drive conditional processing logic, filter encounter populations, and support quality measure calculations in analytics platforms.

encounter instructionenc_instr

Structured or free-text guidance associated with a healthcare service interaction, such as care directives, billing notes, or processing rules. Used in EHR, claims, and utilization management systems to communicate encounter-specific handling requirements to clinical staff, coders, and automated data processing workflows.

encounter keyenc_key

The surrogate or natural key value used to uniquely identify and retrieve a clinical encounter record within a data warehouse or clinical information system. Serves as the primary join attribute linking encounter data to diagnoses, procedures, providers, and claims records.

encounter labelenc_lbl

A human-readable display text or tag assigned to a clinical encounter for identification within EHR interfaces, reporting dashboards, and clinical workflows. Used to distinguish encounter types, visit categories, or care settings such as inpatient, outpatient, or emergency visits.

encounter languageenc_lang

The preferred spoken or written language of the patient recorded at the time of a clinical encounter. Used to coordinate interpreter services, deliver language-appropriate patient education, and ensure compliance with communication accessibility standards during care delivery.

encounter last nameenc_last_nm

The family surname of the patient associated with a clinical encounter record. Used in conjunction with other demographic fields for patient identity verification, record matching, and accurate linkage of encounter data across EHR, claims, and health information exchange systems.

encounter legal nameenc_legal_nm

The officially registered legal name of the patient as recorded at the time of a clinical encounter. Used for insurance verification, consent documentation, billing, and identity authentication, ensuring alignment between clinical records and legal or government-issued identification documents.

encounter levelenc_lvl

Hierarchical classification attribute within Member Management processes that categorizes a healthcare service encounter by care setting, complexity, or acuity. Used in EHR, claims, and population health platforms to stratify encounters for risk adjustment, utilization reporting, benefit tier assignment, and analytics segmentation.

encounter license numberenc_lic_nbr

The state or federal professional license identifier of the clinician who conducted or supervised a clinical encounter. Used in credentialing verification, claims billing, and regulatory compliance to confirm the rendering provider's authorization to deliver the documented services.

encounter marital statusenc_mar_sts

The legal or self-reported marital status of the patient at the time of a clinical encounter. Used in demographic data collection, social determinants of health assessments, insurance coordination of benefits determinations, and population health reporting across encounter records.

encounter master identifierenc_mstr_id

The enterprise master patient or encounter identifier that uniquely tracks a clinical encounter across all systems within a healthcare organization. Used to support master patient index matching, cross-system record deduplication, and longitudinal care coordination across facilities and data platforms.

encounter maximumenc_max

The upper boundary value defined for a measurable clinical or administrative attribute within an encounter record, such as maximum allowable units, dosage thresholds, or benefit limits. Used in utilization management, clinical decision support rules, and payer authorization workflows.

encounter medical record numberenc_mrn

The unique patient identifier assigned by the healthcare facility that links a specific patient to their encounter record. Used to cross-reference clinical documentation, lab results, and visit history within EHR systems and health information exchanges across care settings.

encounter middle nameenc_mid_nm

The patient's middle name or initial as recorded at the time of the clinical encounter. Used for accurate patient identity matching and demographic verification during registration, admission, and reconciliation processes to reduce duplicate records and prevent patient misidentification.

encounter minimumenc_min

The lower boundary value established for a measurable clinical or administrative metric associated with a healthcare encounter. Used in quality reporting, clinical decision support, and threshold-based alerting to define acceptable ranges for vitals, scores, or utilization metrics.

encounter mobileenc_mob

The patient's mobile phone number captured at the time of the clinical encounter registration. Used to support appointment reminders, post-visit follow-up communications, telehealth scheduling, and care coordination outreach through patient engagement platforms and messaging systems.

encounter modified byenc_mod_by

The system user identifier of the individual who last updated the encounter record in the clinical or administrative system. Used for audit trail compliance, data governance, and accountability tracking to identify who made changes to encounter documentation or associated billing records.

encounter modified dateenc_mod_dt

Timestamp recording the most recent update made to a healthcare encounter record within EHR, claims, or PBM systems. Used to track record change history, support incremental data extraction in ETL pipelines, enforce audit compliance, and identify late corrections affecting claims adjudication or analytics reporting.

PreviousPage 233 of 806Next