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 totalepsd_tot

The aggregate numeric or financial value accumulated across a clinical episode of care. May represent total costs, total services rendered, or total units of care delivered during the episode period, supporting episode-based payment models, value-based care analytics, and population health cost reporting.

episode total countepsd_tot_cnt

The cumulative number of occurrences, events, or encounters recorded within a clinical episode of care for a given condition. Used in episode grouping and analytics to measure care intensity, service utilization, and frequency of interventions throughout the episode lifecycle.

episode typeepsd_typ

Classification code categorizing a clinical episode by care setting, condition, or treatment pathway within EHR and care management systems. Used to segment episode grouper outputs, support value-based contract analytics, and drive clinical reporting logic across payer and provider data platforms.

episode updated dateepsd_upd_dt

The most recent date on which a clinical episode of care record was modified, amended, or refreshed in the system. Used to track record currency, support audit trails, and identify episodes requiring review or follow-up action within care management and data governance workflows.

episode urgencyepsd_urg

The clinical time-sensitivity classification assigned to a care episode, indicating the level of immediacy required for treatment or intervention. Supports triage workflows, care prioritization, and episode categorization across emergency, urgent, and elective care settings in clinical management systems.

episode versionepsd_ver

The sequential version number assigned to a clinical episode of care record, indicating how many times the record has been revised or updated. Used to manage record lifecycle, support audit history, and ensure data integrity when episode information is amended across care management platforms.

episode zipepsd_zip

The postal ZIP code associated with a clinical episode of care, typically representing the patient's residential location or the site of care delivery at the time of the episode. Used in geographic analysis, population health reporting, and social determinants of health assessments tied to episode data.

equipment admission dateequip_admn_dt

Date on which durable medical equipment (DME) was admitted or assigned to a facility or patient encounter within healthcare asset management systems. Used to calculate equipment utilization duration, support DME billing timelines, and drive compliance reporting in EHR and claims platforms.

equipment discharge dateequip_dsch_dt

The date a medical apparatus is released from active use at a patient care facility or returned following a clinical episode in EHR and DME claims systems. Used to calculate equipment rental durations and reconcile durable medical equipment billing records in PBM and claims platforms.

equipment labelequip_lbl

The descriptive display text or identifier assigned to a specific piece of medical equipment within clinical or operational systems. Used to facilitate equipment tracking, asset management, maintenance scheduling, and clear identification of devices in clinical workflows, procurement records, and inventory management systems.

equipment procedure dateequip_proc_dt

The date on which a clinical procedure was performed using a specific piece of medical equipment. Used to associate equipment utilization with procedure events, supporting maintenance scheduling, sterilization tracking, device performance monitoring, and regulatory compliance reporting in clinical operations.

equipment surgery dateequip_surg_dt

The date on which a surgical procedure was performed using a specific piece of medical equipment. Used to track operative equipment utilization, support post-surgical device review, and maintain records for sterile processing, manufacturer reporting, and implantable device registry compliance requirements.

evaluation active indicatoreval_actv_ind

A binary flag indicating whether a clinical evaluation or diagnostic assessment is currently active and in use within the system. Used to filter active versus inactive evaluations in clinical workflows, quality reporting, and care management platforms, preventing application of outdated assessments to patient records.

evaluation active statuseval_actv_sts

The current activity state of a clinical evaluation or diagnostic assessment, indicating whether it is active, inactive, pending, or suspended within the care management system. Supports workflow routing, evaluation lifecycle management, and ensures only current assessments are applied in clinical decision-making processes.

evaluation admission dateeval_admn_dt

The date on which a patient was admitted to a facility in connection with a clinical evaluation or diagnostic assessment. Used to establish the evaluation timeline, support inpatient care coordination, and link assessment activities to the admission episode for clinical documentation and billing purposes.

evaluation ageeval_age

The patient's age in years at the time a clinical evaluation or diagnostic assessment was conducted. Used to apply age-appropriate clinical criteria, support stratified reporting, and ensure evaluation tools and scoring benchmarks are aligned with age-specific normative values in clinical and quality measurement programs.

evaluation allowed amounteval_alwd_amt

The maximum reimbursable dollar amount approved by a payer for a clinical evaluation or diagnostic assessment service. Used in claims adjudication and remittance processing to determine payment liability, calculate member cost-sharing obligations, and reconcile provider billing against contracted fee schedule rates.

evaluation amounteval_amt

The monetary value associated with a clinical evaluation or diagnostic assessment, representing the billed, allowed, or paid charge depending on context. Used in healthcare financial systems to support claims processing, cost analysis, budget forecasting, and reimbursement reconciliation for evaluation-related services.

evaluation approved byeval_appr_by

The identifier or name of the authorized user, clinician, or administrator who approved a clinical evaluation or diagnostic assessment. Used to maintain accountability in clinical workflows, support audit trails, ensure appropriate credentialing for evaluation sign-off, and meet regulatory documentation requirements.

evaluation arrival timeeval_arrv_tm

The recorded time at which a patient arrived for a clinical evaluation or diagnostic assessment encounter. Used to measure wait times, assess throughput efficiency, support patient flow analytics, and track compliance with triage and access-to-care standards in outpatient, emergency, and specialty care settings.

PreviousPage 251 of 806Next