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

episode faxepsd_fax

The facsimile number associated with a care episode record, typically used for transmitting clinical documentation, referral authorizations, or discharge summaries between facilities and care team members involved in managing a specific episode of care.

episode feeepsd_fee

The total or component charge amount associated with delivering care within a defined episode, used in bundled payment reconciliation, provider reimbursement calculations, and cost benchmarking. Supports financial performance reporting in episode-of-care and value-based payment arrangements.

episode first nameepsd_first_nm

The given name of the patient or individual associated with a care episode record. Used for patient identification, display purposes in care management workflows, and matching episode records to member or patient demographics across clinical and administrative systems.

episode flagepsd_flg

Boolean indicator applied to eligibility or claims records to denote membership in a defined clinical episode grouping. Used in data pipelines to filter episode-relevant encounters, trigger care management alerts, and segment populations for value-based program reporting in payer and provider analytics systems.

episode full nameepsd_full_nm

The complete legal or preferred name of the patient linked to a care episode record, combining given and family name components. Used for patient identification in care management platforms, episode reporting, and cross-system record matching within clinical and administrative workflows.

episode genderepsd_gndr

The gender identity or biological sex classification of the patient associated with a care episode. Used in clinical decision support, risk stratification, health equity reporting, and epidemiological analysis within episode-of-care management and population health programs.

episode glucoseepsd_gluc

The blood glucose measurement recorded during or associated with a care episode, typically relevant for diabetes, metabolic, or acute care episodes. Used in clinical outcome tracking, chronic disease management programs, and episode-level quality measure reporting.

episode hemoglobinepsd_hgb

The hemoglobin concentration value recorded in association with a care episode, used to monitor anemia, surgical readiness, or chronic disease status. Supports clinical decision-making, episode-level lab result tracking, and quality measure calculations for relevant condition episodes.

episode history present illnessepsd_hpi

A structured or narrative clinical description of the patient's current condition, symptom onset, and progression documented at the start of a care episode. Forms a foundational component of the medical record and informs diagnosis coding, treatment planning, and episode classification.

episode identifierepsd_id

Unique surrogate or natural key assigned to a discrete clinical episode of care within claims processing systems, enabling linkage of related encounters, procedures, and diagnoses. Used in episode grouper engines, bundled payment tracking, and longitudinal patient record assembly across payer and provider data warehouses.

episode indexepsd_idx

Sequential position number assigned to a discrete care episode within a patient's clinical history for a specific condition. Used in clinical data warehouses to order and distinguish multiple episodes of the same condition type, enabling longitudinal analysis of recurring diagnoses or treatments.

episode indicatorepsd_ind

Coded value within billing and claims records designating the role or position of a service within a clinical episode, such as initiating or terminal event. Used in episode grouper algorithms, reimbursement logic, and value-based care analytics to sequence and classify care events in payer data systems.

episode instructionepsd_instr

Structured guidance text associated with a clinical care episode, capturing treatment directives, care plan instructions, or clinical decision support recommendations. Used in EHR systems to communicate episode-specific protocols to care teams managing a patient's condition across encounters.

episode keyepsd_key

Unique lookup reference value that serves as the primary identifier for a clinical care episode within a database or data warehouse. Used to join episode records across related clinical tables, enabling retrieval of all associated diagnoses, encounters, and outcomes for a defined care period.

episode labelepsd_lbl

Human-readable display text assigned to a clinical care episode, providing a descriptive identifier used in clinical interfaces and reports. Enables care teams and analysts to quickly recognize and distinguish episode types, such as acute exacerbation or initial diagnosis, within patient timelines.

episode languageepsd_lang

Preferred communication language recorded in association with a clinical care episode, used to ensure episode-related documentation, instructions, and patient communications are delivered in the patient's preferred language. Supports compliance with language access requirements in care delivery systems.

episode last nameepsd_last_nm

Family surname of the patient associated with a clinical care episode, captured at the time of episode creation for identity matching and record linkage. Used in clinical data systems to verify patient identity when reconciling episode records across multiple encounters or facilities.

episode legal nameepsd_legal_nm

Official registered name of the patient linked to a clinical care episode, used for identity verification and legal documentation purposes. Ensures accurate patient matching in clinical records, insurance claims adjudication, and regulatory reporting where legal identification is required.

episode levelepsd_lvl

Hierarchical classification attribute defining the granularity or tier of a clinical episode within compliance and care management data models, such as condition-level or procedure-level groupings. Used in regulatory reporting, quality measure stratification, and episode-of-care payment model analytics across payer and provider data platforms.

episode license numberepsd_lic_nbr

Professional license identifier of the clinician responsible for overseeing a clinical care episode, used to attribute care accountability and support credentialing validation. Referenced in clinical documentation and audit trails to verify that treating clinicians held valid licensure during the episode period.

PreviousPage 247 of 806Next